Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English version of the page.

Note: This page has been translated by MathWorks. Click here to see
To view all translated materials including this page, select Country from the country navigator on the bottom of this page.

Common Operations with Timetables for Finance

Clean data, resample and aggregate data, combine timetables and synchronize dates

Functions

expand all

ismissingFind missing values
rmmissingRemove missing entries
fillmissingFill missing values
sortrowsSort rows of matrix or table
retimeResample or aggregate data in timetable, and resolve duplicate or irregular times
retimeResample or aggregate data in timetable, and resolve duplicate or irregular times
synchronizeSynchronize timetables to common time vector, and resample or aggregate data from input timetables
horzcatConcatenate arrays horizontally
vertcatConcatenate arrays vertically
summaryPrint summary of table, timetable, or categorical array
timerangeTime range for timetable row subscripting
vartypeSubscript into table or timetable by variable type
withtolTime tolerance for timetable row subscripting
rowfunApply function to table or timetable rows
splitapplySplit data into groups and apply function
findgroupsFind groups and return group numbers

Examples and How To

Select Timetable Data by Row Time and Variable Type (MATLAB)

Subscript into a timetable with the timerange, withtol, or vartype functions.

Resample and Aggregate Data in Timetable (MATLAB)

Resample or aggregate data in a timetable to a new vector of row times.

Combine Timetables and Synchronize Their Data (MATLAB)

Combine timetables by concatenation or by synchronizing their data to a common time vector.

Clean Timetable with Missing, Duplicate, or Nonuniform Times (MATLAB)

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.

Concepts

Convert Financial Time Series Objects fints to Timetables

Convert financial time series objects to timetables

Was this topic helpful?