Support Board
Date/Time: Mon, 17 Mar 2025 18:28:10 +0000
[Programming Help] - Gap Entry - Spreadsheets
View Count: 552
| [2022-09-14 19:34:27] |
| GG - Posts: 20 |
|
Hello TIA Gap Momentum System with spreadsheets. Enters a buy/sell when open is above/below the high/low of previous day. Exit is an attached order. The Problem: It isn't entering about 50% of trades it should be. I attached a screenshot example. BuyEntry: =(ID6.SG1@3-ID1.SG2@3)>0 SellEntry: =(ID1.SG3@3-ID6.SG1@3)>0 https://www.sierrachart.com/image.php?Image=1663183608992.png Thanks! |
| [2022-09-14 20:19:08] |
| User964846 - Posts: 38 |
|
Hey man - Sierra doesn't help with Coding issues. But - If I'm not totally out of my element, maybe I can help. With Spreadsheets, You might wanna just reference the Column the Study is listed in, (at the end of the spreadsheet columns). As far as I know, IDX.SGY is for color bars. Perhaps referencing the Column, like, CA3 or CA4, or CA5, would solve your issue? Well, it probably doesn't help, but in the least, you'll have an easier way to reference cells in SS. |
| [2022-09-14 21:43:47] |
| User90125 - Posts: 715 |
|
User tomglib is a master at spreadsheet usage. Seek him out if he doesn't see your message. More info on this thread: Sierra Developers/Programmers for private work |
| [2022-09-15 00:31:08] |
| Sawtooth - Posts: 4185 |
|
Gap Momentum System with spreadsheets. Enters a buy/sell when open is above/below the high/low of previous day.
I would approach it by referring to the previous bar/day, like this:BuyEntry: =AND(B3>ID1.SG2@4,INT(A3)>INT(A4)) SellEntry: =AND(B3<ID1.SG3@4,INT(A3)>INT(A4)) where ID1 is the Daily OHLC study, with Reference Days Back set to 0. This forces the signal to a single clearly defined transition. This assumes the Session times have the RTH opening bar as the first bar of the new day. Date Time Of Last Edit: 2022-09-15 00:44:26
|
| [2022-09-15 00:39:33] |
| Sawtooth - Posts: 4185 |
|
Perhaps referencing the Column, like, CA3 or CA4, or CA5... you'll have an easier way to reference cells in SS.
It might seem easier but all of your references will be wrong if you:- Add, Remove, or Rearrange studies in the Studies to Graph list. - Insert/Delete Formula Columns. - Change the Number of Formula Columns setting. The preferred method here... Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study ...avoids the above issues. Date Time Of Last Edit: 2022-09-15 00:56:40
|
To post a message in this thread, you need to log in with your Sierra Chart account: