Login Page - Create Account

Support Board


Date/Time: Sun, 19 May 2024 00:52:44 +0000



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

[2019-08-22 20:47:42]
User538063 - Posts: 3
Today I updated from version 1549 to current version 1978 and suddenly noticed that cell J10 (Open P/L) seems to be calculating incorrectly, but only when I add to an initial position.

For example, if I open a position of 1 emini contract, J10 calculates correctly. However, when I add a 2nd contract to the position at a different price, the cell suddenly calculates incorrectly. Cell J9 (average position price) seems be correct in this scenario, but cell J10 does not seem to calculate based off the average position price, but from some other undetermined price.

Could you please check this out to verify? I use cell J10 to calculate several trading parameters in my spreadsheet and there was never a problem in the older version that I was using.

Thank you for your attention.