Support Board

Date/Time: Sat, 18 May 2024 00:03:10 +0000

Post From: Overlaying Pivot Points

[2021-08-13 17:58:59] Link To Thread - Link To Post [Go To First Post]
Botan626 - Posts: 294
Thank you, Tom. I finally managed to plot pivots for a specific day on the destination chart. After many tries I decided to output pivots data from source chart to spreadsheet, this way I always have a correct date for pivots I want to see on the destination chart, which helps to avoid plotting lines, if there are no bars on the destination chart with date, matching pivots date from the source chart. The problem was, that in case of 0-60-0 destination chart Study/Price Overlay study plots lines at 00:00:00 time of desired date, but in case of range bars it plot lines at the last bar of the previous day, if it exists on the chart, and if not, then it plots lines at any next date bar. I have 'Fill Blanks With Last Value' set to No. Please have a look at what I've done in the attached files. What do you think about this approach? Is it efficient? Any drawbacks? Also, I have another 2 questions: 1. Why you told me to use Dash draw style in post #17 and not Line draw style? 2. The K3 formula in post #21. =IF(INT(A3)>INT(A4),K4+1,K4) You said, that: This finds the date change and increments the previous count starting at the first date in column A. Why do we need to do that? Date Time Of Last Edit: 2021-08-13 18:04:21


02.Cht - Attached On 2021-08-13 17:58:45 UTC - Size: 13.14 KB - 156 views Pivots.scss - Attached On 2021-08-13 17:58:53 UTC - Size: 49.37 KB - 148 views