+ Reply to Thread
Results 1 to 2 of 2

Animated candlestick chart using VBA

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    221

    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.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by sabha; 02-23-2021 at 09:26 AM.

  2. #2
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    221

    Re: Animated candlestick chart using VBA

    Hi!
    I am awaiting some help to animate the dotted line up and down with the close and change its color and value based on current tick value.
    I haven't received any reply on this post so I have also cross-posted this on stackoverflow
    https://stackoverflow.com/questions/...hart-using-vba

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating a combo Stock-Candlestick chart & Line Chart
    By ExcelBoy90 in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 12-25-2019, 02:01 AM
  2. How to convert tick data into Candlestick chart
    By cherrychan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2018, 04:02 AM
  3. [SOLVED] Creating a candlestick chart with a horizontal line - can anyone help?
    By Elijah in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-06-2017, 08:32 AM
  4. How to add trendline to candlestick chart
    By bupthebroker in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2016, 10:12 AM
  5. Creating a Weekly Candlestick chart
    By IamNotaDoctor in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2013, 07:45 PM
  6. Replies: 0
    Last Post: 06-25-2012, 05:56 PM
  7. Excel and Candlestick Chart?
    By Mike in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-07-2006, 03:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1