Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Wed, 22 May 2024 00:02:06 +0000
Post From: Overlaying Pivot Points
| [2021-08-14 13:50:49] |
| Sawtooth - Posts: 4002 |
|
Maybe your innovative approach won't work because of some esoteric reliant functionality between spreadsheet sheets that is not present. Although you can reference another sheet, it is not recommended to do so when using data from other charts. Referencing Other Charts in Spreadsheet Study Formulas: Referencing Other Charts in Spreadsheet Study Formulas It is still not clear to me why you need to only display 1 day on your source chart. You have deviated from my original suggestion, which was: - to populate the source chart with many days of pivots. - overlay the pivots to the lower time frame charts using Fill Blanks With Last Value. - filter the day to display with the spreadsheet study formulas. I know you have run into some problems with this, and it is probably due: - to differences in dates between charts because of session times, or with historical charts' settlement times. - to the ln:12 and ln:13 settings in the Study/Price Overlay study. A date is a date so it's just a matter of aligning them within the limitations of Sierra Chart. I haven't chased every issue you've brought up because I'm trying to stay out of the weeds in this venue. I don't have the big picture of what you want to do, something I would require if you were to hire me to create something like this. I've helped you more than I do for most, and at some point what I offer for free crosses into what I offer for a fee. |