Login Page - Create Account

Support Board


Date/Time: Sat, 27 Apr 2024 02:33:45 +0000



spreadsheet systems-can they do the below without ACSIL?

View Count: 1089

[2018-11-05 00:09:24]
User525733 - Posts: 126
Hi,

Can the spreadsheets do the following:

1- store the price chart bar's index/time stamp where a given study generated a specific signal...for e.g store the index where a pair of MA's crossed? I want to use this stored index/time value to compare it against another stored index captured from another study subgraph so i can implement more advanced trading logic.

2- create user defined variables to serve as logic flags or intermediate calculation data storage.

thanks
[2018-11-05 07:38:18]
Sawtooth - Posts: 3976
1- Yes, and this done in a Formula Column on a spreadsheet study's sheet where the persistent variable is repeated so that it appears in row 3.
Here are some examples of persistent variables on a spreadsheet study's sheet:
Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables

2- Yes, if the persistent variable can be created in a Formula Column of a spreadsheet study's sheet.
[2018-11-05 17:09:53]
Sierra Chart Engineering - Posts: 104368
These programming methods are less easily and reliably accomplished with Spreadsheets. We recommend using ACSIL instead:
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, *change* to 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:

Login

Login Page - Create Account