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
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.
