Support Board
Date/Time: Mon, 25 Nov 2024 19:29:03 +0000
SpreadSheet Equation Stopped Working
View Count: 201
| [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 ??? |
| [2024-02-12 20:41:55] |
| John - SC Support - Posts: 36277 |
|
You definitely should not be getting a "#DIV/0" error, as there is no division occurring in your formula. Make sure the formula is still the same as you entered it and it did not get changed somehow by accident. It sounds like there is a slash (/) in there somewhere now that is causing an issue. Also, just for slightly faster processing, since your first IF tests if CL3 is not equal to 0, you do not need the second IF, as the second IF will always be true since it will only occur when the first one is zero. So you could change your formula to be the following: =IF(CL3<>0,0,(E3-E4)*S4+U4) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-02-13 13:55:53] |
| Le Dharma - Posts: 73 |
|
Thanks John. I know, I dont need that second IF. I think when I wrote this, I was experimenting with the final Else section. The Graph I've plotted from these numbers, was at "0" all day yesterday. today it is back to normal. Just weird. There's no slash in the column either. Maybe the problem is, I'm adding the previous bar column, U4. Maybe U4 became an error like DIV/0, somehow, and then when I added the DIV/0, it became broken. I'll check Yesterdays 6pm open, which is when the 'time range highlight' happens. If I find something I'll tell you what it was. |
To post a message in this thread, you need to log in with your Sierra Chart account: