Support Board
Date/Time: Fri, 29 Nov 2024 12:37:34 +0000
Post From: What is causing these spreadsheet recalculations
| [2023-02-12 02:07:31] |
| j4ytr4der_ - Posts: 938 |
|
I've been working on some automation for weeks, I will get it working fine, then suddenly, for no reason I can see, it will just stop working. Literally from one minute to the next, it will go from running fine in replay, giving signals, entering/managing trades, etc. Then on a subsequent replay it won't fire anything at all due to being in a full recalculation state. I've read the documentation and nothing mentioned there seems to apply to what I'm doing. I have no chart referencing any other chart, and in fact I have only two charts in this chartbook, clones of each other but one for long trades and one for short, due to spreadsheets not having separate tracking of long entry/exit prices, and short prices. The charts are running a 1439 minute footprint. My spreadsheet has only 2 rows, the minimum 16 columns. Nothing happens based on past bars, everything is based on activity in the order flow right now. All things considered it's a relatively simple sheet. I've run in safe mode, no change. I've removed every single study except the Spreadsheet System (all standard built-in studies), no change. I can even save all my studies as study collections (one longs, one shorts), and apply them to brand new charts in a new chartbook, and everything will work fine again. It's like there's some spontaneous corruption in the chartbook that keeps happening, I can't make any sense of it. Anyone have any idea what could keep causing this? Date Time Of Last Edit: 2023-02-13 02:28:49
|