Support Board
Date/Time: Sun, 24 Nov 2024 15:38:58 +0000
[User Discussion] - spreadsheet system alert horizontal line
View Count: 1286
| [2013-11-15 08:58:47] |
| plaforte - Posts: 13 |
|
Hello, to avoid having too many fibs on my charts, I am planning to use a spreadsheet system alert to get alerted when price comes within 10 pips of "calculated" fibs levels. My question is what is the simplest approach to make the formula ? APPROACH 1 Should I use CrossOver formula of the +10 and -10 pips levels ? Can the range in a CrossOver formula be a horizontal line ? APPROACH 2 Or should I just use a formula to alert when price hits the +10 or -10 pips levels ? Thank you |
| [2013-11-15 14:19:19] |
| Sawtooth - Posts: 4119 |
|
The CROSSOVER function would alert when price crossed in both directions so you won't want to use it. The range of the CROSSFROMBELOW, CROSSFROMABOVE, and CROSSOVER functions' syntax is not price, but previous bars. Approach 1 is possible but I would use Approach 2, utilizing cell J21*10 |
| [2013-11-15 15:03:31] |
| plaforte - Posts: 13 |
|
Thank you Tom, I will go with Approach 2 and input that this weekend
|
To post a message in this thread, you need to log in with your Sierra Chart account: