Support Board
Date/Time: Sun, 29 Jun 2025 07:35:59 +0000
Post From: Overlaying Pivot Points
| [2021-08-10 21:58:13] |
| Sawtooth - Posts: 4231 |
|
You are trying to filter the output before the spreadsheet gets it. You already know this doesn't work. The spreadsheet needs all of the days, and it will do the filtering. Each spreadsheet row is a chart bar, with the current bar in row 3 and earlier bars in rows below. So you will need at least enough Number of Rows to display every bar of the current day. If you eventually want to display the pivots in a previous day, and you don't want to scroll the chart into the past and use Replay, you will need enough Number of Rows to reach back to the first bar of that previous day. For now, leave it at the default 1000 rows. All formulas go in columns K-Z, and only in row 3. I only want to plot pivots for current day. You said it would automatically. How? Start with this: In these cells: Column titles: O2: S3 P2: S2 Q2: S1 R2: PP S2: R1 T2: R2 U2: R3 Formulas: K3: leave blank for now L3: leave blank for now M3: leave blank for now N3: leave blank for now O3: =ID3.SG12@3 P3: =ID3.SG4@3 Q3: =ID3.SG3@3 R3: =ID3.SG13@3 S3: =ID3.SG1@3 T3: =ID3.SG2@3 U3: =ID3.SG8@3 where ID3 is the Study/Price Overlay study. Set the Draw Styles to Ignore on SG1 to SG4. Set the Draw Styles to Dash on SG5 to SG11. Set the colors on SG4 to SG10. Confirm this will display the 7 pivot lines, in order from S3 to R3. Date Time Of Last Edit: 2021-08-10 22:46:51
|