Login Page - Create Account

Support Board


Date/Time: Thu, 05 Feb 2026 13:56:32 +0000



Post From: spreadsheet recalc shortcut?

[2026-01-21 19:11:40]
Jethro Go - Posts: 31
I'm not sure. I'll explain how my spreadsheet works and maybe you can find the issue.

My Spreadsheet references:

- CVD Study
- Swing high/low (based on CVD)
- Price high/low

My Spreadsheet function:

- Converts CVD swing highs/lows to price swing highs/lows
- Draws line on swing high/low on price levels based on CVD swings
- Detects divergences of the highs/lows of both CVD and Price.

I think none of these functions are trying to change previous bars but instead are only gathering data from them. The attached files are from sawtooth's free access scss. The functions I replicated is the line plotting of the swing highs/lows which shouldn't cause any issue based on previous tests. The functions I added were the conversion of current values and divergence detector.

Edit: Each functions has its own spreadsheet so I remove each one to find the issue, but it seems like all of it has the same issue. Maybe it has to do with the conversion?
Date Time Of Last Edit: 2026-01-21 19:16:46
Private File
attachmentSwing HL extended.cht - Attached On 2026-01-21 19:04:32 UTC - Size: 4.11 KB - 8 views