in Search

How to find the highest price in 1 year ?

Last post 03-30-2008, 21:20 by johnl. 2 replies.
Sort Posts: Previous Next
  •  03-03-2008, 2:38 26616

    How to find the highest price in 1 year ?

    How to find the highest price in 1 year ?

    I used the max syntax but  it couldnt ? who can help me ?

    Thank you !
  •  03-03-2008, 18:26 26620 in reply to 26616

    Re: How to find the highest price in 1 year ?

    Have a look at the function HHV - that should do what you want.

    Note also that MetaStock works on trading days aka bars.  There are roughly 250 bars in a year and this varies according to holidays etc.

    Cheers,
    Richard.



    www.premiumdata.net
  •  03-30-2008, 21:20 26800 in reply to 26620

    Re: How to find the highest price in 1 year ?

        For a specific year you might try:
    a1:=If(Year()=2006 AND C>PREV,C,PREV);
    a2:=LastValue(a1);
    a2
      Ugly but it works (I think).
     
View as RSS news feed in XML