Support Board
Date/Time: Sat, 01 Nov 2025 08:34:42 +0000
[User Discussion] - spreadsheet formula ?
View Count: 1071
| [2015-02-11 16:00:01] |
| User52239 - Posts: 13 |
|
When trying to get a crossover signal with the swing high-low indicator, I cannot seem to get it to work. Is it because many of the cells get filled with zeros when a swing high-low does not form? I try the last price =crossfrombelow(E3,AB3:AB4) where ab3 is the swing high cell. If it is an issue with the zeros in the cells, how do you overcome this ? I cant get it to work with ASCIL crossover either. thanks Shane Date Time Of Last Edit: 2015-02-11 16:38:26
|
| [2015-02-11 21:17:43] |
| Sawtooth - Posts: 4281 |
|
As you suspected, it is because of the zeros. Attached is an example of how to overcome it with a spreadsheet study. |
 Swing HL extended.cht - Attached On 2015-02-11 21:16:52 UTC - Size: 38.33 KB - 501 views Swing HL extended.scwbf - Attached On 2015-02-11 21:17:15 UTC - Size: 36.82 KB - 475 views |
| [2015-02-11 22:34:31] |
| User52239 - Posts: 13 |
|
thanks so much Tom ! Although I cannot figure out how you changed the zero settings. Or which setting you used. shane Date Time Of Last Edit: 2015-02-11 22:42:30
|
| [2015-02-11 22:52:59] |
| Sawtooth - Posts: 4281 |
|
The Swing HL study is Hidden. What you see displayed is from the spreadsheet study. Look at the Draw Styles of the spreadsheet columns M (SG3) and P (SG6). These are the only ones displayed.
|
| [2015-02-11 23:51:58] |
| User52239 - Posts: 13 |
|
Hi I see now. How can I add a formula with a trading spreadsheet to get a buy signal when price breaks a previous swing high or low ? thanks Tom shane |
| [2015-02-12 00:43:34] |
| Sawtooth - Posts: 4281 |
|
My example chartbook gives you more than you need. Just use the formulas in K3 and N3, with these for entries: =CROSSFROMBELOW(E3:E4,K3:K4) =CROSSFROMABOVE(E3:E4,N3:N4) |
To post a message in this thread, you need to log in with your Sierra Chart account: