when i use fints, fints omits some of my data why?

i use data and date that both of them have 3700 rows. but when i use fints, fints has 3600 rows. it omits some of my data why?

Answer 1

[Steven Lord]

From the documentation for fints: "If there are duplicate dates and times, the fints constructor sorts the dates and times and chooses the first instance of the duplicate dates and times. The other duplicate dates and times are removed from the object along with their corresponding data." So I suspect you have 100 duplicate dates.

Consider storing your data in a timetable instead of a fints object as the warning at the top of that documentation page recommends. You can have duplicate time and date data in a timetable:

>> T = datetime('today');
>> v = [0; 1; 2; 0; 2; 3];
>> tt = timetable(T+v, v.^2)
>> unique(tt.Time) % only 4 unique times
>> height(tt) % 6 rows in the timetable

[pooria mazaheri]

can i use 'merge' for 'timetable'? because i needed 'fints' in order to merge my data if i use timetable 'instead' of 'fints' can i merge my data?

[Steven Lord]

See the "Resample and Aggregate Data in Timetable" topic and its sub-topics on this documentation page. I believe the retime and synchronize functions will be of interest to you.