Support Board
Date/Time: Wed, 05 Feb 2025 09:46:21 +0000
[User Discussion] - Spreadsheet Rolling Pivot - Session End Time
View Count: 2675
| [2014-12-02 15:24:12] |
| Sawtooth - Posts: 4167 |
|
-Set the Formula Source Sheet Number to the same as the chart number where each spreadsheet study is applied, then copy/paste the entire Sheet1 to that respective sheet number. -Set the Chart Data Output Sheet Number to 0 on all of the spreadsheet studies. |
| [2014-12-02 16:13:28] |
| OneMoreTick - Posts: 79 |
|
Same result. Would you be able to attach a chartbook with a working version using the session close/open formula?
Date Time Of Last Edit: 2014-12-02 16:17:38
|
| [2014-12-02 20:16:23] |
| Sawtooth - Posts: 4167 |
|
Here you go... Edit: new files attached with corrected K3 formula Date Time Of Last Edit: 2014-12-02 22:56:27
|
Attachment Deleted. Attachment Deleted. Attachment Deleted. Attachment Deleted. Attachment Deleted. Attachment Deleted. Attachment Deleted.  Dilernia nPeriod Rolling Pivots.cht - Attached On 2014-12-02 22:55:31 UTC - Size: 29.09 KB - 513 views Dilernia nPeriod Rolling Pivots.scwbf - Attached On 2014-12-02 22:55:51 UTC - Size: 90.84 KB - 457 views Attachment Deleted. Attachment Deleted. Attachment Deleted. Attachment Deleted. Attachment Deleted. Attachment Deleted. Attachment Deleted. |
| [2014-12-02 21:21:19] |
| OneMoreTick - Posts: 79 |
|
I finally see the issue. It doesn't work on a daily intraday chart, only smaller intraday charts.
|
| [2014-12-02 23:03:17] |
| Sawtooth - Posts: 4167 |
|
Have you ever considered being a Beta tester? :) OK, I think the K3 formula will now handle any chart type, any session times, including an Intraday 1-0-0 chart that doesn't start at midnight. Post #27 has the updated files. Here's the new K3 formula, if you don't want to download the files: =IF(OR(AND($J$75>0,MROUND(A3-INT(A3),1/86400)=MROUND($J$75,1/86400)),AND($J$75=0,INT(A3)>INT(A4))),K4+1,K4) |
| [2014-12-03 02:18:07] |
| OneMoreTick - Posts: 79 |
|
I have been a beta tester :-) Well that seems to have done it, nice work. I have to set the displacement to 12 and that gets the shift to where I want it at the session close time. Not a big deal. There's just one thing about Mondays. For some reason the pivots shift 3 hrs before the session close on Mondays and then again at the session close. Look at the last 2 Mondays on this chart, I've marked the session close with a vertical line. It doesn't really create a problem since the end of session shift is correct, just curious. http://www.sierrachart.com/image.php?l=1417572627432.png |
| [2014-12-03 03:36:45] |
| Sawtooth - Posts: 4167 |
|
I'd need to have your chartbook to answer that. Too many settings and possible configs.
|
| [2014-12-03 04:46:35] |
| OneMoreTick - Posts: 79 |
|
Here you go.
|
| Dilernia v2.cht - Attached On 2014-12-03 04:44:56 UTC - Size: 67.47 KB - 455 views Dilernia v2.scwbf - Attached On 2014-12-03 04:45:03 UTC - Size: 90.84 KB - 500 views |
| [2014-12-03 14:25:39] |
| Sawtooth - Posts: 4167 |
|
I'm not able to isolate the problem. It seems to be an anomaly of the Study/Price Overlay study. The daily values are correct in the source chart, but don't overlay on the destination chart as expected after a weekend. Since the source chart is accurate, I don't know what else can be done.
Date Time Of Last Edit: 2014-12-03 14:25:52
|
| [2014-12-03 14:27:08] |
| OneMoreTick - Posts: 79 |
|
Ok, thanks for checking it out.
|
To post a message in this thread, you need to log in with your Sierra Chart account: