# Calculate Option Greeks in Google Sheets > The OPTIONDATA formula pulls delta, gamma, theta and vega straight into your spreadsheet, so position risk updates itself with the market. Source: https://www.marketdata.app/sheets/options/calculate-option-greeks/ --- (image: The Greek alphabet in white capitals on dark grey, five rows of five, delta and theta among them.) - [Options Data](/topics/data/options/) - [Options in Google Sheets](/topics/sheets/options/) - [Tutorials](/tutorials/) # How To Calculate Option Greeks In Your Spreadsheet The OPTIONDATA formula pulls delta, gamma, theta and vega straight into your spreadsheet, so position risk updates itself with the market. - Last updated September 23, 2024 (image: Google Sheets with =OPTIONDATA("AAPL230120C00150000","price,greeks") in cell A1, returning Mid 10.35, Delta 0.538, Gamma 0.016, Theta -0.066, Vega 0.294 and Rho 0.169 across row 2) It is easy to calculate option greeks (Delta, Gamma, Theta, Vega, Rho) in your spreadsheet. **Add “greeks” as a parameter to the `OPTIONDATA` formula** like this: `=OPTIONDATA("AAPL230120C00150000","price,greeks")`. In addition to the price, this will output the 5 option greeks. If you don’t need all the greeks, **you can request just the ones you need individually**: `=OPTIONDATA("AAPL230120C00150000","price,delta,gamma")` would return just delta and gamma along with the price of the option. You need to download the [Market Data Google Sheets Add-on](/sheets/) to enable the OPTIONDATA formula. ## Calculate Option Delta For Spreads (image: Google Sheets showing a vertical credit spread: the short AAPL230120P00160000 at delta -0.625, the long AAPL230120P00150000 at delta -0.461, and cell B7 combining them for a spread delta of 0.165)**You can combine multiple OPTIONSDATA formulas to calculate the greeks of your credit spreads, iron condors, and other strategies**. Let’s say you are short a $10 put spread for AAPL at the $160/150 strikes. You can use two OPTIONDATA formulas to calculate the delta of this spread using the following formula: `=-OPTIONDATA("AAPL230120P00160000","delta") + OPTIONDATA("AAPL230120P00150000","delta")`. It appears complex, but it is actually surprisingly simple. You just use `-OPTIONDATA("contract","delta")` for the option you are short and `+OPTIONDATA("contract","delta")` for the option your are long. The result is the combined delta of the option spread, which is automatically calculated by combining the delta of the two options. ## Calculating the Daily Loss Due To Theta Decay of A Portfolio of Options (image: Google Sheets listing five option positions with =OPTIONDATA(A2,"theta")*D2*100 in the Theta Decay column — AAPL -17.4, SPY -10.4, MSFT -21, CCJ -13 and WMT -7 — summing to -68.8 against a net liquidation value of 7,708)Theta is the greek that tells us about the time decay of the option. Theta works against option buyers and in favor of option sellers. If we’re holding a portfolio of calls it can be useful to determine the dollar amount of the theta decay of the portfolio. With Market Data, this is extremely easy to calculate. Just use `=OPTIONDATA("contract symbol", "theta")*quantity of call options*100`. This will show you a dollar amount you are losing each day due to theta decay in your portfolio. For [option writers](https://www.reddit.com/r/thetagang/), just add a negative sign before the `OPTIONDATA` formula (since you are short the option) and you can see how much theta you are collecting per day for writing a portfolio of options. If you watch theta decay around [earnings](/sheets/stocks/earnings-calendar/), you’ll see theta isn’t 100% linear. **No matter which way you decide to play the theta game, Market Data will keep you informed.** ## Calculate The Option Greeks And Get Automatic Risk Management Alerts In Your Spreadsheet (image: Google Sheets conditional format rules panel applying a red fill to cell C2 when the value is less than or equal to -0.5, coloring the short option's delta of -0.625 red)Using greeks opens up a whole new realm of possibilities in Google Sheets to **easily configure your risk management however you’d like it**. Suppose I’d like to be notified when the short end of my option spread gets tested so that I can roll out the spread. Use the _Conditional formatting_ option in the _Format_ menu to easily accomplish this. In this example, I’ve configured my sheet to highlight in red the delta of the short option when it goes below -0.5. Since that’s happening right now, this cell will be highlighted in my sheet, alerting me that I should be rolling out this credit spread. Are you worried about getting gamma-squeezed? No problem, just add an alert and don’t let gamma sneak up on you. Conditional formatting is not a substitute for your broker’s real-time alerts, since **they are only displayed if you login to your spreadsheet**. However, they can be useful when you are tracking dozens of trades at once since they easily draw your attention to specific contracts or spreads that have exceeded the exact parameters that you’ve set. Let us know in the comments how you’re using the options greeks in your portfolio.