Logging live data and candlestick charting

Hi to all

I am a newbie at VBA and macros. I want to get BTC price and charting 1 min candlestick chart.
Getting BTC Price with RTD at DATA sheet A1 Cell and Time A2 cell
Logging price every second for every minute at LOG sheet
at CANDLE sheet getting time, open, high, low and close price from LOG sheet for charting.
Below is my Code and attached Excel file and Screenshots.

My problem is, this is not accurate, it is delaying 30 secs, every 10-15 mins. And code is very bulky so many data storing for charting.
Is there a proper way to store in a table Open, High, Low and Close Price for every minute?

Please Login or Register  to view this content.