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)


Excel 2016 - Stock Quotes

Linked Data Types - Stock


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
link - 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
link - 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
link - 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"


finance.yahoo.com/quote/USDCAD=X?ltr=1


.iqy Files


Latest Exchange Rates
floatrates.com/daily/usd.xml
Data > Get External Data > From Other Sources > From XML Data Import


add filename (SS) http://
Excel will tell you there is no XML Schema.
Press OK to let Excel create one for you
Browse to the top left cell
Before pressing OK, press Properties and change the Name (SS)


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext