Support Board
Date/Time: Wed, 27 Nov 2024 14:33:11 +0000
help
View Count: 1362
[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: 4120 |
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: 4120 |
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: