Knowledge Base | How to Load Option Chains from MSN Money to Excel

Contents

Overview

MSN Money publishes US stock option chains at their website and has no download links.

However, MSN Money has an undocumented web service that returns option chains in JSON using URLs like this:

http://www.msn.com/en-us/finance/stocks/optionsajax/MSFT/?date=1/19/2018

Our product, Market.rtd, loads option data using these URLs and allows consuming data in Microsoft Excel using RTD formulas.

Loading Option Chains from MSN Money into Microsoft Excel using Market.rtd

You may load option data using simple formulas like

=RTD("market.rtd",,"MsnMoneyOptions","AAPL180119C00100000","Ask")
=RTD("market.rtd",,"MsnMoneyOptions","AAPL180119C00100000","OpenInterest")
Options in Microsoft Excel from MSN Money by option contract names

Also, you may load option data using contract parts:

=RTD("market.rtd",,"MsnMoneyOptions","AAPL","180119","C",100,"Ask")
=RTD("market.rtd",,"MsnMoneyOptions","AAPL","180119","C",100,"OpenInterest")
Options in Microsoft Excel from MSN Money by contracts

Moreover, you may get last underlying stock prices, find ATM strikes, and the next ITM or OTM strikes one by one.

So, you may easily build complex refreshable models.

Options in Microsoft Excel from MSN Money

You may find this example in the Examples folder of the downloaded package.

Also, you may use Formula Builder to get all available formulas for any data provider.

Market.rtd Formula Builder - Providers

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

Downloads

Products for Option Traders
MARKET.RTD
The app loads data from Yahoo Finance, Google Finance, and MSN Money into Microsoft Excel
Version: 5.8 | 12/15/2017 | 4.3MB | Home | What's New | Edition Comparison
Download

Disclaimer

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