Thanks. It's too bad that the trader who developed these google sheets tools (me) doesn't have a clue about real trading! To solve the Black-Scholes equation, I actually use google apps script, which is akin to visual basic for excel, but more user friendly (javascript) I'm actually working on a collaboration with ORATS to automatically pull historical options data into this google sheet and analyze. So that is exciting. To answer your question, I am fairly certain that google sheets + apps scripts + the ORATS plugin ($29/month?) can probably do anything on your list as well or better than Excel. It would just require someone to implement the tools.
Exit trade #3, (1 lot) diagonal SPY call debit spread opened on November 2. Cost: $7.18. Sale: $8.17. $0.99 profit. Trade had a slightly bullish expectation Volatility and SPY stayed pretty flat over the trade period, so the trade worked more or less as expected. Trade was positive vega, so I did benefit from the increase in volatility, even though the price moved well outside the peak of the P&L at $462.
Trade #6: SPY call diagonal debit spread, slightly bullish bias. Profitability range at 6 DTE: $463-$482. SPY $467 at open. Delta neutral. Slightly vega positive, which is OK with me, as it will cushion the downside, should stock move against me. theta/gamma ratio flat over life of trade. I'm bullish because any downturn in SPY in the last year seems to be presaged by a pickup in volume. Volume is low and flat, and has declined from last week's swoon. I will close this trade if we get a meaningful increase in daily volume.
I am just using an old windows 7 desktop with 4 GB of RAM. These google sheets are memory hogs. Might be tough on a machine without sufficient memory.
To use the apps scripts, go to Extensions->Apps Script. Then you write your code in javascript. Here's the Black-Scholes code. This function just returns the option price, greeks, and IV for one day. It pushes those values into a column. You wouldn't want your spreadsheet to call the function for every day in an option's life. Rather, I wrote another function that simply loops over the number of days in the option's life. This function returns a row of price/greeks/IV for each day. There's some other stuff going on inside the function; specifically I allow the share price to vary and use a sticky delta IV model to predict IV. Then from the spreadsheet, you call the function, supplying it with its needed input values. It returns a matrix of price/greek/IV for the option. To model the performance of a spread, I just call the function for the various options in the spread.
Exactly. I use the google laptops/chromebooks/pixelbooks with max memory, you pay a premium for these over the others, eg ASUS but it helps with making the sheets flow smoother. After every trading session I clear the cache/memory. Using Chrome OS & cloud is better than windows imo for what I do, I have no crash or long bootup issues neither antivirus issues. I run huge sheets, sometimes take a minute to load.
haha, I bought 50 shares of Rivian (RIVN) at $99. Sitting at $165 now. I should have bought 100 shares, so I can sell covered calls against it. To delta hedge, I sold a Dec 17 call credit spread (165 short/210 long) for $12.80. Takes my net delta down to ~25.