Login Page - Create Account

Support Board


Date/Time: Tue, 30 Apr 2024 14:15:27 +0000



Autotrading formula question

View Count: 674

[2016-01-11 15:27:56]
User517837 - Posts: 2
Hello-
I am using a crossover formula (crossfromabove, crossfrombelow) for trade entry and exit.
When I enter these formulas in the Spreadsheet for Trading spreadsheet, a FALSE value is returned for columns K,L,M,N. These formulas function normally in the Color Bar Based on Alert Condition.
Example: =crossfromabove(id12.sg1@3, id14.sg1@3)
I have tried omitting the "@3" function, to no avail. By creating a formula with "greater than (>), less than (<), autotrading functions...I would prefer using the crossfromabove/below function though.
Thanks for your help.
[2016-01-12 00:08:15]
Sierra Chart Engineering - Posts: 104368
We are looking into this now:
=crossfromabove(id12.sg1@3, id14.sg1@3)

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
[2016-01-12 00:39:22]
Sierra Chart Engineering - Posts: 104368
The problem is you did not specify a range of 2 cells for each parameter. There is only a single cell for each parameter as you have it now.

Refer to the "Spreadsheet Functions" documentation for an example.
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