Maximizing Wash-Sale losses from 2023 against options gains in 2024
Been percolating in my mind and today I put it to action. Maybe some of you do this already, but sharing in case it can be useful to others:
1) I exported all trades I made in 2023 in CSV format from my broker and brought the file into Excel
2) Deleted all non-option trades (i.e., straight shares) and kept any option trades that had DTE in 2024-2026
2) Sorted by loss/gains and deleted all those with gains
3) Sorted by date and deleted all trades with an expiration before 1/1/24
4) Combined the remaining trades of the same DTE and made a total of losses for that strike/DTE
5) Saves a list of those positions and DTE
Now I have a list of options I can re-use in 2024, when they make sense obviously, and any gains on them will be tax-free, since I took the losses last year and wash-sale rules carries the losses over against gains on the same trade in the new year (here 2024). Often we forgot which trades they were and they disappear in the ether without us benefitting from the carry-forward of losses which offset new gains on the same contracts opened and closed in 2024.
For me that came to this list below which seems very doable. I can give preference to these trades when the opportunity comes and enjoy gains against the carried-over losses.
If I'm missing something in this thought-process please let me know!
My resulting list of 2023 wash-sale positions with carried over "credits" into 2024
+C230 1/19/24
-C270 1/19/24
-C250 3/15/24
-C280 3/15/24
-C300 3/15/24
-C300 6/21/24
-C300 9/20/24
+C150 12/19/25
-P300 12/19/25
-C450 12/19/25
+C300 1/16/26