fbpx
Search
Close this search box.

Intraday Candlestick Charting [Stock Charts]

Share

Facebook
Twitter
LinkedIn

After reading the Japanese Candlestick Charts in Excel post, Gene asks me in an email,

I’m trying to graph candlestick charts in Excel for 10 minute candles. Excel seems to allow daily only with its stock templates. Can you point me to any resources for creating intraday candle charts?

Of course, being the smart person Gene is, he figured out that even before I could send an email back (he used box plots to mimic 10 minute candles)

But there should be a way to make intraday candlestick charts using the regular stock chart in excel. Isn’t it?

Well, there is a way.

As an aside, you might wonder what an intraday candlestick is?

Well, I am no day trading expert nor a technical analyst of stock markets, but statistically speaking, there can be high, low, open and close values for any given interval. Although, on a busy day, you might find that close of a 10 minute interval is equal to open of the next 10 minute interval. But, these days, the stock markets are seldom busy (unless you are busy selling 😉 ). Again, I digress. So going back to the intraday candlestick charts,

1. First get the intraday stock price movement data

2. Now, Create a regular candlestick stock chart

When you are done, the chart should look something like this:
Intraday Candlestick Charts - Wrongly formatted axis - Excel
3. Select date axis (horizontal axis) and press ctrl+1 (or right click and go to format axis)

And change the axis type from “date” to “text”

Also, set the interval between labels to 3 or something like that. This will reduce the label clutter.
Axis Options - Excel Stock Charts - Candlestick Charts

That is all. You will now have an intraday candlestick chart that looks like this:
Intraday Candlestick Chart - Microsoft Excel

Download the intraday candlestick chart template and play with it.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

4 Responses to “Intraday Candlestick Charting [Stock Charts]”

  1. Ankit says:

    I have searched in google. But I am not able to find the the data where time is coming. In your template you have used your hand written data or taken from the site ?
    If taken from the site then can you please give me the link so that I can also test the same.
    Thank YOu

  2. Mike says:

    I download data from the S&P 500 at the end of the day. I need a simple "daily template" to display these values > Date-Open-High-Low-Close. Preferably a 1 to 6 month chart.
    1) I need a common daily Candlestick Chart listing the day and prices as axis X and Y.
    2) I need three (Exponential Moving Average Lines) > EMA 13 - EMA 21 -EMA 34 on the chart.
    3) I need to be able to (manually) change the daily candlestick colors to Red or Green. The unchanged colors can remain Black.
    4) I need to add text to the chart.
    Can someone create a chart like this for me? And how much would it cost? I don't have time to learn how to do it.
    Please respond by email.
    Thank You,
    Mike

  3. CHARLIE says:

    I AM TRYING TO PUT MOVING AVERAGES ON A CANDLESTICK CHART
    USING EXCEL. I AM HAVING PROBLEMS DOING THIS. CAN YOU HELP?

  4. Herb says:

    I am trying to insert stock quotes into an Excel spreadsheet. I want the formula to get the quote for the individual stock or mutual fund. I have been using the following; =MSNstockquote($R8) where R8 contains the stock ticker symbol. This has been working for a long time and suddenly it keeps indicating #Value in the quote cel/

Leave a Reply