Login Page - Create Account

Support Board


Date/Time: Sat, 27 Apr 2024 20:58:08 +0000



use excell for spreadsheet study

View Count: 532

[2020-02-12 09:15:50]
User719206 - Posts: 92
Hello , did you remove the possibility to use excell to open a simple spreadsheet study ? I can 't find it in the input ?
[2020-02-12 15:21:18]
User719206 - Posts: 92
ok ok i saw that you removed it , my problem is, I created a formula and the result is on one cell, this result change every time and i would like collect all of this result in a row. I mean that i each change of this result a fotmula ask to collect it in the cell down. I did'nt find a fonction in excell to do that, only an ABV code this is why i was interested to export my study on excell .
[2020-02-13 19:25:00]
Sierra Chart Engineering - Posts: 104368
Look at using the Advanced Custom Study Interface and Language to accomplish what you need:
Advanced Custom Study Interface and Language (ACSIL)

ACSIL is able to interact with Sierra Chart spreadsheets to set numeric and string values into cells:
sc.SetSheetCellAsDouble()

See if you can implement a solution using ACSIL and the Spreadsheet Sheet interaction from ACSIL. We would think you would be able to.

Until you develop an alternative solution continue to use an older version that has Excel support.
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: 2020-02-13 19:26:47

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account