Click here to Login





                                                   Show Date Column when condition was true Dynamic Watchlist

  0

0
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

  0

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

  0

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

  0

Here is what you should type in this case:

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



No more messages
0




Reply:

No html code. URLs turn into links automatically.

Type in the trading objects you want to include: - Add Objects
To add a trading object in your message, type in the object name, select it and then click on "Add Objects"










QuantShare

Trading Items
Number of Consecutive Trading Bars Condition was True
Traders Dynamic Index - TDI Indicator
Dynamic Momentum Index
ATR - Average True Range Drawing Tool
VIDYA - Variable Index Dynamic Average

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









QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright © 2024 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.