Posted to microsoft.public.excel.programming

penguin13

external usenet poster

Posts: 2

Get Stock Quotes Via Cell Look Up

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Stock Quotes	mman493	Excel Worksheet Functions	0	May 2nd 07 07:30 PM
Stock Quotes	N&O H.	Excel Worksheet Functions	2	March 18th 07 06:35 PM
How do i get historical stock quotes using MSN Money Stock Quotes	Ash	Excel Discussion (Misc queries)	0	May 11th 06 03:26 AM
getting stock quotes	m_man	Excel Discussion (Misc queries)	1	June 22nd 05 08:35 AM
Stock quotes	Craig	Excel Discussion (Misc queries)	3	April 30th 05 11:11 PM

All times are GMT +1. The time now is 05:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us