Support Board
Date/Time: Mon, 25 Nov 2024 05:41:59 +0000
Post From: Is it possible to get an updating total of two chart's NPL in real time?
| [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. |