Support Board
Date/Time: Tue, 22 Apr 2025 18:41:28 +0000
Count bars since event formulas
View Count: 117
| [2025-01-08 16:29:12] |
| User374751 - Posts: 41 |
|
Support, I pasted the "count bars since event" formulas from the webpage of example formulas. The formulas do provide the expected info. However, the system constantly throws #value! errors for the columns of the formula inputs; the formula columns are P and Q, as provided by the example formulas. This issue seems benign. However, the issue could cause a problem at the time that the cells are referenced. What could cause this? The spreadsheet study input "reset condition on new bar" is set to "yes." Could this cause a problem with the columns where the formulas are? Date Time Of Last Edit: 2025-01-08 16:31:39
|
| [2025-01-08 17:05:01] |
| User374751 - Posts: 41 |
|
Support, I have more info. I think the issue that I have experienced with the "bars since event" formula is based on an intermittent #value! error I receive for the Buy entry or Sell entry columns. I have not determined the reason(s) for the #value! errors I receive for the entry columns; and again the #value! errors are intermittent. The #value! errors are confined to the current session. I have 3000 rows for "number of rows" input, and I do not see an an error before row 56; the next error is row 22. The errors seem to resolve as historical data is added to the spreadsheet entry columns. Any info you could provide is great. I read this info: Working with Spreadsheets: Spreadsheet Errors |
| [2025-01-08 19:22:29] |
| John - SC Support - Posts: 39420 |
|
Refer to the following to help you work through why those cells are giving you a #Value! error: Working with Spreadsheets: Viewing Formula Expression Tree For the most reliable, advanced, and zero cost futures order routing, use 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: