Support Board
Date/Time: Sun, 26 Oct 2025 06:37:07 +0000
Post From: MOSTRECENTNONZEROVALUE flickering spreadsheet automated trading
| [2025-10-21 00:58:14] |
| Lucas Muench - Posts: 17 |
|
Hello guys, I am trying to implement my stop logic for my automated system. The stop gets calculated correctly in the spreadsheet in the exact row a signal fired based on some bar input logic. In a helper column I tried using MOSTRECENTNONZEROVALUE to get the latest stop calculation. This is what I use and reference in the sell exit (buy) column. whenever a short position is opened and price is equal or higher my stop price in the column that uses MOSTRECENTNONZEROVALUE , sell exit gets value 1 and exits the trade. in replay its horrible. the column that uses MOSTRECENTNONZEROVALUE permanently toggles between the actual last value and an older value it calculated before and this kills the stop logic and just exits trades randomly (bc old value is a lower price). I dont know what to do as this seems a replay problem. Is there a workaround? Another replay mode that doesnt have this problem? (I use single chart and standard replay). Any help appreciated. |