Finding the OHLC for each day from 9:30-16:30 range of data

  • I have a list of data which included the date and time, and OHLC.
    First, I need to recalculate the Open High Low Close for each date from 9:30 to 16:30 only (which I put it on the column F to I for reference.)
    However, I need a way to calculate how many rows from 9:30 to 16:30 for each day in order to have the correct calculation as it's not consistently having 14 rows for each day, sometime there are only 12 rows and sometimes are 15 rows.

    Second, after having all Open High Low Close for each day, I want a table like tab Output which have a table with the OHLC for each single date.


    I have no idea about how to calculate the rows and make it happens.


    Thanks

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!