Login Page - Create Account

Support Board


Date/Time: Fri, 01 Nov 2024 01:29:05 +0000



help

View Count: 1352

[2014-09-08 19:15:20]
julian pineda - Posts: 60
where in SC im able to do a mathematical logic?

i need to do this: Study 1 and study 2


if study 2 is > 0 then: Study 1 + study 2

or

if study 2 is < 0 then: Study 1 - study 2
[2014-09-09 05:36:17]
Sierra Chart Engineering - Posts: 104368
The easiest way to do something like this is to use the Spreadsheet Study:
https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudy.html

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
[2014-09-09 14:34:49]
julian pineda - Posts: 60
it shows invalid formula. what i am doing wrong?


http://screencast.com/t/H7j8VsNmwA5P


[2014-09-09 14:56:47]
Sawtooth - Posts: 4103
Two things to consider:
1) Use a semicolon ; instead of a comma , for a separator.
2) Use a Formula Column (K-Z) for user calculations.


[2014-09-09 15:43:22]
julian pineda - Posts: 60
at the moment I put a semicolon de platform returns: Invalid formula. it only let me work with a comma but at the end it returns invalid formula as well.
[2014-09-09 15:56:46]
julian pineda - Posts: 60
in the other hand, everything i tried to calculated in cells K-Z cleared it self
[2014-09-09 17:13:55]
Sawtooth - Posts: 4103
The syntax of your formula looks correct.

You must enter the formula in row 3 of any column K-Z.

In the spreadsheet study settings, set the The Formula Source Sheet Number to 1 to match Sheet1, and set the Chart Data Output Sheet Number to 0.

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

Login

Login Page - Create Account