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.

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.

"stock_me" wrote:

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.