Gold Customer
Joined: 3/8/2018 Posts: 30
|
Hello
I would like to see stocks or indexes for a perticular moveĀ
like 2% drop or 4% drop in a day.
how many times it has done this in a year or in years.
Thanks
Dipan
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
COUNTTRUE(C/C1 <= .98,497) will return the number of times the stock closed down 2% or more in the last 497 days which is approximately 2 year.
The chart loads 500 bars so you have to leave a few bars for the initial calculation.
|