Support Board
Date/Time: Sat, 10 May 2025 12:56:01 +0000
ATBB Causing #REF! in New Spreadsheet on Builds 1268 & 1269
View Count: 973
| [2015-07-14 19:22:31] |
| User224651 - Posts: 28 |
|
We have been able to consistently run ATBB against a 'Spreadsheet for Trading' study using New Spreadsheets on 1261. Once we upgraded a machine to 1268 or 1269 and ran ATBB, many cells within the New Spreadsheet contained "#REF!" after the ATBB run. We tried this on 3 machines and found the same behavior. We then downgraded a machine to from either 1266 or 1269 to 1261 No CLR and ran ATBB and the #REF! did not surface in the New Spreadsheet. Any insights on how to remediate this? Date Time Of Last Edit: 2015-07-14 19:39:54
|
| [2015-07-14 19:56:48] |
| |
|
What is ATBB? Please provide us a spreadsheet file, this has a SCSS file extension, with the minimum amount of data and formulas which shows this problem and tell us what particular cell contains the #REF! error. Here are the instructions to attach a file: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile 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 |
| [2015-07-14 20:49:20] |
| User224651 - Posts: 28 |
|
We refer to 'AutoTrade Bar Based System BackTest' as 'ATBB' since the Sierra Chart toolbar references this function as 'ATBB'. In the attached New Spreadsheet if the formula logic only inputs study data, or if the formula logic only inputs price data, then no #REF! surfaces after ATBB is run. However, if the formula logic references both study data and price data, then after running ATBB there are #REF! in the new spreadsheet throughout the 'K' column. We have other examples where many columns contain #REF! but thought that it would be best to start with the most simple example per your instruction. |
Private File Private File |
| [2015-07-15 13:27:06] |
| Outlander - Posts: 91 |
|
I have the same problem with some of the symbols I use. Regards Outlander
|
| [2015-07-17 04:22:45] |
| |
|
We will be releasing version 1271 later this morning. We will like to know if it solves the problem.
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 |
| [2015-07-20 17:36:16] |
| User224651 - Posts: 28 |
|
I have just revved to 1273 and ran ATBB. No #REF! were in any cells in the New Spreadsheet after the completion of ATBB. It is our impression that this issue is now resolved. Thanks for this. |
| [2015-07-20 20:23:57] |
| |
|
Good. When you can update to 1274. We fixed a problem with the new Control Bar.
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 |
To post a message in this thread, you need to log in with your Sierra Chart account: