Web Query (Table Cell Isolation)

Good afternoon all,

I don’t know if this is possible, but I am trying to write a web query that will isolate a singe cell within a web table. Let’s take for example your standard stock summary table for Microsoft from Yahoo Finance. I have an .iqy file that states the following:

WEB
1
http://finance.yahoo.com/q?s=msft

Selection=table1
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

This will populate the following in excel:

Column-A Column-B
1 Last Trade: 20.13
2 Trade Time: 3:55PM ET
3 Change: Down 0.56 (2.71%)
4 Prev Close: 20.69
5 Open: 20.85
6 Bid: 20.10 x 21700
7 Ask: 20.11 x 13800
8 1y Target Est:28.45

Now let’s say for example I only want my query to pull what is in cell B1 “$20.13” and not all the other information. Is this a possibility?

Thank you
Thomas

I don't know how helpful this will be, but have you tried the Stock Market Functions add-in?

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

--JP

Thanks for the feed back guys.

I will give your suggestions a try. I wanted to see if it was possible first before trying alternate methods.

Thanks again.

T