Support Board
Date/Time: Tue, 26 Nov 2024 06:28:43 +0000
[User Discussion] - Stochastic cross above 80 code
View Count: 1309
| [2014-04-05 21:59:08] |
| Litz - Posts: 131 |
|
where AE=%K AF=%D AG80 line =AND(CROSSFROMABOVE(AE3:AE5<AF3:AF5),AE3:AE4>AG3:AG4) first part is correct but value error on additional condition |
| [2014-04-07 04:21:01] |
| vegasfoster - Posts: 444 |
|
Ranges only work with crossfromabove or crossfrombelow or other excel functions that support them, e.g. sum, otherwise you must use single cell references, for example you would use A3>AG3 for %k being greater than 80 line.
|
| [2014-04-07 21:50:50] |
| Litz - Posts: 131 |
|
well this doesn't work =CROSSFROMABOVE(AE3:AE5,AF3:AF5),AND(AE3>AG3) or this =CROSSFROMABOVE(AE3:AE5,AF3:AF5),AND(AE3:AE5>AG3:AG5) same value error the cross shows fine but when I attempt to add the above 80 condition value error wouldn't bother the board but I have spent hours on this is there a source for learning the proper format for coding? |
| [2014-04-07 22:09:04] |
| vegasfoster - Posts: 444 |
|
=AND(CROSSFROMABOVE(AE3:AE5,AF3:AF5), (AE3>AG3)) http://www.sierrachart.com/index.php?l=doc/doc_WorksheetFunctions.html |
| [2014-04-07 22:43:12] |
| Litz - Posts: 131 |
|
Thanks. Was getting a bit aggravated at myself.
|
| [2014-04-08 02:34:19] |
| vegasfoster - Posts: 444 |
|
NP :) It just takes time, to keep it simple in excel you have Values, Functions, and Operators. Functions take the form of =function(parameter, parameter, etc.) and Operators include + - / * ^ & > < >= <=. You can nest a function within another function, e.g. =function(function(parameter, parameter, etc.), parameter, etc.), by replacing one of the parameters of the first function with a complete second function, but you must "connect" values and functions in single formula to each other with a valid operator, e.g. =function(parameter, parameter, etc.) operator function(parameter, parameter, etc.)
Date Time Of Last Edit: 2014-04-08 02:35:17
|
To post a message in this thread, you need to log in with your Sierra Chart account: