stock quotes in excel

S

stock_me

Does anyone know of a way of importing the closing day prices over the last
year for multiple stocks. Most of what I'm seeing here and elsewhere only
deals with using a smart tag to bring in the very latest data on any given
stock. MSN Money of course allows users to export a years worth of
historical data on any given stock to an Excel spreadsheet but I can't seem
to find any kind of contact info for either MSN Money or else where that
would give me a provider for accomplishing such a task.
 
R

RogueIT

somewhere in program files/office is a iqy file
open excel and click data -> import external data -> import data
browse to program files/office11 /queries and chose the MSN money stock
quote IQY.
Click parameters and chose use the following value. separate your symbols
with comma's and then you can specify up to...I think 160 stocks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top