Support Board
Date/Time: Tue, 04 Nov 2025 09:07:33 +0000
Post From: Spreadsheet Formula
| [2022-02-23 20:12:32] |
| Sawtooth - Posts: 4285 |
|
is there a way to reference the entry bar in the Spreadsheet formula study?
You could add the Trading: Position Quantity study and find the bar with a change in quantity with the Spreadsheet Formula study, then have it return a value at that bar. Like this:=IF(ID1.SG1<>ID1.SG1[-1],C,ID5.SG1[-1]) This returns the persistent Close price of the bar where the entry was made, until flat where it goes to zero. where ID1 is the Trading: Position Quantity study and ID5 is the Spreadsheet Formula study Or you could add the Trading: Position Average Price study use it's price output as the persistent entry price, until flat where it goes to zero. |