Candlestick Charting 

Create a Candlestick Stock Chart (Open-High-Low-Close) in Excel


Produce a Candlestick Stock Graph (Open-High-Low-Close) in Excel to show thirty day of rate movements.

This video reveals you exactly how to create an internet query to immediately import stock data from Google Financing on the internet into your spread sheet.

It the shows you exactly how to develop a Candle holder graph to offer the information graphically.

Excel gives a straightforward method to create these kinds of graphes, yet there are usually a couple of format choices to be used after that.

The following Candle holder chart description comes from Wikipedia.

" A candle holder graph (additionally called Japanese candle holder chart) is a design of economic graph used to explain price movements of a protection, derivative, or money. Each "candlestick" usually shows one day; so for example a one-month graph might reveal the 20 trading days as 20 "candlesticks"".

" Candle holders are normally composed of the body (black or white), as well as an upper and also a lower darkness (wick): the location in between the open and the close is called the actual body, cost tours over and also below the actual body are called darkness. The wick illustrates the highest and also least expensive traded costs of a security while interval stood for. The body highlights the opening and also closing professions. If the security closed higher than it opened up, the body is white or unfilled, with the opening price at the bottom of the body as well as the closing price on top. If the security closed lower than it opened, the body is black, with the opening cost at the top and also the closing price at the bottom. A candle holder need not have either a body or a wick."

Find a lot more wonderful cost-free tutorials at;

Connect with us!
Google+ ►
Facebook ►
Twitter ►

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

Related posts

8 Thoughts to “Create a Candlestick Stock Chart (Open-High-Low-Close) in Excel”

  1. MisterBassBoost

    Lovely content! Keep it up!

  2. James Perry

    Very impressive. Thanks a lot for sharing.

    1. Computergaga

      Thanks James

  3. Abdullah Gülabi

    Very informative video. Thanks for sharing this.

    1. Computergaga

      Your welcome Abdullah, thanks.

  4. Kunal Sen

    many thanks for sharing. Do you know how to add a trendline (say bollinger band curve) on top of it ?

  5. Varun Thomas

    how to add volume graphs to this candlestick chart????

  6. Compscript

    No longer exists. Have to use Yahoo historical data now.

Leave a Comment