Support Board
Date/Time: Fri, 28 Feb 2025 17:20:49 +0000
Post From: Overlaying Pivot Points
| [2021-08-10 01:06:22] |
| Sawtooth - Posts: 4177 |
|
Can't confirm it. 'Number Of Days To Calculate' = 2, 'Fill Blanks With Last Value' = No,
'Fill Blanks With Last Value' must always be Yes when the duration of the destination chart's bars is less than the duration of the source chart's bars.I don't know where the problem is, but it definitely should not be this way and it definitely could be improved.
Agreed, but Sierra Chart is so flexible that there is usually a workaround.Would I be able to use 1 spreadsheet for multiple charts with different symbols and timeframes?
Yes, you can use one same-named spreadsheet file on all charts. Each chart would have its own spreadsheet sheet.This assumes all charts are in the same chartbook. If each symbol uses its own chartbook, each will require an uniquely named spreadsheet file, but it can be copied to each chartbook. What if I would need to change a specific date I need just for 1 chart?
Since each chart would have its own sheet, each sheet could have its own specific date entry.The basic concept is to use columns K-Z on the spreadsheet to plot the pivot point lines from the overlay study where a formula would filter all but one date. Then the Study/Price Overlay study would be hidden, since the spreadsheet study would be doing its filtered display of the pivot point lines. I'm not going to say that this workaround won't seem complicated, but it is possible, and it puts you in control. If you want to try building this yourself, I can help you. If you want me to build it for you for a fee, contact me here: https://www.sawtoothtrade.com/contact.html |