% price in x days

Hi all

If looking at DJI, in Oct 2018 we saw an ATH of 26952 followed by a 5239 pt or 19.4% drop in 84 days.

What would be the best way to write a script that could identify if and where such a % drop in price in a similar time period had occurred before in the DJI ?

Grateful for any insights.



Hi Andrew,

Use the CHANGE() function set to 84 calendar days to calculate the price change between -18% and -20% (note the change is calculated using the closing price, not the high).

V1<-18 and V1>-20

The Show Bar (set to line) will look like this:


Hey Darren, appreciate such a speedy reply. Very useful little script, thank you!!