Support Board
Date/Time: Mon, 16 Jun 2025 17:34:42 +0000
Post From: Interactions between spreadsheets
| [2025-05-06 12:36:10] |
| trader.123 - Posts: 3 |
|
Hello, I am using spreadsheet system for trading on 50+ contracts. One spreadsheet is not able to handle more than 5-6 products, so I am using 10 spreadsheets, each containing links with 4-5 charts (using sheet1, sheet2, etc. for all). Now the problem is each individual contract logic in spreadsheet depends on whole portfolio, so I need some values from one spreadsheet to be read in another and so on. What is the best way to achieve this? p.s. currently I am using custom study applied in one chart only which is written in such a way that it reads specific cells from all spreadsheets, does some arithmetic operation on those values and writes the final value in all spreadsheets' specific cell. This study is making all spreadsheets really slow to work with and SierraChart also keeps crashing, so does the PC. I want to find an optimum solution to lessen the load. |