Support Board
Date/Time: Mon, 30 Jun 2025 11:21:09 +0000
Post From: Does This Exist? only include signal if it is near a round number within 10-20 pips of
| [2021-06-16 11:40:09] |
| Sawtooth - Posts: 4231 |
|
You could do it like this: Add the Spreadsheet Formula study, check Hide Study, and use a formula like this in the Formula field: =MROUND(C,0.01) This rounds the close price of each bar to the nearest whole number of every 100 ticks. Then include something like this in your alert formula: =OR(ABS(ID4.SG1-H)<=TICKSIZE*10,ABS(ID4.SG1-L)<=TICKSIZE*10) -where ID4 is the Spreadsheet Formula study. This will go TRUE when either the High or Low are within 10 ticks on both sides of the whole number. =AND(YourOtherConditions,OR(ABS(ID4.SG1-H)<=TICKSIZE*10,ABS(ID4.SG1-L)<=TICKSIZE*10)) You can also do this with a spreadsheet study. (The Spreadsheet Formula study is not a spreadsheet study, despite its name.) |