Reply To: Twitter Charts 2

[Darren]

To calculate how long ago the close was at the latest low (or high) – and the dates they occured: https://twitter.com/Optuma/status/1537704403205079040

Worst Change Since:

//Display as Date in Watchlist; //Get the last 1D ROC change %; D1=LAST(ROC(BARS=1)); //Get the BarDate when the 1D ROC was less than D1; BARDATE(ROC(BARS=1)<D1, UNIT=Days)

1 2 3 4 5 6 7

//Display as Date in Watchlist; //Get the last 1D ROC change %; D1=LAST(ROC(BARS=1)); //Get the BarDate when the 1D ROC was less than D1; BARDATE(ROC(BARS=1)<D1, UNIT=Days)

Lowest Close Since:

//Display as Date in Watchlist; //Get the last close price; D1=LAST(CLOSE()); //Get the BarDate when the Close was less than D1; BARDATE(CLOSE()<D1)

1 2 3 4 5 6 7

//Display as Date in Watchlist; //Get the last close price; D1=LAST(CLOSE()); //Get the BarDate when the Close was less than D1; BARDATE(CLOSE()<D1)

Weeks Since Low

//Get the last close price; D1=LAST(CLOSE()); //Get the time since the Close was less than D1; TIMESINCESIGNAL(CLOSE()<D1, Unit=Weeks)

1 2 3 4 5 6

//Get the last close price; D1=LAST(CLOSE()); //Get the time since the Close was less than D1; TIMESINCESIGNAL(CLOSE()<D1, Unit=Weeks)

To find the high dates instead, change the < to >. Sample weekly watchlist attached that can be saved as a layout and applied to any other lists.

2 users thanked author for this post.

Louis Spector, Thomas