Support Board
Date/Time: Wed, 15 Jan 2025 19:37:54 +0000
Post From: Referencing the Low on an Entry
| [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). |