User-Defined Functions

Excel VBA
Excel Formulas
User-defined Functions
Excel Links
Access VBA
Access SQL
Alan’s Excel FAQ
Excel Home
Alan’s Home

Stock Quote

Are you running Office 2003 and have you downloaded the free add-in “MSNStockQuote.” Finally a better way to update your investments list in Excel.
Motorola	MOT	17.160			
Microsoft	MSFT	28.080			
Nextel	       NXTL	26.090			
OSI Systems	OSIS	18.120			
=MSNStockQuote(B30,"Company Name","US")	OZRK	32.380			
RAE Sys	RAE	=MSNStockQuote(B31,"Last Price","US")			


Once a day, I bring up the list. Go to the Stock Quotes toolbar and click "Update Quotes."

© 2004-2008

Updated:  04/02/2008 19:33
This page added:  02 November 2004