Login Page - Create Account

Support Board


Date/Time: Tue, 13 May 2025 02:00:41 +0000



Post From: Spreadsheet Rolling Pivot - Session End Time

[2014-12-01 01:03:23]
OneMoreTick - Posts: 79
Thanks, that fixed the pivot shift. I'm confused by the formula though. The period close references the close from two periods back and not the prior period close. For example, for the 3 month pivot for Aug through Oct, wouldn't we want to reference the close of Oct? It references the close of Sept.
Date Time Of Last Edit: 2014-12-01 01:15:46