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 ( ) 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.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums