Support Board
Date/Time: Tue, 26 Nov 2024 20:24:41 +0000
Post From: Spreadsheet formula randomly returns 0 - Why?
| [2023-10-08 09:28:05] |
| User61168 - Posts: 403 |
|
Hi guys, I am wondering why this formula below would randomly return a value of 0? I am using this spreadsheet formula study to have a Volatility based "Daily Max Profit" value set based on the length of a custom-made channel (similar to an ATR channel), I use this study to triggers my "close all" exit alert condition to exit my open trades and stop trading for the day. =MAX(5,ID59.SG1-ID60.SG1,ID59.SG1[-1]-ID60.SG1[-1]) ID59 and ID60 are both spreadsheet formula which calculate channel High and low respectively - even if channel calculations returns a zero, the MAX() should always return a value of 5. - Even if I replace the formula with a constant value of "5", it randomly returns a value of 0 Edit: I should also mention that when I use this formula directly in my buy/sell Exit Alert condition, it works beautifully confirming there is nothing goofy going on with my study collection. Date Time Of Last Edit: 2023-10-08 09:55:22
|