Support Board
Date/Time: Sun, 29 Jun 2025 03:47:29 +0000
Post From: Overlaying Pivot Points
| [2021-08-13 20:16:59] |
| Sawtooth - Posts: 4231 |
|
What do you think about this approach? Is it efficient? Any drawbacks?
- It is an innovative approach that works for your specific need. - I don't see any inefficiencies, but you could remove the overlay study from the range chart. - The only drawback is that your solution meets a narrow need, but it leaves no room for any mods. This is moot if you never need to change. 1. Why you told me to use Dash draw style in post #17 and not Line draw style?
The Dash draw style draws an horizontal line with no connecting line, if the value were to change.Since you are only displaying a single day's pivots, there would be no connecting line, so the Line draw style would work the same in your particular case. Why do we need to do that?
You need the K3 formula to increment the day count of all the days in the spreadsheet.It doesn't matter how many days there are in the count. To find all of today's rows we compare the max count in column K with only the latest value in column K ($K$3). The current day is in every row where $K$3 equals the max count in column K. |