Scribd Logo
Upload

Welcome to Scribd!

  • 18 views

    MurreyMathCalculator, Version 1.3 (Dec 1999)

    Uploaded by

    Mojtaba Talebvand
    The document describes a Murrey Math Calculator for Excel that can be used to analyze financial data. It provides examples of how to calculate the scale and intervals of a frame, determine where a value falls within a frame, and find the next best lower and higher frame lines for a given number. It also demonstrates how to calculate the 'waist' or average of the open and close price of a candlestick.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    MurreyMathCalculator, Version 1.3 (Dec 1999)

    Uploaded by

    Mojtaba Talebvand
    18 views2 pages
    The document describes a Murrey Math Calculator for Excel that can be used to analyze financial data. It provides examples of how to calculate the scale and intervals of a frame, determine where a value falls within a frame, and find the next best lower and higher frame lines for a given number. It also demonstrates how to calculate the 'waist' or average of the open and close price of a candlestick.

    Original Description:

    6

    Original Title

    MurreyMathCalculator, Version 1.3 (Dec 1999)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes a Murrey Math Calculator for Excel that can be used to analyze financial data. It provides examples of how to calculate the scale and intervals of a frame, determine where a value falls within a frame, and find the next best lower and higher frame lines for a given number. It also demonstrates how to calculate the 'waist' or average of the open and close price of a candlestick.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    18 views2 pages

    MurreyMathCalculator, Version 1.3 (Dec 1999)

    Uploaded by

    Mojtaba Talebvand
    The document describes a Murrey Math Calculator for Excel that can be used to analyze financial data. It provides examples of how to calculate the scale and intervals of a frame, determine where a value falls within a frame, and find the next best lower and higher frame lines for a given number. It also demonstrates how to calculate the 'waist' or average of the open and close price of a candlestick.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 2

    Murrey Math Calculator for Excel version 1.

    3 Dec 1999
    enter your values here ** for demonstration purposes only **
    High 1976.00 Scale Frame 1000 Frame Hgt 4 ** output is NOT guaranteed **
    Low 1504.00 Scale Interval 125.000 Frame Intvl 62.500

    bMML mMML MMML MML


    Frame MMI's 125 125 125 1000
    2140.625 2250
    +2/8 2125.00 0 0 0 1 1
    +1/8 2062.50 4 4 4 0.5
    8/8 2000.00 0 0 0 0 0
    7/8 1937.50 4 4 4 7.5
    6/8 1875.00 0 0 0 7 7
    5/8 1812.50 4 4 4 6.5
    4/8 1750.00 0 0 0 6 6
    3/8 1687.50 4 4 4 5.5
    2/8 1625.00 0 0 0 5 5
    1/8 1562.50 4 4 4 4.5
    0/8 1500.00 0 0 0 4 4
    -1/8 1437.50 4 4 4 3.5
    -2/8 1375.00 0 0 0 3 3
    1375 1375
    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 )

    Example N F WIF Lower Higher


    433 1000 3.464 3 = 375 4 = 500
    800 1000 6.4 6 = 750 7 = 875
    3249 1000 1.992 1 = 3125 2 = 3250
    3251 1000 2.008 2 = 3250 3 = 3375
    11333 10000 1.0664 1 = 11250 2 = 12500

    ======== ======== ======== ======== ======== ======== ======== ======== ==============

    "Waist" of price in candlestick

    avg of open and close


    open 1298.06
    high 1342.47
    low 1298.06
    close 1342.43
    Waist = 1320.25

    You might also like