Support Board

Date/Time: Sun, 19 May 2024 00:37:10 +0000

Post From: Spreadsheet System for Trading - Cell J10 (Open P/L) calculating incorrectly in v.1978?

[2019-08-23 01:17:59] Link To Thread - Link To Post [Go To First Post]
User538063 - Posts: 3
I would like to withdraw this request. I discovered an error in my logic. I see that J10 IS correctly calculated, although it produces a different result than it did in the older version if and only if you enter a position at one price, add to that position at a different price, then close a portion of the position. It appears that the new version assumes that when you close a portion of the position, you are closing the oldest entry first, not the newest entry first. It appears the older version I was using assumed the opposite - newest first instead of oldest. I will find a workaround for my system, so there is no further need for you to look into this. I apologize for the inconvenience and hope that no one spent any significant time on it. Thank you.