Azzera filtri
Azzera filtri

How to extract data from fints using time and NOT dates

3 visualizzazioni (ultimi 30 giorni)
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?

Risposta accettata

Walter Roberson
Walter Roberson il 1 Mar 2018
datevec() and look at the 4th and 5th columns of the results to decide which are in the desired range.
  2 Commenti
Walter Roberson
Walter Roberson il 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);

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su MATLAB in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by