Support Board
Date/Time: Mon, 25 Nov 2024 19:25:35 +0000
Post From: SpreadSheet Equation Stopped Working
| [2024-02-12 16:11:55] |
| Le Dharma - Posts: 73 |
|
Hey Sierra. So I wrote a Spreadsheet to help me re-interpret Price and Delta. The spreadsheet has been recording The data perfectly for the last 2-3 weeks. Today, the equation no long works. The data columns no longer return a valid number. Between Friday and Today, Monday, I have not touched the spreadsheet or Chart. This is the equation (as far as I can tell), that has stopped working =IF(CL3<>0,0,IF(CL3=0,(E3-E4)*S4+U4,0)) This equation now returns: #DIV/0 Where CL3 is a Time Range Highlight - which does not appear to be the problem. And S4 is 2 columns before the equation above. S4 is returning a normal number. And U4 is the previous bar of the above column. I see no reason this equation would stop working today. Should I update? Was my system updated without my knowledge? Or, Could a column that pulls from the above column, cause the above column to also return #DIV/0 ??? |