Show Date Column when condition was true Dynamic Watchlist

Show Date Column when condition was true Dynamic Watchlist

Hmt Ptl
2016-10-09 02:45:57

Hello,
I want to know the dates in Dynamic Watchlist when the given condition was true!
e.g. When I filter for RSI < 30, I want to know at what date the condition was true.

currently i am doing the following but it is not working:

filter = RSI(14) < 30;
addcolumn("Date", date());

But all I get is the "current" date and not the date at which the condition was true!

Kindly let me know how to do that.

Thanks!

QuantShare
2016-10-10 04:05:45

The dynamic watchlist, by default, uses the last bar date. So if you see a stock after adding "filter = rsi(14) < 30;" then this means that last RSI of that stock is below 30.

Hmt Ptl
2016-10-11 14:19:50

I know that, but what if I select "Condition True for 'atleast' once in past 100 bars"? Then, I'll need to know that which dated bar has condition met successfully!

Let me know.

Thanks.

QuantShare
2016-10-12 07:34:12

Here is what you should type in this case:

filter = RSI(14) < 30;
d = RefString(date(), barssince(filter));
addcolumn("Date", d);

Get more messages

No more messages

Back


Trading Items Number of Consecutive Trading Bars Condition was True Dynamic Momentum Index Traders Dynamic Index - TDI Indicator VIDYA - Variable Index Dynamic Average ATR - Average True Range Drawing Tool	How-to Lessons How to create a volatility-based Stop - Dynamic stop based on the... How to create a watchlist How to speed up watchlist and screener plug-ins when working with... How to create a real-time watchlist How to drag & drop a stock to a static watchlist
Related Forum Threads Dynamic Watchlist update for each time step during a simulation? Dynamic Watchlist Help Composite with dynamic watchlist symbols How do you sort simulations by the date that the simulation was r... condition being true in the last X days	Blog Posts True portfolio simulation applied to trading systems Create Realtime Quote Sheets with the Watchlist Tool Download quotes, news, sentiment, fundamental... data using Quant... 9 mistakes you should avoid when backtesting an end-of-day stock ... Using Average True Range to Measure Intraday Volatility