Support Board
Date/Time: Fri, 24 Jan 2025 01:45:31 +0000
how to interact with spreadsheets from ACSIL
View Count: 1246
| [2018-12-19 16:18:26] |
| User145885 - Posts: 15 |
|
Hi. I am trying to work with a simple example on how to interact with spreadsheets using acsil code and I get the warning that I posted at the bottom. Is there anything I can do about it? have the function changed? thanks in advance. SCSFExport scsf_SpreadsheetInteractionExample(SCStudyInterfaceRef sc) { SCSubgraphRef FormulaResultSubgraph = sc.Subgraph[0]; if (sc.SetDefaults) { // Set the configuration and defaults sc.GraphName = "Spreadsheet Interaction Example"; sc.StudyDescription = "This is an example study for demonstrating how to interact with spreadsheets from ACSIL. "; sc.AutoLoop = 1; FormulaResultSubgraph.Name = "Formula Result"; FormulaResultSubgraph.DrawZeros = true; return; } const char* SheetCollectionName = "ACSILInteractionExample"; const char* SheetName = "Sheet1"; const n_ACSIL::s_SpreadsheetSheetHandle SheetHandle = sc.GetSpreadsheetSheetHandleByName(SheetCollectionName, SheetName); Warning: This Custom DLL study may cause Sierra Chart to be unstable until you remove the study from your chart and restart Sierra Chart. | 2018-12-19 09:02:17 * |
| [2018-12-19 16:28:43] |
| |
|
You are running an out of date version of Sierra Chart. You must update to the current version which is 1852.
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, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2018-12-19 23:04:29] |
| User145885 - Posts: 15 |
|
Thanks for your response but I downloaded the last version 1852 and I am still receiving the same warning Warning: The Custom DLL study "PROBANDOCODIGOCRUCEDEMOVINGAVERAGES_64.scsf_SpreadsheetInteractionExample" has just caused a CPU exception. | 2018-12-19 17:53:24 * Warning: This Custom DLL study may cause Sierra Chart to be unstable until you remove the study from your chart and restart Sierra Chart. | 2018-12-19 17:53:24 * 1847 Release Date: 2018-11-25 On this link bellow you have mentioned that you have made some changes to : Changed the ACSIL function sc.GetSpreadsheetSheetHandleByName to include the new parameter: CreateSheetIfNotExist. If you are using this function in an ACSIL study, it is mandatory that you rebuild the custom study when using this version or higher, otherwise there will be unstable behavior. What do you mean "it is mandatory that you rebuild the custom study" https://www.sierrachart.com/index.php?page=doc/Whats_New.php Thanks in advance |
| [2018-12-20 04:28:07] |
| |
|
Make sure you are building the custom study using the Remote Build command in Analysis >> Build Custom Studies DLL.
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, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2018-12-20 04:28:26
|
| [2018-12-20 15:45:00] |
| User145885 - Posts: 15 |
|
Thanks a lot. It is working.Happy holidays .
|
To post a message in this thread, you need to log in with your Sierra Chart account: