Support Board
Date/Time: Wed, 05 Feb 2025 15:52:46 +0000
Post From: Spreadsheet Rolling Pivot - Session End Time
| [2014-11-19 17:41:42] |
| OneMoreTick - Posts: 79 |
|
I created a 3 day rolling pivot study in spreadsheets so that the high and low bands are based on the prior 3 day's data. However, the bands don't shift at the session end time. In the screenshot, the session end time is marked by the vertical lines. How do I make it shift at the session end time? The study in this chart is overlayed from a daily chart that has the spreadsheet study. The session times are the same on this 60min chart and the daily chart. http://www.sierrachart.com/image.php?l=1416418215508.png |