Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 19 May 2024 11:05:09 +0000
Does This Exist? only include signal if it is near a round number within 10-20 pips of
View Count: 424
| [2021-06-14 20:00:17] |
| Chadly - Posts: 65 |
|
I wanted to filter those signals that only occurred in an area close to major whole/round numbers. i.e. 1.2200 1.2100 1.2000 1.1900 (those whole numbers every 100 pips) for instance. Say I wanted to allow any signal where the high or the low of the signal candle was either 10 pips above or 10 pips below that major round number (within 10 pips either side) Any idea on how I could do that or filter that signal or even add that to existing signal recipe? |
| [2021-06-14 21:01:02] |
| John - SC Support - Posts: 31704 |
|
It really depends on where you want to get the original input information from. If it is coming from some data source within the chart, then you would probably want to use the Spreadsheet Study (or Spreadsheet Alert) in order to take advantage of the ROUND() function to be able to establish the rounded number you want. After that, it is just a matter of putting together the necessary stuff around that number to create the alert. Refer to the following for the Spreadsheet Alert Study: Spreadsheet Systems, Alerts and Automated Trading And also to the following specifically for the ROUND() spreadsheet function: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#ROUND_Function For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-06-15 17:02:10] |
| Chadly - Posts: 65 |
|
If one were not capable enough to accomplish this....are there groups or people that do this for a job? Could I pay someone to do this for me?
|
| [2021-06-15 19:55:41] |
| John - SC Support - Posts: 31704 |
|
There are. Refer to this page: List of Third Party Sierra Chart Study and System Programmers And also you asking the question may get someone's attention and they may post to offer their help. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-06-16 11:40:09] |
| Sawtooth - Posts: 4000 |
|
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.) |
To post a message in this thread, you need to log in with your Sierra Chart account: