I looked at previous posts, and someone mentioned that Yahoo Finance allows you to create a "View" and puts all the fields you need in one big table. However, that is really inefficient and slows the process down to an unacceptably slow level. One horrible solution I came up with is to pull in the entire page instead of just a specific table and then run a FIND routine to figure out where the data I am looking for is located. Therefore, I tend to get the wrong table (or nothing at all) and this screws up everything. The problem is that I have it setup to pull a specific table number, but it seems that the table numbers periodically change as Yahoo changes the layout of the page. The macro then locates the specific cell within the table where the desired data is located (well, usually located) and puts it in another worksheet. My macro runs a web query on the URL in Yahoo Finance that contains the desired data (note that the data is NOT just quotes, but other stuff like EPS estimates, market caps, fiscal year ends, etc. I suspect that my approach is not the best and would appreciate any advice to the problem I have outlined below. I built a macro (with Excel 2000) to pull stock market data into my worksheet from Yahoo Finance and am having very mixed results.
0 kommentar(er)
