Login Page - Create Account

Support Board


Date/Time: Sat, 21 Dec 2024 18:04:49 +0000



New Spreadsheeds

View Count: 835

[2015-02-26 16:29:43]
User22414 - Posts: 66
I use the formula in a sheed for the long and short signals, which deduce from the trend change of a Mov.Av-Hull. Specifically, the Mov in column AS and the formula for the field 3
in column K is: = AND (AS5> AS4; AS3> AS4).
also field 3
In colum M then analog = AND (AS5 <AS4; AS3 <AS4).

In the new Spreadsheeds this formula no longer works. How would they be?
[2015-02-26 19:00:46]
Sierra Chart Engineering - Posts: 104368
Refer to the section here about decimal point and function parameter delimiters:
https://www.sierrachart.com/index.php?page=doc/doc_StudiesSystemsAlerts.php#DecimalPointFunctionDelimiters

If you still have a problem, we need to know the specific error you see in the cell.


If the problem is not that you are getting an error, then you need to work out on your own as to what the problem is . If you find that the evaluation of a formula is not correct, let us know. But we need to have more specific information.
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: 2015-02-26 19:01:52

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

Login

Login Page - Create Account