How to Download Options Prices in Excel

We have earlier discussed about downloading stock quotes in excel. You can do this in many ways such as from yahoo finance, or using the MarketXLS add-in that helps you seamlessly integrate live stock quotes in your excel workbook.

In this post, I’ll describe how the MarketXLS Stock Quotes in Excel add-in can also be used for downloading options related information in excel.

You can use MarketXLS to stream real time or delayed live Pricing (Last, Bid, Ask and so on) for getting Stock Option Pricing in Excel. You will need any version of plan of MarketXLS along with a data subscription for Options Pricing. 

The functions implemented work as normal excel functions and the software has built in intelligence to recognize special information. For example, you can use the following function to get all option chains of a stock symbol.

1=QM_List("getOptionChain","Symbol"