Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 28 Apr 2024 15:54:39 +0000
Post From: CROSSFROMABOVE, CROSSFROMBELOW and CROSSOVER
| [2021-11-29 18:40:47] |
| Botan626 - Posts: 294 |
|
1. Your comments in the picture say, that cells in row 13 are comparing to cells in row 12 first, not otherwise. So this from post #14 first checks the values in row 12 against the values in row 13
is wrong?2. Regardless, this The only time the 3rd value is looked at is when the 2nd values in each range are equal to each other. Then, and only then, is the comparison performed to check the 1st value with the 3rd value.
makes the whole analysis quite counterintuitive. Don't you think so?In this case http://www.sierrachart.com/image.php?Image=1635538667524.png =CROSSFROMABOVE(I12:I14, J12:J14) returns 0. In this case http://www.sierrachart.com/image.php?Image=1638209061389.png =CROSSFROMABOVE(I12:I14, J12:J14) returns 1. But it's clear, that ranges cross from above in both cases. Especially wonders this phrase For the greatest accuracy use a range which includes 3 values with this function.
here https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#CROSSFROMABOVE_Function then.It seems like, that it's better to compare ranges with 2 values only. 3. Also, if 2nd values are equal to each other and check between 2 most recent values returns FALSE, CROSSFROMBELOW will never return TRUE, if the 1st most recent value in the 1st range is lower, than the 1st most recent value in the 2nd range and vice versa. Why compare 1st and 3d values in this case for CROSSFROMBELOW then? Date Time Of Last Edit: 2021-11-29 18:50:44
|