Support Board
Date/Time: Mon, 25 Nov 2024 02:55:58 +0000
Is it possible to get an updating total of two chart's NPL in real time?
View Count: 274
| [2024-04-05 15:04:25] |
| trader2017 - Posts: 98 |
|
Hello, if I am trading four symbols on four charts in one account and would like to have a total in real time of two of those symbols’ NPL profit and loss, is that possible? When I look at the Trade Activity Log under the Chart Stats tab, I can see the itemized list of symbols, but the total is for all of them, I cannot select two of them and have a subtotal of just those two. Changing the Display Settings does not allow me to get a subtotal displayed anywhere in the Trade Activity Log. I think the answer is in a spreadsheet study, but I’m not sure which one or whether a spreadsheet study can reference two separate charts trading different symbols and add the NPL together in real time. |
| [2024-04-05 15:38:57] |
| John - SC Support - Posts: 36238 |
|
The spreadsheet will not do it alone and is probably more than you really need. The only way to really do this is to use the "Trading: Position Average Price" study, which gives you that information in a subgraph. You can then use the "Study Subgraphs Difference" study to subtract the "Trading: Position Average Price" from the Last price, giving you the Net P/L in Points. You can then overlay the "Study Subgraphs Difference" to another chart and do the same thing there and then use the "Study Subgraphs Add" to add the values together to get what you want. You can then hide all of these and use the "Text Display for Study" to display the Net P/L for those two charts. Refer to the following: Trading Information Windows: Trade Data Studies Study Subgraphs Subtract/Difference Study/Price Overlay Study Using the Basic Arithmetic Studies For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-04-06 08:18:48] |
| trader2017 - Posts: 98 |
|
Thank you for all that information, I needed the number of contracts for each symbol to be included in the NPL and also do some other calculations on the data, so I thought I’d write back to let you know and anyone else who is reading this what I ended up doing. I added the Spreadsheet System for Trading study to the chart and that had the open and closed profit in the cells already calculated in the J column rows 10, 11, and 45. I found this page: https://www.sierrachart.com/index.php?page=doc/Spreadsheets_ReferencingOtherChartsInFormulas.php#top That had information about using a common spreadsheet for multiple charts and said to add the Spreadsheet Study with the same Spreadsheet Name to each chart and then I was able to add a new sheet to the spreadsheet and on that new sheet was able to reference all the data from the other charts and write whatever calculations I needed and have them update in real time. |
To post a message in this thread, you need to log in with your Sierra Chart account: