Support Board
Date/Time: Sun, 22 Dec 2024 08:43:51 +0000
crossing
View Count: 1441
| [2015-08-10 14:58:00] |
| User472677 - Posts: 355 |
|
in writing formulas, are there operators for 'crossing from above', 'crossing from below', slope, mod, power etc. I do see operators for +, -, etc |
| [2015-08-10 15:23:31] |
| Sawtooth - Posts: 4141 |
|
If you are writing Simple Alerts formulas, the result must be TRUE/FALSE. http://www.sierrachart.com/index.php?page=doc/doc_AlertCondAndScan.html#AlertConditionFormulaFormat Spreadsheet formula results can be T/F or values. Many of the spreadsheet functions can be used in Simple Alerts formulas. http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html#AvailableFunctions |
| [2015-08-10 17:32:47] |
| |
|
There are the CROSSFROMBELOW and CROSSFROMABOVE functions which are documented here: http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html#AvailableFunctions 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 |
| [2015-08-10 18:01:07] |
| User472677 - Posts: 355 |
|
thx. do I understand correctly that crossing operator is not available in simple alerts? is there an operator for slope other than for linear regression? Date Time Of Last Edit: 2015-08-10 18:02:44
|
| [2015-08-10 18:07:07] |
| |
|
The functions given in post #3 do work for Simple Alert formulas. We do not understand this question: is there an operator for slope other than for linear regression? There is no such thing as an operator for slope. Operators are very simple, like addition and subtraction. And we do not understand the relationship to linear regression. 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-08-10 18:07:47
|
| [2015-08-10 20:33:28] |
| User472677 - Posts: 355 |
|
1. let me make sure I understand. Are you saying that functions listed under spreadsheet will also work for simple alerts? 2.you have a slope fn for linear regression Format: SLOPE(KnownYs, KnownXs) Calculates the slope of the linear regression line through a set of x and y values. I am looking for a similar function for T3 and Time Series Forecast. 3. can you confirm that you call classical Time Series Forecast "Moving Linear Regression"? |
| [2015-08-11 17:33:08] |
| |
|
1. Some of them will. The ones that require arrays or ranges of data will not work unless you manually specify those values. 2. You are going to have to work out the details of this and construct it. You might want to start out using the Spreadsheet Study: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudy.html You can also base a study on another study and this is documented here: https://www.sierrachart.com/index.php?page=doc/doc_ChartStudies.html#BasedOn There is also the Study Angle study: https://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s231 3. For information about how this is calculated, refer to: https://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s104 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-08-11 17:33:35
|
To post a message in this thread, you need to log in with your Sierra Chart account: