Knowledge Base | How to Load Historical Stock Prices from MSN Money to Excel

How to Load Historical Stock Prices from MSN Money to Excel

Updated: August 30, 2019

Contents

Overview

MSN Money publishes historical and intraday prices from a lot of exchanges.

You can download data using undocumented URLs of its web service that returns historical and intraday prices in JSON.

URLs for daily, weekly, and monthly historical prices:

http://finance-services.msn.com/Market.svc/ChartAndQuotes?symbols=MSFT&chartType=1y&isEOD=True&isCS=true&isVol=true

http://finance-services.msn.com/Market.svc/ChartAndQuotes?symbols=MSFT&chartType=5y&isEOD=False&isCS=true&isVol=true

http://finance-services.msn.com/Market.svc/ChartAndQuotes?symbols=MSFT&chartType=max&isEOD=True&isCS=true&isVol=true

URLs for 1, 5, and 15-minute intraday prices:

http://finance-services.msn.com/Market.svc/ChartAndQuotes?symbols=MSFT&chartType=1d&isEOD=False&isCS=true&isVol=true

http://finance-services.msn.com/Market.svc/ChartAndQuotes?symbols=MSFT&chartType=1D_5M&isEOD=False&isCS=true&isVol=true

http://finance-services.msn.com/Market.svc/ChartAndQuotes?symbols=MSFT&chartType=5d&isEOD=False&isCS=true&isVol=true

You can use tickers like 126.1.MSFT.NAS for stocks and 245.20.GBPUSDLITE for currencies.

You can use our several products to load these data into Microsoft Excel in several ways.

Loading Historical Prices from MSN Money into Microsoft Excel using SaveToDB Add-In

The SaveToDB add-in allows opening XML, JSON, HTML, and CSV from the web and converting data to refreshable Excel tables.

Moreover, you can customize URLs to change symbols using the ribbon:

Load Data from Web

Also, you can create and apply table views to filter data using various conditions directly in Excel:

Create Different Table Views

To load historical prices, click Wizards, Data Connection Wizard, select Web Data Provider and select an URL to connect.

URLs of historical prices from MSN Money look this:

http://finance-services.msn.com/Market.svc/ChartAndQuotes?symbols={Symbol=MSFT}&chartType=1y&isEOD=True&isCS=true&isVol=true;rootpath=Chart.Series

{Symbol=MSFT} is a defined ribbon parameter with the default value. rootpath is a parser parameter.

The SaveToDB add-in is a cool tool to load data from the web. It's available in a free version. Try it.

Loading Historical Prices from MSN Money into Microsoft Excel using MARKET.RTD

MARKET.RTD is a specialized RTD server for loading data from Yahoo Finance and MSN Money.

You can create and copy formulas using Formula Builder that contains predefined data providers:

MARKET.RTD Formula Builder - Providers

You can select how to organize formulas, by rows or by columns, and paste them into Microsoft Excel spreadsheets.

Then you can format your model and get refreshable results like this:

Example of MSN Money Quotes

You can get a lot of data using MARKET.RTD with the regular Microsoft Excel RTD formulas like these:

=RTD("market.rtd",,"MsnMoneyHistoricalPrices","MSFT","2016-12-30","Open")
=RTD("market.rtd",,"MsnMoneyHistoricalPrices","MSFT","2016-12-30","Close")
=RTD("market.rtd",,"MsnMoneyHistoricalPrices","MSFT","2016-12-30","PrevClose")

You can customize the refresh interval using the formula like:

=RTD("market.rtd",,"MsnMoneyHistoricalPrices","RTD_REFRESHINTERVAL",24*60*60)

Moreover, MARKET.RTD includes a lot of examples for available providers. So, you can adapt them to your needs easily.

Additional Notes

As described above, you can load historical prices into Microsoft Excel directly.

However, MSN Money publishes intraday prices for the last trading days only.

If you need an intraday history for a larger period, you can download data daily and create the history yourself.

See KB: How to Load Historical Stock Prices from MSN Money to CSV or
KB: How to Load Historical Stock Prices from MSN Money to Databases

Downloads

Download SaveToDB Download MARKET.RTD

Disclaimer

MSN and Microsoft Excel are logos and registered trademarks of Microsoft Corporation.