I had the NT Account Performance Tab produce a wrong (?) result.
Can somebody explain what I'm seeing here?
Here is the sequence of events and a data table below that.
I had, on Monday, bought 1 long @ 2100.5 which I sold at 2102.25. Gain is 1*50*(2102.25-2100.5)=87.5
This was correct yesterday.
Then I bought 1 long @ 2104.5 and the price went south. Avg Price on 1 is 2104.5
at a later time, I bought 2 long @ 2097.0 and my new Avg Price is (2104.5+2097+2097)/3=2099.5.
at a later time again I sold 2 @ 2100.00 and that's when my Realized PnL went to 12.5.
Huh? I just made $50 on that sale and 87.5 on the prior. What Gives? I still have 1 long position if that makes any difference. Has overnight got a factor in this?
Not only that, but my Account Summary sure seems goofed up as well.
Total Net Profit shows $12.50. Gross Profit is $237.50 (I wish) and Gross Loss was $-225.00 (??!!). None of these numbers are correct.
Where did these numbers come from? Just before the start of trades, I had reset my sim account totally. The trades I'd made before the reset were also positive.
I expected the Realized PnL to show 87.50+50 for 137.50. On summary I expected to see Gross Profit = Net Profit = $137.50 and 0 Gross Loss.
Here is the Order (the only orders in the entire thing as the sim had be reset and history cleared).