Create a Candlestick Stock Chart (Open-High-Low-Close) in Excel to show 30 days of price movements.
This video shows you how to create a web query to automatically import stock data from Google Finance on the Web into your spreadsheet.
It the shows you how to create a Candlestick chart to present the data graphically.
Excel provides a simple way to create these types of charts, but there are typically a few formatting options to be applied afterwards.
The following Candlestick chart description comes from Wikipedia.
"A candlestick chart (also called Japanese candlestick chart) is a style of financial chart used to describe price movements of a security, derivative, or currency. Each "candlestick" typically shows one day; so for example a one-month chart may show the 20 trading days as 20 "candlesticks"".
"Candlesticks are usually composed of the body (black or white), and an upper and a lower shadow (wick): the area between the open and the close is called the real body, price excursions above and below the real body are called shadows. The wick illustrates the highest and lowest traded prices of a security during the time interval represented. The body illustrates the opening and closing trades. If the security closed higher than it opened, the body is white or unfilled, with the opening price at the bottom of the body and the closing price at the top. If the security closed lower than it opened, the body is black, with the opening price at the top and the closing price at the bottom. A candlestick need not have either a body or a wick."
Find more great free tutorials at;
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ►
Excel VBA for Beginners ►
Advanced Excel Tricks ►
Excel Formulas Made Easy ►
Creating Sports League Tables and Tournaments in Excel ►
The Ultimate Excel Course & Advanced Excel Tricks Bundle ►
Connect with us!
LinkedIn ►
Facebook ►
Twitter ►
Lovely content! Keep it up!
Very impressive. Thanks a lot for sharing.
Thanks James
many thanks for sharing. Do you know how to add a trendline (say bollinger band curve) on top of it ?
i can’t see copy link please
Great video, very useful and informative. Thank you.
Thank you very much 👍
Sir please make a video on how to create a renko chart in excel. I tried a lot but could not figure out😒
does it work on window 7 excel? i found out that the datas go horizontal instead of vertical
You probably want to switch your data to vertical first. And yes, I believe it should work still. In the video I think I am demonstrating in Excel 2016.
Can we insert Moving Average indicator as well?
Hi. Do you know how to add horizontal lines with specific values on the Stock Chart? For example, a “target” or the “buy price” to be displayed in the graph…
how can i contact u?