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 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.
- Using Timetables in Finance
This example shows how to use timetables to visualize and calculate weekly statistics from simulated daily stock data.
- Convert Financial Time Series Objects fints to Timetables
Convert financial time series objects to timetables