Support Board
Date/Time: Wed, 15 Jan 2025 17:32:25 +0000
[Programming Help] - Referencing the Low on an Entry
View Count: 832
| [2017-08-30 16:18:53] |
| User606491 - Posts: 164 |
|
Regarding the Spreadsheet System for Trading: I would like to reference the Low of the bar at entry in my formulas. How can I do this? I've attempted to use the offset/match functionality while referencing the Last Entry Trade Date/Time ($j$42). The issue is that because the date/time list is in descending order, Match will only return the Low of the bar above/after my entry (when Match does not find an exact match). I've used the Round functionality to attempt to address this, but the issue remains: Match will return Low at the bar above/after my entry, however, not the Bar below/before my Entry. Ideally, SC will match the low of the bar on which I enter (not the bar before or after). |
| [2017-08-30 23:25:43] |
| Sawtooth - Posts: 4152 |
|
Here's another user asking the same question, and a possible solution: storing low of past candle in a spreadsheet If you are going to use the MATCH function, you can offset its match by suffixing a +1, like this: MATCH(1,K3:K1002,0)+1 |
| [2017-08-31 00:20:08] |
| User606491 - Posts: 164 |
|
Perfect. Thanks for all you do. Much appreciated.
|
To post a message in this thread, you need to log in with your Sierra Chart account: