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