Support Board
Date/Time: Fri, 28 Feb 2025 18:15:31 +0000
Post From: Spreadsheet back test trade entry errors
| [2021-08-20 18:30:13] |
| User681288 - Posts: 6 |
|
Hi, I have been trying to back test a spreadsheet, however, the spreadsheet has been making entries in violation of the spreadsheet rules. The logic works as intended 95% of the time but occasionally, it makes a random entry. I'm not sure where this error might be or how to get around this. I've attached a screen shot showing a long entry that is violating a number of rules. As well as other rules, I have a rule that says a Buy Entry should only be executed once the price has moved at least 4 ticks positive from bar open. I have also added a rule to delay by 1 second from bar open which I've introduced to try and flush out any data delay issues. as you can see in this screenshot, it has entered long in violation of both these rules even when slowed down to 0.01x speed. The trade is entered instantly. The logic behaves properly when there isn't a trade in the preceding bar (I start the replay just before this problem bar). Any help appreciated. http://www.sierrachart.com/image.php?Image=1629483705302.png |