#Rolling #ReverseRoll
I got this question via email: “…with all my rolling of short positions, I’m having a hard time keeping track of each position. I’ve had to roll some positions 4-5 times, and more, especially SVXY, so that my cost basis seems to get lost in all the mess. I currently use an Excel spread sheet that I listed monthly trades, but then I found I had to search for the strike, then enter the roll position, and it just keeps going. Finding each position after a few rolls has been difficult. Any good way that you have found to keep track of the position when you roll, especially numerous rolls?”

I can’t do you much better than Excel, but maybe others can reply with their methods. I track each trade on Excel, and if I roll the position, I will extend that trade’s Excel row to the right, adding and subtracting the costs of each roll into the P/L for that trade… goal is to come out with a profit, or at least breakeven in the end. I can provide more detail if that’s not clear, but it can be a bit confusing with multiple rolls.