Candlestick Charting 

Candlestick Chart in Excel


Download the spread sheet at

The spread sheet downloads historic stock prices from Yahoo Financing as well as immediately generates a candle holder story. This is automated with VBA.

The VBA can be checked out and also modified – you can find out a whole lot just by searching the code and exploring (that's just how I found out VBA).

I show You how I made $1,006 from $100, then $257,000 from $1,006 with Bitcoin and cryptocurrencies!

Related posts

2 Thoughts to “Candlestick Chart in Excel”


    sir I want to make a volume chart on excel which means after 1000 volume a candle stick is formed .. how can I do that ? can you pls help me sir

  2. Simon Hunt

    Great stuff! This works brilliantly for stocks and also indices such as “^ftse”. Can it be made to work also for futures (indices, commodities, metals etc) and forex? If so how?

Leave a Comment