Support Board

Date/Time: Sat, 18 May 2024 07:57:54 +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] Link To Thread - Link To Post [Go To First Post]
trader2017 - Posts: 93
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.