[EquisMetaStock Group] Re: Low Value, 3 days prior to HHV h 10 days

[bellamy_29m@xxxxxxxxx]

.. of course it wont... I should have tested this instead of writing 
it off the top of my head.  Mea Culpa

This might be more useful:

If(H=HHV(H,100),Ref(L,-3),0)

or maybe

If(H=HHV(H,100),Ref(L,-3),PREV)

Hope this helps.

wabbit :)

--- In equismetastock@xxxxxxxxxxxxxxx, bellamy_29m@xxxx wrote:
> Would something like:
> 
> ValueWhen(1,H=HHV(H,10),Ref(L,-3))
> 
> solve your problem?
> 
> Hope this helps.
> 
> wabbit :)
> 
> 
> --- In equismetastock@xxxxxxxxxxxxxxx, "great2sail" 
<sailingon@xxxx> 
> wrote:
> > I want to show the Value of the Low, 3 days proir to the Highest 
> > High value in the last 10 days
> > 
> > This will be in a Column of an Exploration and will be called on 
by 
> > the Filter.
> > 
> > It sounds simple but I cant make it work.
> > 
> > Can anyone help me with a solution to this.
> > 
> > Thanks in advance
> > 
> > Graham



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
     http://groups.yahoo.com/group/equismetastock/

<*> To unsubscribe from this group, send an email to:
     equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
     http://docs.yahoo.com/info/terms/