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.