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:
http://www.google.com/search?sourceid=navclient&q=Excel+import+stock+prices
Dave
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 ].
