Question

Locked

Importing specific table values with a .iqy file in Excel.

By Daniel.McNulty ·
I am looking to retrieve specific values for hundreds of different stocks. For example say I would like to query the ?Beta? value from this page (http://finance.yahoo.com/q/ks?s=PG ) into Excel. Just the beta value. From there I would like to have Excel fetch the value for the next stock on my list (probably using a .dqy file from a text file?) and paste its value directly below the last query (using a macro? VBA?).

I could probably figure out the VBA I need on my own, but I?m really having trouble fetching the beta value exclusively without querying up the entire page.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums