Turn live data into ohlc list

  • Hello,

    After turning the problem around I still can't make a vba code that works for this task.

    So I come to you for your help!

    So I linked the excel with the simplified problem.

    So next to data1 is a data that is updated automatically.

    What I would like to do is to create at regular intervals (2 minutes) a line in ohlc format.

    And every 2 minutes a new line would be created downwards with this information

    open = first value of the 2 min

    high = max value

    low = lowest value

    close = last value of the 2 min

    And taking into consideration the fact that I can duplicate this system, do you have an idea of how I could proceed?

    thank you for taking the time to read me