Support Board
Date/Time: Fri, 29 Nov 2024 12:32:12 +0000
Alert on gap fill
View Count: 401
| [2023-02-05 13:02:31] |
| User166108 - Posts: 73 |
|
Is there a way to get an alert on a gap fill? I've got the "Extend Closes Until Future Intersection" study and attempted to use this alert formula to alert me when price crosses the line: =CROSSOVER(C,SG1[-1]) However, this doesn't seem to work as I don't get any alerts. Is there some reason it doesn't work or is there another study/formula I should be using? Thanks. |
| [2023-02-06 17:30:14] |
| John - SC Support - Posts: 36350 |
|
The "Extend Line until Future Intersection" lines are not stored within the Subgraph, so what you are trying to do with the CROSSOVER will not work. You would have to find the price level where the Gap occurs some other way. The only way we can think to do this would be to use the Spreadsheet Study and enter your test for the Gap using an IF statement that returns the price level of the gap or a 0 if there is no gap. Then you can use the MOSTRECENTNONZEROVALUE() in another column to move that price point forward so you actually have a line in a Subgraph that you can test the Close against. You will find the Spreadsheet Functions at the following link: Spreadsheet Functions For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-02-06 21:56:51] |
| User166108 - Posts: 73 |
|
That's close, but it only would handle the most recent gap. Is there a suggestion for calculating (say) a fixed number of gaps close to the current price? Alternatively, can you add a subgraph to the extend bar closes study that would have the closest (in price) unfilled gap? That would be sufficient for me and probably most people. Date Time Of Last Edit: 2023-02-06 21:57:59
|
| [2023-02-06 23:37:09] |
| John - SC Support - Posts: 36350 |
|
You should be getting the prices for the gaps all listed at the top of the column where you used the MOSTRECENTNONZEROVALUE() function. Did you enter a range of values for this function such as the following: =MOSTRECENTNONZEROVALUE(AA3:AA2000) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-02-07 00:51:58] |
| User166108 - Posts: 73 |
|
OK I have two studies on my chart: 1. Previous day's close 2. Today's open I create a column on my intraday spreadsheet which says: if previous day's close <> today's open then the value of the cell is previous day's close. I copy this down the column and sure enough, I get a list of all the gaps for the days in my sheet. For the most part, price never opens right at the close anyway, it opens above or below and may or may not fill the gap at some point. So every row generally has an entry. MOSTRECENTNONZEROVALUE will not make a difference then, since all values are non-zero. Is the source code for SierraChartStudies_64.scsf_ExtendClosesUntilFutureIntersection available anywhere? I could just modify it for my own purposes, would probably be more reliable than a messy spreadsheet. Edit: NVM, I found the source code for the function, I'll just modify that Double edit: Source code doesn't help since source code for AddLineUntilFutureIntersection is hidden :-( Date Time Of Last Edit: 2023-02-07 00:55:27
|
To post a message in this thread, you need to log in with your Sierra Chart account: