Login Page - Create Account

Support Board


Date/Time: Tue, 22 Apr 2025 19:18:38 +0000



Post From: Count bars since event formulas

[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