Transfer Quarterly dates to Monthly

Question

King To Leung 2022-8-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1771735-transfer-quarterly-dates-to-monthly

评论： King To Leung 2022-8-1

Hi all,

I extracted quarterly data for eps in matlab data form (i think datevec is needed). from 31/3/1992, 30/6/1992, 30/9/1992,....31/12/2021.

Earnings per share data is only available on these dates and I need to turn it to monthly data

For example

the eps of 31/3/1992 is 1.2

the eps of 30/6/1992 is 1.3

the eps of 30/9/1992 is 1.4

the eps of 31/12/1992 is 1.5

I want to result to be like this

31/1/1992 1.2

28/2/1992 1.2

31/3/1992 1.2

30/4/1992 1.3

31/5/1992 1.3

30/6/1992 1.3

31/7/1992 1.4

31/8/1992 1.4

30/9/1992 1.4

31/10/1992 1.5

30/11/1992 1.5

31/12/1992 1.6

Thank you very much!!!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Chunru 2022-8-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1771735-transfer-quarterly-dates-to-monthly#answer_1018930

编辑：Chunru 2022-8-1

% Your data
dtstr = ["31/3/1992"
         "30/6/1992"
         "30/9/1992"
         "31/12/1992"];
x = [1.2  1.3  1.4  1.5]';
% Convert from quarter to months
dt = datetime(dtstr, 'InputFormat', 'd/M/yyyy');
dt = dt + calmonths(-2:0);
dt = dt';
dt =eomdate(dt(:));
x = repmat(x', 3, 1);
x = x(:);
%whos
T = table(dt, x)
T = 12×2 table
        dt          x 
    ___________    ___

    31-Jan-1992    1.2
    29-Feb-1992    1.2
    31-Mar-1992    1.2
    30-Apr-1992    1.3
    31-May-1992    1.3
    30-Jun-1992    1.3
    31-Jul-1992    1.4
    31-Aug-1992    1.4
    30-Sep-1992    1.4
    31-Oct-1992    1.5
    30-Nov-1992    1.5
    31-Dec-1992    1.5