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