How to extract data from fints using time and NOT dates
2 views (last 30 days)
Show older comments
Adhish Aggarwal
on 1 Mar 2018
Commented: Walter Roberson
on 1 Mar 2018
I have stock price intra minute data from 09:15 AM to 3:30 PM for last 5 years with dates in fints format. I want to extract data from 09:45 AM to 3:30 PM for all the dates. How can I do it?
0 Comments
Accepted Answer
Walter Roberson
on 1 Mar 2018
datevec() and look at the 4th and 5th columns of the results to decide which are in the desired range.
2 Comments
Walter Roberson
on 1 Mar 2018
Suppose your fints obj is named FT. Then
DV = datevec(FT.dates);
mask = (DV(:,4) == 9 & DV(:,5) >= 15) | (DV(:,4) >= 10 & DV(:,4) <= 14) | (DV(:,4) == 15 && DV(:,5) <= 30);
extracted_FT = FT(mask);
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!