Support Board
Date/Time: Fri, 28 Feb 2025 13:40:49 +0000
Post From: Overlaying Pivot Points
| [2021-08-11 14:46:54] |
| Sawtooth - Posts: 4177 |
|
Is it ok, that column K doesn't start counting from 1 on this screenshot
It starts counting at 1 at some row. Scroll the sheet down to see where.It's not important where it starts counting because all that is needed to find the current day is a value in $K$3 that is equal to the max of column K in L3. But is it possible to make pivots not plotted at all, if destination chart doesn't have yet a bar for the current day?
Your approach would only work in real time. It would not work in Replay Chart or backtesting because TODAY() is real time today, not chart time today.If you never need to do a Replay Chart, your approach is the simplest. |