I want to use last Wednesday’s High and Low of Nifty in the condition of a scanner. Is there a way to get OHLC of a Specific Day’s candle?
You can not mark the OHLC of a specific previous candle (Wednesday daily candle for example)
However, you can use the Prev N function to select the OHLC of the previous day with respect to the present/current day.
For example "Prev N(Close,-1, day) " is the previous day’s close, similarly “Prev N(Close,-2, day)” is previous to the previous day’s (-2) day close.
Now you can pair it with the Candle time function to check the conditions on Wednesday accordingly. ‘Candle time day of week equal to 1’ will mean Monday, similarly ‘Candle time day of week equal to 2’ will mean Tuesday. Now you can change the offset in the previous N as per your requirement.
For example, if you want to check that the Wednesday close was higher than the Open, you can refer to the below screenshot for the conditions to check the conditions on Wednesday for the specific day of the week-
You can use a similar Logic for your requirement. Hope this clarifies.
1 Like
