How can I group a timetable in hours 0-24h
6 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hi,
I have a timetable with tick data of FX rates on a minutely basis.
The timetable is 527040 x 4
Starting from the 01.01.2018 until 01.01.2019
I want to investegate the behaviour of every hour.
So i want the mean of all prices from 00-01 and so on until 23-24.
any ideas?
0 Kommentare
Antworten (1)
Steven Lord
am 23 Apr. 2019
See the "Aggregate Timetable Data and Calculate Mean Values" example on the retime documentation page. While that uses a duration array as the RowTimes for the timetable you can do the same using a timetable with datetime RowTimes as well.
2 Kommentare
Peter Perkins
am 3 Mai 2019
Antonio, I think what you needed was
TThourly = retime(TTminutely,'hourly','mean')
but perhaps that's what you meant.
Siehe auch
Kategorien
Mehr zu Data Preprocessing finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!