Support Board
Date/Time: Fri, 22 Nov 2024 08:48:20 +0000
[User Discussion] - double checking alert
View Count: 2968
| [2013-05-03 19:32:45] |
| M5amhan - Posts: 468 |
|
if i wanted to reference the high going 20 ticks above a study i would write =(H+(TICKSIZE20)>ID1.SG1) correct? thank you
|
| [2013-05-03 22:40:57] |
| Sawtooth - Posts: 4118 |
|
Try this: =H+(TICKSIZE*20)>ID1.SG1 |
| [2013-05-04 00:45:55] |
| M5amhan - Posts: 468 |
|
it looks like this code takes the high and adds 20 ticks to it
|
| [2013-05-04 01:23:41] |
| Sawtooth - Posts: 4118 |
|
Yes, it goes TRUE when the High + 20 ticks is greater than the study.
Date Time Of Last Edit: 2013-05-04 03:19:04
|
| [2013-05-04 01:27:47] |
| M5amhan - Posts: 468 |
|
how can i make it true when the high is 20 ticks above the study
|
| [2013-05-04 03:22:01] |
| Sawtooth - Posts: 4118 |
|
Try this: =H>ID1.SG1+(TICKSIZE*20) |
| [2013-05-04 03:29:41] |
| M5amhan - Posts: 468 |
|
thank you that worked.. i also just thought about =H-(TICKSIZE*20)>ID1.SG1 either way, thanks for helping
|
| [2013-05-04 03:58:18] |
| Sawtooth - Posts: 4118 |
|
One way to visually test alert formulas is to put the formula in a Color Bar Based On Alert Condition study.
|
| [2013-05-04 04:02:20] |
| M5amhan - Posts: 468 |
|
that is how im using it for running a few statistical tests.. is there a way to run this through a spreadsheet and return how many days a month it comes back true? this would also help me a lot rather than manually going through years of data
|
| [2013-05-04 05:02:35] |
| M5amhan - Posts: 468 |
|
i tried this but its not working =DCOUNT(C3>HX3+($J$21*$20)) |
| [2013-05-04 05:25:12] |
| Sawtooth - Posts: 4118 |
|
I don't think you are using the correct syntax: http://office.microsoft.com/en-us/excel-help/dcount-HP005209049.aspx?CTT=5&origin=HP005204211 |
To post a message in this thread, you need to log in with your Sierra Chart account: