Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
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).
Can you help answer these questions from other members on NexusFi?
it is easier to calculate if you number them in their seq, Ninja calculation bases on FIFO order;
in the table
1(IN) 2(OUT) = +87.5
3(IN) 5a(OUT) = -225
4a(IN) 5b(OUT) = +150
note: you still have 4b running.
also adding $5 per a completed transaction = 3x5 = -15 you made -2.5
The following user says Thank You to cory for this post:
@cory, Thank you. I for sure didn't use FIFO for doing the calc and that does explain it. I was using the Avg Price calculation as above. Yes, I have a long runner still active.