Options and Quant Finance since 2012

Individual Investors

Take your trading to next level. From guessing to calculated decisions. Without a maths PhD.

Learn options with hands-on tutorials. From basics to advanced concepts that give you real edge.

Macroption calculators are easy to use for a beginner, and powerful enough for a seasoned pro.

Financial Professionals

Say goodbye to overly complex spreadsheets and software bloated with features you never use.

Macroption calculators are clean, simple, well documented and supported.

On the market since 2012, with overwhelmingly positive feedback. See what customers say.

Quant & Fintech Developers

Find detailed explanation, formulas and reference for asset pricing and financial models.

I have more than a decade of experience working with financial data from various angles.

Let me help with your project. See overview of services.

Option Strategy Payoff Calculator

Option Strategy Payoff Calculator

P/L at expiration, risk/reward ratios, break-even points for 57 option strategies. Compare two strategies in one chart. [more...]

Option Strategy Simulator

Option Strategy Simulator

Advanced strategy modeling: what-ifs, aggregate Greeks, implied volatility. Also intraday. [more...]

Option Portfolio Manager

Option Portfolio Manager

Option portfolio management with unlimited legs, sensitivity to combined effect of two factors, rollovers and adjustments. [more...]

Price Probability Calculator

Price Probability Calculator

Probability that price will be above or below a certain level or within a certain range at a given point in the future. [more...]

Black-Scholes Calculator

Black-Scholes Calculator

Calculating option prices and Greeks using the Black-Scholes-Merton model. [more...]

Binomial Option Pricing Calculator

Binomial Option Pricing Calculator

Binomial option pricing models (Cox-Ross-Rubinstein, Jarrow-Rudd, Leisen-Reimer). For equity, index, forex, and futures options. [more...]

Tutorials and Reference

Expiration Calendars

VIX Expiration Calendar 2024-2025 (Futures & Options)

Below you can find VIX futures and options expiration calendar for 2024, 2025 and 2026, as well as full VIX expiration dates history (2004-2023) and explanation of VIX expiration rules. For standard US equity, index and ETF options (including options on VIX ETFs and ETNs) see: Standard US Equity and [more...]

Options Expiration Calendar 2024-2025 (US Equity, Index, ETF Options)

Below you can find options expiration calendar for 2024, 2025 and 2026 for standard US traded monthly and weekly equity, index, and ETF options, as well as expiration dates history for earlier years. For VIX options and futures, see VIX Expiration Calendar. Options Expiration Calendar 2024 Monthly option expirations: 19 [more...]

Calculating Option Strategy Payoff in Excel

This is part 4 of the Option Payoff Excel Tutorial. In the previous parts (first, second, third) we have created a spreadsheet that calculates profit or loss for a single call or put option, given the strike price, initial option price and underlying price. Now we are going to expand [more...]

Drawing Option Payoff Diagrams in Excel

This is part 5 of the Option Payoff Excel Tutorial, which will demonstrate how to draw an option strategy payoff diagram in Excel. In the previous four parts we have explained option profit or loss calculations and created a spreadsheet that calculates aggregate P/L for option strategies involving up [more...]

Black-Scholes Formulas (d1, d2, Call Price, Put Price, Greeks)

This page explains the Black-Scholes formulas for d1, d2, call option price, put option price, and formulas for the most common option Greeks (delta, gamma, theta, vega, and rho). Black-Scholes Inputs According to the Black-Scholes option pricing model (its Merton's extension that accounts for dividends), there are six parameters which [more...]

Black-Scholes Excel Formulas and How to Create a Simple Option Pricing Spreadsheet

This page is a guide to creating your own option pricing Excel spreadsheet, in line with the Black-Scholes model (extended for dividends by Merton). Here you can get a ready-made Black-Scholes Excel calculator with charts and additional features such as parameter calculations and simulations. Black-Scholes in Excel: The Big Picture [more...]

Option Greeks Excel Formulas

This is the second part of the Black-Scholes Excel guide covering Excel calculations of option Greeks (delta, gamma, theta, vega, and rho) under the Black-Scholes model. Calculating Black-Scholes Greeks in Excel I will continue in the example from the first part to demonstrate the exact Excel formulas. See the first [more...]

How Binomial Trees Work in Option Pricing

This page explains the logic of binomial option pricing models - how option price is calculated from the inputs using binomial trees, and how these trees are built. Binomial Model Assumptions All models simplify reality, in order to make calculations possible, because the real world (even a simple thing like stock [more...]

Converting Implied Volatility to Expected Daily Move

This page shows how to convert implied volatility (typically annual standard deviation of returns) to daily volatility and how to interpret it in terms of expected daily price changes with given probabilities. Note that in the Implied Volatility Calculator you don't need to do the conversion, as the calculated implied [more...]

VIX Calculation Explained

This page explains the logic of VIX calculation and some of the underlying assumptions and parameters. Exact formulas are available in VIX White Paper by CBOE. If you are not familiar with the VIX index, you may first want to see a more basic explanation: What is VIX? Basic Logic [more...]

VIX Futures Curve

VIX Futures Curve Explained A futures curve is a curve made by connecting prices of futures contracts of the same underlying, but different expiration dates. It is displayed on a chart where the X-axis represents expiration dates of futures contracts and the Y-axis represents prices. The chart looks quite similar [more...]

Calculating Average True Range (ATR) in Excel

This is detailed guide to calculating Average True Range (ATR) in Excel. We will first calculate true range and then ATR as moving average of true range. We will cover all three popular ATR calculation methods - simple, exponential, and the original Wilder's smoothing method. You don't need advanced Excel skills [more...]

RSI Calculation

This page is a detailed guide how to calculate Relative Strength Index (RSI). You can see how the formulas work in Excel in the RSI Calculator. The calculation is explained in detail in chapter 4 of the calculator's guide. RSI Formula RSI = 100 - 100 / ( 1 + RS ) RS = Relative Strength = AvgU / [more...]

Put-Call Parity Formula

Put-call parity is a relationship between prices of European call and put options (with same strike, expiration, and underlying). It is defined as C + PV(K) = P + S, where C and P are option prices, S is underlying price, and PV(K) is present value of strike. This page explains [more...]

Black-Scholes Model History and Key Papers

This page is an overview of main events and papers related to the Black-Scholes option pricing model. Besides works of its main authors, Black, Scholes, and Merton, we will also investigate earlier ideas which influenced the model, and other researchers (many of them famous for other models) who played a [more...]

By remaining on this website or using its content, you confirm that you have read and agree with the Terms of Use Agreement.

We are not liable for any damages resulting from using this website. Any information may be inaccurate or incomplete. See full Limitation of Liability.

Content may include affiliate links, which means we may earn commission if you buy on the linked website. See full Affiliate and Referral Disclosure.

We use cookies and similar technology to improve user experience and analyze traffic. See full Cookie Policy.

See also Privacy Policy on how we collect and handle user data.

© 2024 Macroption