Home > Forum Home > Charting and Performing Technical Analysis > How to plot a High and Low chart Share

How to plot a High and Low chart

Excel Help for How To Plot A High And Low Chart in Charting and Performing Technical Analysis


Forum TopicPost Reply Login

How To Plot A High And Low Chart

Rate this:
(3/5 from 2 votes)
ConfusedHi folks,

Excel 2007/2010

How to download the high and low stock price of a company, say IBM, in a fixed period on Yahoo finance/Google finance and to create a high and low chart?  TIA

B.R.
satimis
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Happy
Rate this:
(3.5/5 from 2 votes)
To download stock price data into Excel, you can use our free solution which you can download from this post. This downloads the chosen variable (Open, Close, etc) for multiple ticker symbols; however the 'Query' sheet can be used to get all information for one stock only.

To create a High and Low chart from the downloaded stock price data in Excel 2007 or higher, you choose Insert tab > Other Charts (under Charting) > Stock > High-Low-Close.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for How to plot a High and Low chart in the