Insert Mockery Here

[morganpbrown]

Very impressive. I have never seen options analysis this detailed in Google sheets.

It seems ready to replace Excel. Can you take a quick peek at Hoadley Tools and determine if all those features can be implemented in sheets?

Is the performance without hiccups?

https://www.hoadley.net/options/options.htm

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.

 

[themickey]

To run sheets are you using a chromebook/Pixelbook?

 

[carteblanche]

No, google sheets. However, I implemented a black scholars tool using google apps script, kind of like Visual Basic for excel. However, apps script is just JavaScript.

Thanks for the feedback. I will exit some of these trades soon

Pm id like to know more about that

 

[morganpbrown]

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.

 

[morganpbrown]

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.

 

[morganpbrown]

To run sheets are you using a chromebook/Pixelbook?

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.

 

[morganpbrown]

Pm id like to know more about that

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.

 

[themickey]

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.

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.

 

[morganpbrown]

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.