Login Page - Create Account

Support Board


Date/Time: Sun, 19 May 2024 02:02:14 +0000



how to interact with spreadsheets from ACSIL

View Count: 1173

[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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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:

Login

Login Page - Create Account