This document provides information on the Murrey Math Calculator for Excel, including:
- Instructions for entering values into the calculator for demonstration purposes.
- An explanation of the frame system used by the calculator to determine the "natural" frame that a given number falls within on a scale.
- A formula for calculating the specific frame line (lower or higher) that a number is closest to.
- Examples demonstrating how the frame system works for different numbers on a 1000 point scale.
- A brief explanation of how to calculate the "waist" or average of a candlestick's open, high, low and close prices.
This document provides information on the Murrey Math Calculator for Excel, including:
- Instructions for entering values into the calculator for demonstration purposes.
- An explanation of the frame system used by the calculator to determine the "natural" frame that a given number falls within on a scale.
- A formula for calculating the specific frame line (lower or higher) that a number is closest to.
- Examples demonstrating how the frame system works for different numbers on a 1000 point scale.
- A brief explanation of how to calculate the "waist" or average of a candlestick's open, high, low and close prices.
This document provides information on the Murrey Math Calculator for Excel, including:
- Instructions for entering values into the calculator for demonstration purposes.
- An explanation of the frame system used by the calculator to determine the "natural" frame that a given number falls within on a scale.
- A formula for calculating the specific frame line (lower or higher) that a number is closest to.
- Examples demonstrating how the frame system works for different numbers on a 1000 point scale.
- A brief explanation of how to calculate the "waist" or average of a candlestick's open, high, low and close prices.
This document provides information on the Murrey Math Calculator for Excel, including:
- Instructions for entering values into the calculator for demonstration purposes.
- An explanation of the frame system used by the calculator to determine the "natural" frame that a given number falls within on a scale.
- A formula for calculating the specific frame line (lower or higher) that a number is closest to.
- Examples demonstrating how the frame system works for different numbers on a 1000 point scale.
- A brief explanation of how to calculate the "waist" or average of a candlestick's open, high, low and close prices.
Download as XLS, PDF, TXT or read online from Scribd
Download as xls, pdf, or txt
You are on page 1/ 3
Murrey Math Calculator for Excel version 1.
3 Dec 1999 enter your values here ** for demonstration purposes only ** High 1092.00 Scale Frame 1000 Frame Hgt 4 ** output is NOT guaranteed ** Low 1085.00 Scale Interval 1.953 Frame Intvl 0.977
bMML mMML MMML MML
Frame MMI's 1.953125 15.625 125 125 125 1000 1109.375 1125 1 = 1125 +2/8 1095.70 0 1 6.125 0.765625 +1/8 1094.73 4 6.0625 0.7578125 8/8 1093.75 0 0 6 6 6 0.75 7/8 1092.77 4 5.9375 0.7421875 6/8 1091.80 0 7 5.875 0.734375 5/8 1090.82 4 5.8125 0.7265625 4/8 1089.84 0 6 5.75 0.71875 3/8 1088.87 4 5.6875 0.7109375 2/8 1087.89 0 5 5.625 0.703125 1/8 1086.91 4 5.5625 0.6953125 0/8 1085.94 0 4 5.5 0.6875 -1/8 1084.96 4 5.4375 0.6796875 -2/8 1083.98 0 3 5.375 0.671875 1078.125 1000 0 = 1000 Frames Given a value N, where is it inside frame F? 100000 10000 Where in Frame = WIF = (( n / f ) - Int( n / f)) * 8 1000 integer part tells which frame it is in 100
Next best lower and higher "natural" frame line for number
lower int( n / f ) * f + int(wif) * ( f / 8 )
higher int( n / f ) * f + (int(wif)+1) * ( f / 8 )
