Get Stock Quotes Via Cell Look Up

[Guest]

1) Is there any way I can use the data from a cell - say B2, which contains a
stock symbol - to look up the current price for that stock symbol and insert
only the price in cell J2?

2) If 1 is possible, can I refine it such that it will only perform the look
up if cell G2='Y'?

3) Can this then be applied to every row of the worksheet?

 

[Tom Ogilvy]

Lookup where?

 

[Guest]

microsoft web site
search "excel stock query"
Learn the basics of Web queries
A great way to learn the basics of Web queries is to look at one of the
sample queries included with Excel.

Using a sample Web query
The MSN® Money Central™ Investor Stock Quotes Web query included with Excel
lets you insert the latest stock quotes into your spreadsheets. Just use the
Import Data command (Data menu, Import External Data) and select MSN
MoneyCentral Stock Quotes as your data source. For the parameter value, use
the symbol of any stock you're interested in. (For example, to get Microsoft
stock quotes, you would type MSFT.) After you create the query, you can
refresh its value at any time to get a new quote.

Do you want the rest in formula or vba code?

 

[Guest]

Yes, I want to get stock quotes from the internet. I haven't used web queries
before, but it looks like now might be the time to try them out.

I'll have to use formula since I've never used vba before.

Thanks!