### Option Strategy Payoff Calculator

P/L at expiration, risk/reward ratio, break-even points for 54 option strategies.

P/L at expiration, risk/reward ratio, break-even points for 54 option strategies.

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

The objective of this page is to explain the logic of VIX calculation and some of the underlying assumptions and parameters. Exact formulasÂ are available in a short pdf named VIX White Paper on the official website of CBOE. If you are not familiar with VIX, you may first want to [more…]

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…]

Black-Scholes 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. I will continue in the example from the first part to demonstrate the exact Excel formulas. See the first part [more…]

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…]

This is a 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 do all the three popular ATR calculation methods â€“ simple, exponential, and the original Wilder’s smoothing method. You don’t need [more…]

Contents Calculating Call and Put Option Payoff in Excel Merging Call and Put Payoff Calculations Short Option Payoff and Position Size Option Strategy Payoff and Multiple Legs Drawing Option Payoff Diagrams in Excel Calculating Option Strategy Maximum Profit and Loss Calculating Option Strategy Risk-Reward Ratio Calculating Option Strategy Break-Even Points [more…]

This page is a detailed guide to calculating historical volatility in Excel. Things Needed for Calculating HV in Excel Historical data (daily closing prices of your stock or index) – there are many places on the internet where you can get it for free, including Yahoo Finance or Google Finance [more…]

This page is a detailed guide to finding and downloading historical data such as daily stock prices or index values from Yahoo Finance. Go to Yahoo Finance homepage: finance.yahoo.com At the moment and on my computer it looks like this. It may look a little different on your device, but [more…]