Here's the spreadsheet I (with the help of ChatGPT) put together to track my Bull Put Spreads. Eventually I'm sure I'll build out something more robust to track all my trading with different strategies, but wanted to keep it relatively simple to start.
I originally built it out with my paper trading, then this morning created new tabs for real trading but kept the trades in there as examples - just delete those rows once you don't need them anymore.
Once a trade fills, just cut/paste the row into the Closed Trades tab and everything should update automatically. :)
Something I found out the hard way: Microsoft is a bitch about auto-save now (you have to store the file in OneDrive for auto-save to work, which is the rankest BS I've ever heard) so look into that if you've lost the habit of reflexively saving your work like I have. I probably should have built this in Google Sheets but I like Excel better.