For
@Lycanthrope and anyone else who tracks trades with spreadsheets:
How do you organize your trades into weeks to calculate your weekly profit/loss? Based on the day you opened the trade, the day you closed the trade, the expiration date of the option/spread, or something else?
Most of my trades are opened on one week and closed on another, but some of them are closed early on the same week they were opened, which might not be the week they expire, so no matter what I do it seems like there are some exceptions. I think I don't want to be in a position where I have to go back and change the total for a prior week, so I'm thinking the best way might be to group into weeks based on the day I close a trade, even if I got the income for opening those trades on a prior week, except then longer-dated options just hang out in the "future" bucket for a while (and if I sold them and got paid up front, I may have a lot of cash that's not yet reflected in the weekly totals).
Or do you just track the cash in/out instead of making the individual trades the thing? That seems weird because you get the cash up front for selling options, but you don't know at that time how much of it you'll get to keep (or how, much more you might lose, worst case).
How is this normally done?