Comments:
If you want delayed prices Microsoft offers a free Excel Add-in which is very similar to the list tool offered by the Reuters, Bloomberg and Bridge.
It fills a table of instrument codes and fields with snap data. It allows cell referencing. It is quite robust. I have used it to retrieve quotes on over 180 instruments with 10 fields. It lets you update the quotes on demand.
The fields are only for equity instruments.
The source of the data is S&P Comstock and Media General.
You can dowload the xla from:
http://office.microsoft.com/downloads/2002/Msnsq.aspx
You can get global historical data on equities from Yahoo through a Web query. In our Willow Tips section (tip 2002-8)we have a free mini app which retrieves historical prices into Excel.
|
