MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Importing stock prices live to excel?

Posted by Aaron on April 27, 2001 4:35 PM

Simple question: can it be done? I just want the current stock prices of various shares to go in to cells. Ideas? programs? addons?

Posted by John on April 27, 2001 7:15 PM

Ive tried tried the same thing before with no luck

Posted by Dave Hawley on April 27, 2001 7:44 PM

Hi Aaron

Have a browse through these:


OzGrid Business Applications

Posted by Mark W. on April 28, 2001 3:40 PM

Aaron, you don't have to go beyond your desktop for
a solution...

1. Choose the Data|Get External Data|Run Web Query...
menu command

2. Choose "Multiple Stock Quotes by PC Quote, Inc.iqy"
form the Run Query list and press [ Get Data ]

3. On the "Returning External Data to Microsoft Excel"
dialog press the [ Parameters... ] button, press the
2nd radio button labelled "Use the following value:",
enter your desired stock symbols and press [ OK ].