Support Board
Date/Time: Tue, 26 Nov 2024 20:17:27 +0000
Post From: Spreadsheet formula randomly returns 0 - Why?
| [2023-10-12 05:45:59] |
| User61168 - Posts: 403 |
|
Thanks John. It is in the lowest order from all the studies it is dependent upon. Regardless, I have the "Max(5" to always return 5 if ID59 or ID60 returns a zero value. And mysteriously, if I replace the formula with =5 (a constant value), even then it returns a zero value (randomly) triggering my close-all logic. Using Max formula in the buy/sell exit alert study works perfectly fine so let's not waste our time on this. Something weird could be happening during replay and nested formulas as ID59 and ID60 are dependent on two more spreadsheet formula studies.
Date Time Of Last Edit: 2023-10-12 05:56:44
|