Support Board
Date/Time: Mon, 10 Mar 2025 14:17:37 +0000
[User Discussion] - Spreadsheet Help (Tom) or anyone that can help!
View Count: 476
| [2022-03-31 11:40:29] |
| Bruce - Posts: 47 |
|
I've tried to find the MAX and MIN for each hour, starting from the top of the hour across 4 different time frames, using spreadsheet functions. Any help would be appreciated
|
| [2022-03-31 12:55:16] |
| Sawtooth - Posts: 4181 |
|
Off the top, you'll need to overlay everything onto one chart, then do the calculations... Or find the max/min on each chart, then overlay those results onto one chart and find the composite max/min. Note: Overlays from other timeframes will occasionally lead/lag the source chart. See this thread for more info: MACD Study/Price overlay inaccurate for signal conditions on lower time frame chart Particularly posts #5 and #7. |
| [2022-03-31 16:08:40] |
| Bruce - Posts: 47 |
|
Hi Tom, this is what I've done so far. I've overlaid the 60, 30 and 15 min onto the 5 min chart then used M N O P columns for the 60,30,15,5 MAX(M3:P3) and the reverse for MIN!.... am I missing something else
Date Time Of Last Edit: 2022-03-31 16:39:48
|
| [2022-03-31 16:43:53] |
| Sawtooth - Posts: 4181 |
|
Except for the caveat I mentioned, you'd think that would work, but I need more details. You may Direct Message me. |
To post a message in this thread, you need to log in with your Sierra Chart account: