Hi All,
Looking for some help in VBA.
I have a cell (D11) with real time price data.
I want to create real time bars (1 minute) with this data in excel .
So at the start of a minute, it copies the open price.
during the minute, it copies the high and low (as the price develops) and at the end of the minute it copies the price. We then move down 1 row.
I tried the FOR loop, however, this just populates every row, and doesnt do "1 row per minute". Any ideas as to how i could proceed?
Looking for some help in VBA.
I have a cell (D11) with real time price data.
I want to create real time bars (1 minute) with this data in excel .
So at the start of a minute, it copies the open price.
during the minute, it copies the high and low (as the price develops) and at the end of the minute it copies the price. We then move down 1 row.
I tried the FOR loop, however, this just populates every row, and doesnt do "1 row per minute". Any ideas as to how i could proceed?
