Support Board
Date/Time: Tue, 22 Apr 2025 10:29:17 +0000
Automatic Opening of Custom Spreadsheet with ACSIL Study
View Count: 236
| [2025-01-20 07:01:16] |
| Julien Vieillard - Posts: 12 |
|
Dear Sierra Chart Support and Community, I am writing to request assistance with a custom study I've created using ACSIL. I have developed a custom study that interacts with a spreadsheet. I would like the spreadsheet "MyCustomSpreadSheet.scss" to open automatically when my custom study "MyCustomStudy.dll" is loaded. However, I am unable to achieve this behavior. I have to manually open the spreadsheet each time. For example, when I add the "Spreadsheet Study" available study to my chart, the "DefaultSpreadsheetStudy.scss" spreadsheet opens automatically in a new tab of my ChartBook. I would like to replicate this behavior for my custom study. I believe there might be a specific function or setting within ACSIL that would allow me to automate the opening of the spreadsheet upon study load. Could you please provide me with some guidance or examples on how to accomplish this? Thank you for your time and assistance. Sincerely, Julien |
| [2025-01-21 17:32:00] |
| John - SC Support - Posts: 39395 |
|
You could add the Spreadsheet Study to the chart, the set it to open, the spreadsheet that you need: Chart Studies: Settings and Inputs Tab >> Spreadsheet Name / DLL File and Function Name Also refer to: ACSIL Programming Concepts: Direct Programmatic Interaction with Spreadsheet Sheets For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-01-23 06:34:05] |
| Julien Vieillard - Posts: 12 |
|
Hello John, Thank you for your help. I followed your advice, and while "MyCustomSpreadSheet.scss" opens correctly when linked to "Spreadsheet Study", I now have an issue with the interaction of this spreadsheet with two studies: "MyCustomStudy.dll" and "Spreadsheet Study". The data in "MyCustomSpreadSheet.scss" is being updated by both studies simultaneously. As soon as I remove "Spreadsheet Study" from the chart, "MyCustomSpreadSheet.scss" automatically closes. Could you provide more information or suggest other solutions? Best regards Julien |
| [2025-01-23 15:40:11] |
| John - SC Support - Posts: 39395 |
|
Wwe are not quite understanding the issue. ACSIL does not have any support for directly opening a Spreadsheet file, and for a spreadsheet to have the formula columns it needs to be part of the "Spreadsheet Study". So if this is what you want, then you need to have the Spreadsheet Study added to the chart so you can interact with it through your studies. 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: