Support Board
Date/Time: Wed, 05 Feb 2025 15:59:40 +0000
Post From: Spreadsheet Rolling Pivot - Session End Time
| [2014-12-01 01:59:14] |
| Sawtooth - Posts: 4167 |
|
The standard pivot formula looks at the previous period's HLC, and plots the calculated values at the current period. If the period length is 3, the formulas will find the combined HLC of the 3 previous bars, and plot the values at the current bar. You can edit the formulas in S3, T3, U3 removing the -1 after the K3 in the MATCH function so that the current period and two previous periods are used in the calculation, but before you do, manually calculate the values to verify this is what you want. Date Time Of Last Edit: 2014-12-01 19:57:53
|