|
PureBytes Links
Trading Reference Links
|
The PREV function is a very poor way to create self referencing
features, that every other programming language except MS handles
easily.
Trying to put it in simple terms, it is the PREVious value of a
function. But then, I hear you ask, what is the difference between
PREV and Ref(myFunction,-1)? Isn't the Ref function looking at the
last value before this one?
Isn't MS wondeful? NOT!
</cynicism>
The MS Formula Primer is helpful here.
wabbit :D
--- In equismetastock@xxxxxxxxxxxxxxx, "Alan Davidson"
<alan_davidson22@xxxx> wrote:
> In a complex formula, how do I determine which part of the formula
> will be operated on by PREV?
>
> Here are some parameters and their results for three consecutive
bars:
> H+L+C; 259.40 256.37 252.54
> H+L+C+PREV; 520.42 776.79 1029.33
> H+L+(C+PREV); 520.42 776.79 1029.33
> PREV+H+L+C; 520.42 776.79 1029.33
>
> I can't make any sense out of these results:
>
> 1) PREV has the same effect irrespective of position in the
formula.
> 2) It seems to me that the second value of H+L+C+PREV should be
> 515.77, which is 259.40+256.37
>
> Please advise.
>
> Regards,
> Alan
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/BefplB/TM
---------------------------------------------------------------------~->
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/
|