Common Operations with Timetables for Finance
Resample and Aggregate Data
|Resample or aggregate data in timetable, and resolve duplicate or irregular times|
|Aggregate timetable data to daily periodicity|
|Aggregate timetable data to weekly periodicity|
|Aggregate timetable data to monthly periodicity|
|Aggregate timetable data to quarterly periodicity|
|Aggregate timetable data to semiannual periodicity|
|Aggregate timetable data to annual periodicity|
Combine Timetables and Synchronize Data
Access Data in Timetable
Examples and How To
Select row times from a timetable by using the
withtol functions, or by matching date or time components of the
row times. Resample or group the selected timetable data by using the
Resample or aggregate data in a timetable to a new vector of row times.
Combine timetables by concatenation or by synchronizing their data to a common time vector.
Clean timetables that have missing, duplicate, or irregular times, and produce regular timetables.
This example shows how to use timetables to visualize and calculate weekly statistics from simulated daily stock data.
Convert financial time series objects to timetables