@botany02 and @GasTurbGuy
Sir thank you very much for answering my query. sir i used the below VBA code and i am getting open , high , low values , still testing the accuracy but i am getting the values sir.
Private Sub Worksheet_Calculate()
If…
@botany02
SIR i want only present forming candle say 9:15 to 10:15 OHL, close is not important.
at 10:15, again i want OHL of 10:15 to 11:15 candle, and so on.
i dont want previous completed candles . i want only present running candle OHL sir
@BOTANY02
yew sir exactly
because i am not getting 1 hour OHLC data from historic data live while the 1 hour candle is forming. So i am trying to get the hourly OHLC values myself.