Home >> Support Board

Support Board

Date/Time: Thu, 16 May 2024 05:29:27 +0000

How to Post a Message for Support

help

View Count: 1311

[2014-09-08 19:15:20] #1 [Go To First Post]
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] #2 [Go To First Post]
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] #3 [Go To First Post]
julian pineda - Posts: 60
it shows invalid formula. what i am doing wrong? http://screencast.com/t/H7j8VsNmwA5P

[2014-09-09 14:56:47] #4 [Go To First Post]
Sawtooth - Posts: 3997
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] #5 [Go To First Post]
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] #6 [Go To First Post]
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] #7 [Go To First Post]
Sawtooth - Posts: 3997
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: