Support Board
Date/Time: Sun, 19 Jan 2025 09:05:21 +0000
Post From: how to get net daily P/L value to spreadsheet?
[2018-03-26 10:15:49] |
User701453 - Posts: 176 |
You'll have to calculate it using cells J10, J45, and J53.
J53 will show a fill for every entry and every exit of each contract, e.g a round trip of 1 contract will show 2. A daily closed net P/L formula would look like this, where H2 contains the round trip commission: =J45-J53*H2/2 SC Support: Please add tomgilb code snippet to support page: http://www.sierrachart.com/index.php?page=doc/SpreadsheetExampleFormulasAndUsage.php |