Option Pricing in Excel

Never lose track of your trades with our real-time streaming prices in Excel. The numbers that you see on your Excel will change by themselves and will match your trading platform Bid/Ask prices so you can make profitable decisions in real-time

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.