Login Page - Create Account

Support Board


Date/Time: Fri, 28 Feb 2025 18:36:17 +0000



[Programming Help] - Spreadsheet back test trade entry errors

View Count: 517

[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
[2021-08-21 13:32:45]
User681288 - Posts: 6
I've created a work around on this. I have now disabled auto trading for the last 1/10th of a second of the closing bar as well as the first 1/10th of the new bar. This does, however, suggest a bug in Sierra rather than a programming issue.
Date Time Of Last Edit: 2021-08-21 13:34:36

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account