How to extract data from fints using time and NOT dates
1 view (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
Categories
Find more on Calendar in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!