I am trying to find a way to acquire past and present (including intra day) stock data in the form of either text or in an xls worksheet. Does anybody know by any chance how to collect these data? I would like to download several stock's data for the past 5-6 weeks, lets say, and keep it in an xls file.
posted
you can use an excel visual basic macro to go out to any site that has historical data in a table form, like yahoo finance.
Posts: 5508 | From: Southeastern PA | Registered: Jan 2006
| IP: Logged |
posted
I am not able to find historical data (not charts/graphs) for stocks. Also yahoo sometimes has no information for some stocks. google has a better database but I am not able to find the appropriate link. Actually I am not sure if I am using a good link to either database.