How to insert zeros in a data returns

5 次查看（过去 30 天）
Lbuni
Lbuni 2019-6-5
编辑： Adam Danz 2019-6-5
I have a data with two variables: dates and returns. These two variables don't include the festivities, i'd like to insert zeros in the returns in those days. Is there anyone who can help me?
  12 个评论
显示 10更早的评论
Lbuni
Lbuni 2019-6-5
It works! I really appreciated your help, good job.

请先登录，再进行评论。

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

采纳的回答

Adam Danz
Adam Danz 2019-6-5
编辑：Adam Danz 2019-6-5
For r2016b or later
Assuming your dates are a cell array of strings in the format you described in the comments under your question, you can put your data into a timetable, then use retime() to fill in the missing dates.
Dates = {'2013-11-01', '2013-11-02', '2013-11-05', '2013-11-06'};
Returns = [1.05, 1.03, 1.05, 1.03];
% Convert dates to datetime
t = datetime(Dates,'InputFormat','yyyy-MM-dd');
% put dates and data into timetable
tt = timetable(t',Returns','VariableName',{'Returns'});
% expand your time table to include all missing days; fill missing Returns with 0
ttFill = retime(tt,'daily','fillwithconstant','Constant',0);
% Extract the vector (if you must)
Finalreturnmatrix = ttFill.Returns;
Results
ttFill =
6×1 timetable
Time Returns
___________ _______
01-Nov-2013 1.05
02-Nov-2013 1.03
03-Nov-2013 0
04-Nov-2013 0
05-Nov-2013 1.05
06-Nov-2013 1.03
>> Finalreturnmatrix
Finalreturnmatrix =
1.05
1.03
0
0
1.05
1.03
Lower level version (for earlier releases)
'allReturns' is the vector you're looking for. This approach doesn't rely on datetime, timetables, etc.
Dates = {'2013-11-01', '2013-11-02', '2013-11-05', '2013-11-06'};
Returns = [1.05, 1.03, 1.05, 1.03];
alldates = datestr(datenum(Dates{1},'yyyy-mm-dd') : 1 : datenum(Dates{end},'yyyy-mm-dd'),'yyyy-mm-dd');
allReturns = zeros(size(alldates,1),1);
allReturns(ismember(alldates,Dates)) = Returns;

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Time Series Objects 的更多信息

标签

产品


版本

R2014b

Community Treasure Hunt

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

Start Hunting!

Translated by