Support Board
Date/Time: Wed, 10 Sep 2025 13:34:39 +0000
Post From: SC Quits when Paste Large Formula into Spreadsheet Window
| [2016-04-06 17:54:29] |
| User791263 - Posts: 151 |
|
UPDATED (this was added to top of prior Post- where I erroneously had"disregard") I know you can't get bogged down in complex trading systems,so maybe just ask around if anyone has seen this behavior, and suggest tests or direction to debug. I though it might be an INFINTE/Indeterminate Value. It is not. It's strange. I'll need more incremental tests' results (added small terms) to advise. Perhaps a circular reference, such as K3 referring to NOT L3 true, and vise versa. When I just added: L3=0 caused K to shut down SC. I did a few tests, little at a time, only a couple of small terms cause it. - - - - - - - - - -BEGIN NEW text in Post: One other term, FD3>FD4, in a middle area, did. The problem seems NOT to do with characters limit (though these are big 2200 ch. forumlas). - - - more info- providing formula: I'd prefer not to make public my entire BUY Signals, even if dependent on many studies, etc.. (I could send privately most of it & provide detail of other column reference that did it. Adding L3=0 anywhere in the top 2 lines, it quits. I'll try it elsewhere. My settings are for intrabar signals in short time frame, so I often have negating exits concurrently or just prior. (I do not yet lock state-- had trouble doing that). Here are the beginning few lines. =AND(K4=0,(P3-P6)<320,OR(GI3>(GK3+.8), GO3>(GO4+.2),GK3>GO3), GC3>-520,NOT(AND(GK3>(GK4- .4),GK3> -6,GE3<(GC3+11),GE3<160,GC3<160,(OR(P3<230,AND(P3>229,P3>P4,V3>190))),(E3- E20)<3.5,(E3-E12)<2 )), ... etc. I'm thinking circular dependencies. I've run prior and after compares to make sure those are the only terms changed (using WORD Review>> Compare. I keep audit steps in NOTEPAD of each rev., & have frequent full Backups. This is not a "finger bounce" error. I'll work on this off and on for the next day to see if any new clues show up, before you spend time on it. |