Support Board
Date/Time: Wed, 23 Apr 2025 01:53:19 +0000
Post From: Opening 30min range for every month
| [2022-06-22 23:14:06] |
| User843179 - Posts: 7 |
|
Hi John, Thanks for your response. This is my first time using spreadsheet studies, so I may have a few questions to run through how precisely to achieve what you described. 1. When you say 'find the first day of the month' - do you mean I would manually find the first day of the month, or is there some lookup function to use? After I find it, what should I do with it? eg enter that row / range into the "EARLIESTNONZEROVALUE()" formula? 2. My understanding is the EARLIESTNONZEROVALUE formula will capture the last nonzerovalue within a specified spreadsheet range. If I manually identify the date for first trading day of the month, and specify the 9.30-10.00am row of that day as the range for EARLIESTNONZEROVALUE formula, what to do next? eg will the formula collect the high and low data from that row for me? If it does collect the H-L data, how to transform that into a graphical output on the chart? Thankyou, I am looking forward to hear from you. |