Option Pricing in Excel

View option quote updates in Excel and compare bid and ask prices alongside your own analysis. Data availability and update frequency depend on your subscription and exchange entitlements.

MarketXLS offers an Excel-based Option Scanner that allows you to choose up to 40 stock tickers, get all the option contacts for those stocks, and filter for the best options to trade. Compare different Options values, greeks, volumes, open interests, and more by using our Option Chain functions. Utilize our Options Symbol function to get an option symbol of a specific stock, at a specific date and a specific strike price.

Utilize our real-time options profit calculator to build and analyze numerous options strategies. Get the Ranks of the filtered option contracts by your criteria and ranking weights like Low Premium, High Volume, Low Spreads, and more.

Black Scholes Option Model

Use our innovative easy to use functions to filter option contracts as per your own criteria. For example, find all options for TSLA that expire between x date and y date and those that have strike price between x and y

Interested in Straddles, Strangles, Calls, Spreads, and many other options strategies? You are at the right place! MarketXLS offers numerous pre-built Options Templates in your Excel. All templates are open code, reusable, and can be adjusted quickly for your own requirements. Accompanying these templates, we have a library of videos walking you through the strategies.

See how your options prices changed over time in History. Get End of the day or Intra-day (minute by minute) history of all recently expired and active contracts.