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 (Since R2021a)
|Aggregate timetable data to weekly periodicity (Since R2021a)
|Aggregate timetable data to monthly periodicity (Since R2021a)
|Aggregate timetable data to quarterly periodicity (Since R2021a)
|Aggregate timetable data to semiannual periodicity (Since R2021a)
|Aggregate timetable data to annual periodicity (Since R2021a)
Combine Timetables and Synchronize Data
Access Data in Timetable
- Select Times in Timetable
Select row times from a timetable by using the
withtolfunctions, or by matching date or time components of the row times. Resample or group the selected timetable data by using the
- Resample and Aggregate Data in Timetable
Resample or aggregate data in a timetable to a new vector of row times.
- Combine Timetables and Synchronize Their Data
Combine timetables by concatenation or by synchronizing their data to a common time vector.
- Clean Timetable with Missing, Duplicate, or Nonuniform Times
Clean timetables that have missing, duplicate, or irregular times, and produce regular timetables.
- Use Timetables in Finance
Use timetables to visualize and calculate weekly statistics from simulated daily stock data.