stock/share price linked to web?

[Stan Scott]

Microsoft provides access to live stock data through a Web query. Google
"Microsoft Excel Web Query Stock" for some good sites. Microsoft has a good
article on using Web queries with Excel 2003 here:
http://msdn.microsoft.com/library/d...y/en-us/odc_xl2003_ta/html/odc_xlWebquery.asp.
They also have a pre-built stock query file (.iqy) somewhere, but I dont'
have it on this computer.

Stan Scott
New York City

 

[David]

Hi,

I have one cell on a sheet where I manually enter the share price that I
look up on Yahoo. What I'd like to do instead is to have that cell
automatically updated from the current share price, either from Yahoo or
anywhere else with the current live value.

Is this possible, and if so, how??

Thanks

David

I'm using Excel (office 2000) and have win xp home, and broadband cable
connection.

 

[Stan Scott]

Here's the text of the Excel stock query IQY:

WEB
1
http://moneycentral.msn.com/investor/external/excel/quotes.asp?SYMBOL=["QUOTE","Enter
stock, fund or other MSN

MoneyCentral Investor symbols separated by commas."]

Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False

Copy this text into a text editor and save it with an IQY extension. Then,
Open it in Excel, and it will take care of the rest.

Stan Scott
New York City