Thread: Web Queries and pulling data from one cell

Newby here. I'm tracking stocks from finance.yahoo.com, and I need to get the adjusted closing price for yesterday. I can do this by using a web query, pasting the results into a separate worksheet, and then linking the desired cell into another worksheet. The problem is that I want to track a large number of stocks, and I really don't want to have 100 worksheets. Is there a way to do a web query for a specific item in a table?

Thanks in advance for any ideas.......

you need not have 100 sheets or workbooks. have one sheet with 100 row and number of columns


suggest something like this

your sheet1 wil be like this
stock open high low close
a 1 2 0.9 1.2
s 2 3 1.9 2.2
d 3 4 2.9 3.2
f 4 5 3.9 4.2

sheet 2 will be something like this

close prices of stocks
stock 20-Oct-11 21-Oct-11 22-Oct-11 23-Oct-11
a
s
d
f


At the end of the day you download data in sheet for that day
copy "closing" data in sheet on the corresponding date
delete sheet1 data onlly keep the stock names and column headings.
repat next day etc

you can write a macro for this. You can use Randy"s addin

http://finance.groups.yahoo.com/group/smf_addin/