web data

[richardb1231]

Hi there,

im trying to set up a spreadsheet that accesses a website like yahoo finance to retrieve data.

I can get excel to pull data...DATA>IMPORT EXTERNAL DATA>NEW WEB QUERY...and then i choose the table i want imported. However, what I cant do is get another cell in the spreadsheet that i can enter a different stock name which then changes the table.

So what im aiming to do is have one cell that has a stock name in it (which i can change to what i want) and when i change it i want a table (the stocks balance sheet) to change to the new stocks information accordingly.

Any help would be really appreciated and i hope that some of what i have written is clear?!

Thanks

 

[John_w]

It sounds like you need a dynamic web query. See http://www.jkp-ads.com/Articles/WebQuery.asp and http://www.vertex42.com/News/excel-web-query.html