I am trying to calculate how many times over a defined period, let's say one calendar year, does a DAY RANGE close within the OVERNIGHT RANGE.
Or, simply if I define an OVERNIGHT RANGE on an instrument let's say from 6PM EST time (GMT-5) to 6AM EST and the DAY RANGE from 6AM EST to 3PM EST:
How many times will the DAY RANGE close within the OVERNIGHT RANGE. There is probably some kind of simple Excel formula for this but I am not great at Excel or with doing math formulas. Maybe someone can point me in the right direction on how to do this. Thank you.
Comment