How can I group a timetable in hours 0-24h

2 次查看（过去 30 天）
Antonio Melieni
Antonio Melieni 2019-4-23
评论： Peter Perkins 2019-5-3
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?

请先登录，再回答此问题。

回答（1 个）

Steven Lord
Steven Lord 2019-4-23
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 个评论
Antonio Melieni
Antonio Melieni 2019-4-23
what I needed was hour = hour(timetable.Time);
Peter Perkins
Peter Perkins 2019-5-3
Antonio, I think what you needed was
TThourly = retime(TTminutely,'hourly','mean')
but perhaps that's what you meant.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Calendar 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by