MSN Money Stock Quotes

Removed in 2002 and is no longer available for download.
This was always an additional add-in that could be downloaded and installed and was never made available by default.
The download was removed in 2010 and replaced with the Bing Finance App.
This add-in could be used to import stock quotes from MSN Money and Yahoo Finance.
This add-in uses web services to download free stock quotes
It is extremely simple to setup because Excel comes with a ready made query that you can access by going to (Data > Import External Data > Import Data)


Installing the Add-in


Once the add-in is installed an additional submenu will appear on the Data menu. (Data > Stock Quotes from MSN Money)


Functions - "MSNStockQuote("MSFT","Last")
Office Onlibe - HP010216958


There is also a "Stock Quote Addin for Excel" available on code project


Currency Rates
WEB
1
http://moneycentral.msn.com/investor/external/excel/rates.asp


Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False


MSN MoneyCentral Investor Currency Rates

Added in 2007 but removed in 2010
C:\Program Files\Microsoft Office\Office 12\Queries\msn money central investor currency rates.iqy


MSN MoneyCentral Investor Major Indices

Added in 2007 but removed in 2010
C:\Program Files\Microsoft Office\Office 12\Queries\msn money central investor major indices.iqy


MSN MoneyCentral Investor Stock Quotes

Added in 2007 but removed in 2010
C:\Program Files\Microsoft Office\Office 12\Queries\msn money central investor stock quotes.iqy



alternative - www.qmatrix.com


Major Indices
WEB
1
http://moneycentral.msn.com/investor/external/excel/quotes.asp?symbol=$INDU,$COMP,$TRAN,$UTIL,$DAX,$FTSE,$HSI,$IIX.X,$COMPX,$NI225,$CAC,$SOX.X,$IUX,$OEX,$INX,$STI,$AOI,$CA:OSPTX


Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False



Quotes
WEB
1
http://moneycentral.msn.com/investor/external/excel/quotes.asp?SYMBOL=["QUOTE","Enter stock, fund or other MSN MoneyCentral Investor symbols separated by commas."]


Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False



2003 - Stock Actions Task Pane

In 2003 there was an additional plugin that you can download which would add an extra item to the Research task pane.
This allowed you to insert stock quote information using the task pane.
In the Research task pane select "MSN Money Stock Quotes"



© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext