calculate theta

How to Calculate Theta For An Option

Learn how to calculate theta and understand how to add time decay to your spreadsheets.

February 14, 2023
    Add a header to begin generating the table of contents

    When buying or selling an option, one of the most important options greeks is theta, which also referred to as time decay. Most broker platforms will calculate the value of theta automatically for you. If you calculate theta for yourself using your spreadsheet, be aware that the theta formula is yearly. Most option traders find it more useful to convert the value to a daily number and understand the daily time decay for the option they are considering. That’s why broker platforms will deliver theta as a daily value to users.

    Calculate option theta for a put
    Theta put option formula

    Calculating Theta Using Black Scholes

    The yearly theta value is calculated by dividing the rate of change in the option premium paid by the rate of change in time. This value should then be divided by 252 to convert the annual value into a value for a single trading day or by 365 to convert the value into calendar days.

    calculate theta for call options
    Theta call option formula

    The formulas used to calculate this vary depending on whether the option is a call or put.  In order to calculate theta, you must have already calculated d1 and d2 using Black Scholes. It can be very complex to calculate d1 and d2 using a spreadsheet because it is a recursive function and must be executed over and over as each calculation comes closer to arriving at the correct result. It is infinitely easier to use the Market Data Sheets Add-on, which will calculate theta for you automatically with a simple formula.

    calculating theta with marketdataCalculate Theta With Market Data’s Add-on

    Let’s see an example using the $160 AAPL Jul 21, 2023 Call. The option symbol for this call is AAPL230721C00160000. After installing the Add-on, use the formula =OPTIONDATA("AAPL230721C00160000","theta").  As you can see, that’s much easier than trying to calculate theta manually using Black Scholes.

    Share This Tutorial

    Comments & Questions