|Home > Forum Home > Charting and Performing Technical Analysis > How to plot a High and Low chart||Share|
|Forum Topic||Post Reply Login|
How To Plot A High And Low Chart
Rate this:(3/5 from 2 votes)
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
|Posted by satimis on|
|Replies - Displaying 1 to 1 of 1||Order Replies By: Most Recent | Chronological | Highest Rated|
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.
Rate this:(3.5/5 from 2 votes)
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 Excel Helper on|
|Displaying page 1 of 1|
|Find relevant Excel templates and add-ins for How to plot a High and Low chart in the Excel Business Solutions Directory|