How to Load Option Chains from MSN Money to Excel
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:
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 can load option data using simple formulas like
Also, you can load option data using contract parts:
Moreover, you can get last underlying stock prices, find ATM strikes, and the next ITM or OTM strikes one by one.
So, you can easily build complex refreshable models.
You can find this example in the Examples folder of the downloaded package.
Also, you can use Formula Builder to get all available formulas for any data provider.
You can select how to organize formulas, by rows or by columns, and paste them into Microsoft Excel spreadsheets.
|Products for Option Traders|
The app loads data from Yahoo Finance and MSN Money into Microsoft Excel
Version: 5.27 | 05/29/2023 | 4.6MB | Getting Started | What's New | Edition Comparison
MSN and Microsoft Excel are logos and registered trademarks of Microsoft Corporation.