Excel Calculators

Options and Volatility Calculators

Option Strategy Payoff Calculator

Calculate payoffs at expiration for 54 different option strategies. Profit or loss for given underlying price. Break-even points. Risk-reward ratio. Payoff charts. [more…]

Option Strategy Simulator

Simulate scenarios and what-ifs for any combination of up to 5 legs. Not only at expiration, but at any time, including intraday. Aggregate Greeks, P/L, break-even points. [more…]

Black-Scholes Calculator

Calculate option prices and Greeks using the Black-Scholes-Merton model. Simulate effects of individual parameters on option prices and Greeks. [more…]

Implied Volatility Calculator

Calculate implied volatility from option prices with one click. Model effects of volatility changes on option prices and Greeks. [more…]

Historical Volatility Calculator

Calculate historical volatility from historical prices. Supports three historical volatility calculation methods, including centered and non-centered HV. [more…]

Technical Analysis Calculators

Average True Range (ATR) Calculator

Calculate Average True Range (ATR) and Average Range from historical prices. Supports 12 different variations, including the original ATR as introduced by J. Welles Wilder Jr. in 1978. [more…]

Relative Strength Index (RSI) Calculator

Calculate Relative Strength Index (RSI) from historical prices. Supports 3 common versions: the original Wilder’s RSI, simple moving average RSI, and exponential moving average RSI. [more…]

Statistics Calculators

Descriptive Statistics Calculator

Calculate summary statistics and analyse distributions. Mean, median, variance, standard deviation, skewness, kurtosis, percentiles, standard scores, frequency histogram. Compare data set to normal distribution. [more…]

Frequently Asked Questions

Is it a one-time payment or monthly/recurring?
One-time payment, yours forever.

Does it work in my version of Excel?
All calculators works in all versions of Excel from Excel 97 to Excel 2016. Most were developed in Excel 2010 and tested in other versions. For older versions you may need to use a different version of a calculator, which is always included.

Does it work in OpenOffice / LibreOffice / Apple Numbers / other spreadsheet software?
The calculators may work in some, but unfortunately we can’t guarantee it and can’t provide support for software other than Microsoft Excel. Generally you need your software to support Excel formulas and (with most calculators) macros.

Is there a money back guarantee?
Yes. If you are not happy with a calculator for any reason, just send an email within 30 days of purchase and we will refund you, no questions asked.

How do I pay? Is it secure?
You can pay by credit/debit card or PayPal. All payments are processed by PayPal, which provides world-class security and buyer protection. You don’t need a PayPal account to check out when paying with a card.

I have other questions / need more information.
Please contact us.

Related pages

most liquid etf optionsarithmetic mean calculatorformula for skewvix implied volatilityblack-scholes option valuation modelcboe indexhow to interpret kurtosismoving average graph excelexcel standard deviation calculationlong short etfstraddle optionvariance calculation in excelblack scholes call option formulablack and scholes equationweighted average cost accountingbullish put spreadrange variance and standard deviation calculatorvolatility index meaningvix term structure cboepayoff put optionblack scholes put optionvolatility index meaningformula for calculating variance in statisticskurtosis interpretation spssexcel normdist functionrumus total costpreferred equity formulasharpe ratio formulacalculating standard deviation on calculatormerits and demerits of arithmetic meansell strangleproshares short vix short term futures etfvariance calculator exceloptions expiration calendartheta in options tradingvariance calcnotepad _butterfly spread calculatorhow to write ln in excelformula of population meanarithmetic average rate of return formulaapple stock history graphstandard deviation computational formulablack scholes putform 13f-hrstdev definitionwilders moving average2x s&p 500 etfcboe vix settlementrsi explainedkurtosis of normal distributionblack scholes simplifiedhistorical volatility calculationyahoo finance currency historical datacalculating mean in excelstd dev calcquote uvxycompute weighted average cost of capitalmerits and demerits of central tendencystock standard deviation calculatorstraddle deltaexcel formulas spreadsheetetf short sp500delta formulasexcel sqrthow many shares in 1 option contractdivergence macdrealized rate of return calculatormeaning of waccexcel variance formulaput option strike pricejohn hull futures options and other derivativesrelative strength index calculatorfx implied volatility