Hi,
Since R2018a, 'fints' has been replaced with 'timetable' which can be used directly as table.
Here is a sample code to get data of last 5 years using the reference date with the help of a 'timetable' object:
% Assuming that the timetable TT has properties Time, Price
% Convert your reference date to a datetime
refDate = datetime('31/08/2021', 'InputFormat', 'dd/MM/yyyy');
% Calculate the date 5 years prior to the reference date
startDate = refDate - years(5);
% Create a logical vector spanning the desired date range to index into the data
timeVector = (startDate <= TT.Time) & (TT.Time <= refDate);
recentData = TT(timeVector,:);
If you are using the Financial Time Series (fints) object in MATLAB, you can use the 'fints' object’s tsobj property to access the time series data. The tsobj property is a MATLAB timeseries object, which has a Time property that you can use to index into the time series data. Overall code remains the same, just changing the object type of input data:
% Assuming 'ft' is your fints object
ts = ft.tsobj; % Get the timeseries object
refDate = datetime('31/08/2021', 'InputFormat', 'dd/MM/yyyy');
startDate = refDate - years(5);
timeVector = (startDate <= ts.Time) & (ts.Time <= refDate);
recentData = ts.Data(timeVector);
In the code, recentData will contain the data for the most recent 5 years of the time series. Note that this code assumes that the Time property of the tsobj timeseries object is in datetime format. If its not, you may need to convert it using the 'datetime' function.
Refer to the following documentation for better understanding:
- Converting from fints to timetables: https://www.mathworks.com/help/finance/convert-from-fints-to-timetables.html
- years: https://www.mathworks.com/help/matlab/ref/duration.years.html
- datetime: https://www.mathworks.com/help/matlab/ref/datetime.html
Hope this helps!
