Animated candlestick chart using VBA

Hello friends,

I took up a challenging work of animating a 5 minute candlestick chart from open high low close data. All the basic work of animation using vba is done. The animation works well for every tick of 1 minute using a wait interval of 1 second for every 1 minute tick but I am stuck.

Can someone help me on how can I animate the dotted line up and down on every tick with its close price? The condition is, if the close is less than open for that particular tick, then the line and text color should change to red and the value also should be changed. Similarly, if the close is greater than open for that tick then the color should be green and if open and close both are same then color should be black.

I also need some help in how to plot a volume bar chart in the same candlestick chart on a secondary axis and animate the volume bar charg along with the candlesick animation. I could not find a way to do that.

I request you guys to assist me on the same.

PS: My code may not be super efficient as I am not a pro, you can change it to increase its efficiency.

Please Login or Register  to view this content.

Thank you.