What does creating a stock chart in Excel? You may need it for many reasons. For example, your trading platform doesn’t have the stock you need to analyze, or you have to do seasonality and statistical research with Excel.
In this tutorial, you will learn how to create a professional stock chart with Excel.
If you don’t know how to import data from Yahoo Finance to Excel, start with this tutorial.
For better chart visibility, we start with formatting the data that we have imported from Yahoo Finance.
Then format the cells of the columns “Open” “High” “Low” “Close” as a number and set the decimal places to “2” and click Ok.
Go to the cell A1 and press “Ctrl” + “Shift” and click “Right Arrow Key” and after “Down Arrow Key” to select all data to range from Date to Close; this is a useful shortcut for Excel.
Then in the “Insert” menù, click on Stock Chart
Select “Stock” Open – High – Low – Close
The stock chart is ready.
Dress up your Excel Stock Chart
Now we can modify it. Select and change the Chart Title, for example, in “SPY DAILY CHART”. Select Open High Low Close (Blue Arrow) and click “Canc” on your keyboard.
Click to select an Up Bars; the menu “Format Up Bars” will opens to the right. Choose a green color.
Select the Border option and choose the Black Color
Do the same with the Down Bars and color it with red and black.
Finally, modify the transparency of the Major Gridline.
That’s all. You have created a perfect stock chart like that of the best trading platforms.
Do you want to add an indicator to your stock chart? In this tutorial, you can learn how to create the Average True Range Indicator.
Do you need to import data from TradeStation to Excel? This tutorial is for you.
Download the Excel file of this tutorial from this LINK.
Editors’ Recommendations:
- SuperTrend Multi Time Frame Indicator
- How to AutoTrade Divergences
- SuperTrend for TradeStation and MultiCharts