Login Page - Create Account

Support Board


Date/Time: Sat, 27 Apr 2024 14:36:31 +0000



Spreadsheet Buy Entry Values are cleared out when I run Trade > 'AutoTrade System Bar Based Back

View Count: 1366

[2013-12-03 06:58:01]
rickdane - Posts: 1
I'm new to Sierra Chart and very confused at this point. It seems that now whenever I run:

Trade > 'AutoTrade System Bar Based BackTest'

On my spreadsheet sheet that is associated with my chart, the column 'Buy Entry Values' is cleared out, despite the fact that I have valid functions in there that evaluate to TRUE or FALSE. I can't figure out how to get it to actually run against the functions that I use in there. An example function would be:

=AND(e4<e3,e5<e4)

Any help on what setting I am missing, etc would be much appreciated. Thanks
[2013-12-03 21:50:10]
Sierra Chart Engineering - Posts: 104368
So the formulas you have in cells K3-N3 are getting cleared when you start the back test?

This would have to do with the Formula Source Sheet Number input not being set correctly for the Spreadsheet study:
http://www.sierrachart.com/index.php?l=doc/doc_WorksheetStudyInputs.html#FormulaSourceSheetNumber

Set it to 0.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2013-12-03 21:50:42

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

Login

Login Page - Create Account