My objective is to get 15 minutes Candle data for a symbol from the time the market opens. i.e. 9.15 -9.30 , 9.30-9.45 and on....from the live quotes received
I can capture the opening price and Closing price using MS Scripting and using Dict...however just puzzled how to capture the High and Low values within a particular time frame? though i have a High & Low data fields but its day High/Low not that particular time frame High/Low.
Appreciate if i get a effective suggestion from Excel experts of this forum.
Regards Venkatesh
Note: Though i could get this form Kite Historical data and since my purpose is limited to intraday only and to check certain candle formations, i don't want to go for Kite Historical data subscription.