HELP: refer to the date of highest value

[fishmarket]

please see the specific example per attached graph. Million thanks.

 

[fishmarket]

Plz help thx

 

[sudris]

you may try
ValueWhen(condition,Datetime())

or use datenum() if that helps rather than Datetime().

 

[fishmarket]

it seems work. but it returns a big number.. how do I convert to the normal date format that I can see, i.e. 17/2/2013. Thanks

 

[fishmarket]

thx. solved!

 

[fishmarket]

I used the above code : ValueWhen(condition,Datetime()), then I can get the exact day, when say X == 0, but what if I want to show 1 day before X == 0?

can I use " DateTime() - 1"?

AddColumn( ValueWhen( X == 0, DateTime() - 1), "Date", formatDateTime );
AddColumn( ValueWhen( X == 0, Ref( C, -1 ) ), "Price of Date" );

thanks.

 

[amanfree]

Hi fish,

why u opened separate thread for date part?

 

[amanfree]

i think the orignal thread is here: http://www.traderji.com/amibroker/80606-help-consecutive-days-over-moving-average.html

 

[sudris]

I used the above code : ValueWhen(condition,Datetime()), then I can get the exact day, when say X == 0, but what if I want to show 1 day before X == 0?

can I use " DateTime() - 1"?

AddColumn( ValueWhen( X == 0, DateTime() - 1), "Date", formatDateTime );
AddColumn( ValueWhen( X == 0, Ref( C, -1 ) ), "Price of Date" );

thanks.

better get the barindex() first. in this way : ValueWhen(condition,BarIndex());

mybar=ValueWhen(X == 0, BarIndex());
mybar--; // decrement by 1.

// if you want more then
// mybar = mybar - 2;  // for second previous bar. -3 for third previous...and so on provided the array element doesn't fall out of array size.

AddColumn( ValueWhen( mybar == BarIndex(), DateTime()), "Date", formatDateTime );

 

[fishmarket]

Hi fish,

why u opened separate thread for date part?

As I thought the main function is different and so do the heading.