Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 20 Apr 2024 02:45:52 +0000
Spreadsheet System for Trading - Cell J10 (Open P/L) calculating incorrectly in v.1978?
View Count: 601
| [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. |
| [2019-08-23 01:17:59] |
| 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. |
| [2019-08-23 05:18:58] |
| |
|
You can control the method of the Position Average Price calculation: Trading Information Windows: How Average Price for Positions Is Calculated and Used Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: