Hello all.
I want to use retime to convert a M15 time table to for example a H1 table.
DateTime Open High Low Close Volume ____________________ _______ _______ _______ _______ ______ 26-Aug-2019 00:00:00 0.89545 0.89638 0.89529 0.89638 199 26-Aug-2019 00:15:00 0.89638 0.89641 0.89589 0.896 187 26-Aug-2019 00:30:00 0.8962 0.89632 0.89574 0.89603 139 26-Aug-2019 00:45:00 0.89569 0.89594 0.89542 0.89546 157
In this case, I should get the followings:
Open = open@26-Aug-2019 00:00:00
Close = close@26-Aug-2019 00:45:00
High = (max(High))
Low = (min(Low))
resulting the below table.
DateTime Open High Low Close Volume ____________________ _______ _______ _______ _______ ______ 26-Aug-2019 01:00:00 0.89545 0.89641 0.89529 0.89546 682
However whatever method I used within the retime function, it won't return what I described above.
Any solution to this?!
Best Answer