Think logically about what the expression is saying. Ref(TimeNum() == 73000, -1) is saying when the previous bar was 7:30:00, so the whole expression is saying give me the value of TimeNum() when the previous bar was 7:30:00. With 5 minute data that will be 7:35:00 (because then the bar before that would have been 7:30:00).
Similarly for the other two expressions. Regards, GP --- In [email protected], "troll" <[EMAIL PROTECTED]> wrote: > > I'm puzzled over the values the following example formulas return: > > x = ValueWhen( Ref(TimeNum()==73000,-1), TimeNum() ); Returns 73500 > x = ValueWhen( Ref(TimeNum()==73000,0), TimeNum() ); Returns 73000 > x = ValueWhen( Ref(TimeNum()==73000,1), TimeNum() ); Returns 72500 > > I thought that the Ref function used -1 to shift reference to a past > value while a positive number refers to a future array value but the > opposite occurs in the above formulas. Not sure why the results are > opposite from expected unless I've missed something here. > > Any clarification much appreciated. > > > Thanks & Regards, > > Dean H >
