Support Board
Date/Time: Mon, 16 Jun 2025 10:28:44 +0000
Interactions between spreadsheets
View Count: 233
| [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. |
| [2025-05-06 19:59:49] |
| Sierra_Chart Engineering - Posts: 19924 |
|
We recommend developing what you need using ACSIL completely: Advanced Custom Study Interface and Language (ACSIL) 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, use 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: