Support Board
Date/Time: Sun, 26 Oct 2025 04:19:45 +0000
[Programming Help] - MOSTRECENTNONZEROVALUE flickering spreadsheet automated trading
View Count: 68
| [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. |
| [2025-10-21 11:32:07] |
| Lucas Muench - Posts: 17 |
|
Update: I am using the J80 and J81 column now and reference to the stop row if a trade triggered, that seems to be stable.
|
To post a message in this thread, you need to log in with your Sierra Chart account: