Support Board
Date/Time: Sat, 01 Nov 2025 18:43:30 +0000
[User Discussion] - how to get net daily P/L value to spreadsheet?
View Count: 1084
| [2018-03-25 00:04:22] |
| User439550 - Posts: 12 |
|
I would like to get the net P/L value i.e. net after commissions to a spreadsheet study. Where do I start? how to formulate the cell to reflect the net P/L of the day? thanks... |
| [2018-03-25 03:34:43] |
| Sawtooth - Posts: 4282 |
|
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 |
| [2018-03-25 12:03:43] |
| User439550 - Posts: 12 |
|
Yeah I missed J53, thank You!
|
| [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 |
To post a message in this thread, you need to log in with your Sierra Chart account: