Login Page - Create Account

Support Board


Date/Time: Sun, 15 Dec 2019 15:17:44 +0000



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

[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: 79194
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2013-12-03 21:50:42

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

Login

Login Page - Create Account