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