I'm looking for a website that makes it easy to download the OHLC values for pennies, if not all stocks, to excel. I also require that historical data can be downloaded of at least 3 months. Does anyone have any suggestions to make this process easy? Matt
Posts: 1504 | Registered: Sep 2004
| IP: Logged |
After you enter the symbol and click get quote then on the left hand side click on interactive charting. Put in your time frame for the chart then go to bottom of page and there is a export to spreadsheet link.
Now its been awhile but I think up to a year it does daily numbers. 5years charts are given in weekly.
For stocks greater then 2 decimal places you will need to reformat excel for those places by changing it to "number 4 places after the decimal" and change volume colume to "number 0 places after the decimal then your excel page will show the exact prices for sub-pennies. It provides OHLC and volume.
I would save as excel workbook to because it downloads as a cvl file?. Save to text then you can post to board.