I know this isn't a new question. But I can't find the answer anywhere online.
I have a spread sheet of 1500+ companies. (I can email you the .xls file if it would help.)
I want to import specific information from Yahoo Finance, for example the first company on the list is AAIR, AAIR Key Statistics | AVANTAIR INC Stock - Yahoo! Finance
When I use Web Query I can pull a table of information. Which is a great start. But I don't need every line of information I only want specific Columns of information. Like the information listed under "Price / Book". Is it possible to pull invidual cells of information rather than the whole table?
Additionally I would like to make the table dynamic. So I can scale it to a large table of companies rather than once company at a time.
Is it also possible with Yahoo Finance information?
I have a spread sheet of 1500+ companies. (I can email you the .xls file if it would help.)
I want to import specific information from Yahoo Finance, for example the first company on the list is AAIR, AAIR Key Statistics | AVANTAIR INC Stock - Yahoo! Finance
When I use Web Query I can pull a table of information. Which is a great start. But I don't need every line of information I only want specific Columns of information. Like the information listed under "Price / Book". Is it possible to pull invidual cells of information rather than the whole table?
Additionally I would like to make the table dynamic. So I can scale it to a large table of companies rather than once company at a time.
Is it also possible with Yahoo Finance information?
