Support Board

Date/Time: Wed, 15 May 2024 03:22:01 +0000

Post From: Spreadsheet

[2015-01-24 17:17:59] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3996
To see exit arrows when you are flat, you need a different formula in L3 that does not reference J8 or J9. There really is no accurate solution to this because the spreadsheet does not retain the Position Average Price in the array. If you are both entering and exiting at close of bar, there is a possible workaround, but it would require that the exit formula calculate an assumed exit price based on the closed price of the entry signal bar. And this would only work if you do not scale-in/scale-out. And it would not be accurate if there was any slippage at entry or exit.