Home >> Support Board

Support Board

Date/Time: Sat, 27 Apr 2024 21:12:10 +0000

How to Post a Message for Support

[User Discussion] - Rolling Pivot/Spreadsheet - Shift Issue

View Count: 853

[2014-12-15 01:31:22] #1 [Go To First Post]
OneMoreTick - Posts: 79
Attached is a chartbook for 3 and 5 day rolling pivots in ES which are set to shift at the session close of each day (set for 14:15pm on these charts - I'm in Pacific time). The problem is that at the end of Friday, they don't shift. The next shift after Fri always occurs Monday at 11am, so the pivots are always wrong at the end of Fri until the end of Mon.


ES Cycles.cht - Attached On 2014-12-15 01:30:50 UTC - Size: 107.19 KB - 309 views ES 3-5 DayPiv.scwbf - Attached On 2014-12-15 01:30:55 UTC - Size: 22.36 KB - 324 views

[2014-12-15 13:57:09] #2 [Go To First Post]
Sawtooth - Posts: 3980
What are your session times on each of the 3 charts?

[2014-12-15 14:24:15] #3 [Go To First Post]
OneMoreTick - Posts: 79
Start: 15:00 Close: 14:15

[2014-12-16 01:51:42] #4 [Go To First Post]
Sawtooth - Posts: 3980
Since the session times span two dates, causing the source 1-0-0 chart to have date stamps missing Friday but including Sunday, the overlaid values on the destination charts (which has Fridays and no Sundays) do not track well. If you apply my original INDEX(MATCH()) solution directly on the 0-60-0 charts, with a newer K3 formula for 0-n-0 charts, there is no problem with Mondays. And there is no need to overlay from a 1-0-0 chart. See attached for a comparison. I think the spreadsheet can be made to do what you want.


ES Cycles2.cht - Attached On 2014-12-16 01:43:52 UTC - Size: 125.88 KB - 334 views ES 3-5 DayPiv2.scwbf - Attached On 2014-12-16 01:44:38 UTC - Size: 196.57 KB - 328 views

[2014-12-16 23:23:36] #5 [Go To First Post]
OneMoreTick - Posts: 79
Fantastic, thank you!!

To post a message in this thread, you need to log in with your Sierra Chart account: