Support Board
Date/Time: Wed, 10 Sep 2025 08:14:11 +0000
P and L Spreadsheet in points
View Count: 1223
| [2016-04-11 12:16:22] |
| User623552 - Posts: 70 |
|
Hi, Is it possible to create a P&L spreadhseet I'd like to see the live and closed P&L for each individual instrument, and a total global P&L for the day However I'd like to see ALL the P&L data in points, not in any monetary figure (as per the account balance study) Actually to make it clearer : The P&L in ticks. So every instrument, and the global P&L is calculated on how many ticks of profit and loss have been made (regardless of the monetary value of a tick) Date Time Of Last Edit: 2016-04-11 12:20:27
|
| [2016-04-11 12:41:21] |
| Sawtooth - Posts: 4262 |
|
You could glean the pertinent formulas from this: http://www.sawtoothtrade.com/free-stuff-1.html |
| [2016-04-11 14:35:15] |
| User623552 - Posts: 70 |
|
Thanks - There is some useful information there, to get me a closer ! Unfortunately it didn't work ..... Sierra just crashed Date Time Of Last Edit: 2016-04-11 14:42:30
|
| [2016-04-11 15:32:37] |
| Sawtooth - Posts: 4262 |
|
The download from that link is for Old Spreadsheets, and it might not have converted properly for you. Use the attached instead. Use the study collection if you are adding this to a chart so that the correct spreadsheet study and settings are used. Even after conversion this wasn't functional in the New Spreadsheets and it required a rework. BTW, the y/n are case sensitive. |
 DailyPL-.StdyCollct - Attached On 2016-04-11 15:10:08 UTC - Size: 9.39 KB - 434 views DailyPL.scss - Attached On 2016-04-11 15:30:39 UTC - Size: 27.33 KB - 372 views |
| [2016-04-11 16:56:32] |
| |
|
Have a look at the Trade Statistics for Charts tab in the Trade Activity Log: https://www.sierrachart.com/index.php?page=doc/doc_TradeActivityLog.php#ChartTradeStatsTab 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: