How to extract data from fints using time and NOT dates

3 Ansichten (letzte 30 Tage)
Adhish Aggarwal
Adhish Aggarwal am 1 Mär. 2018
Kommentiert: Walter Roberson am 1 Mär. 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?

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

Walter Roberson
Walter Roberson am 1 Mär. 2018
datevec() and look at the 4th and 5th columns of the results to decide which are in the desired range.
  2 Kommentare
Adhish Aggarwal
Adhish Aggarwal am 1 Mär. 2018
Could you elaborate how to do it?
Walter Roberson
Walter Roberson am 1 Mär. 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);

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Calendar finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by