How can I write all month's last dates for a given period of time?

3 次查看(过去 30 天)
Hello guys. Well I have daily time series form 1990-2015
% code
b=726867;
a=9125;
for i=1:a
b=b+1;
BigMatrix(i,1)=b;
end
BigMatrix=cellstr(datestr(BigMatrix));
Now I want to make another variable where I have only last date of months for a same period of time.
Thanks in advance

采纳的回答

Titus Edelhofer
Titus Edelhofer 2015-1-28
Hi,
first of all: you don't need the loop
BigMatrix = b + (1:a);
BigMatrixStr = cellstr(datestr(BigMatrix));
For the last day of a month you have different possibilities. One is to use datevec and note, that the last day of a month is one day before the first of the next month:
% add one day and convert to date vectors:
BigMatrixVec = datevec(BigMatrix+1);
% remove all that are not the first of a month
BigMatrixVec(BigMatrixVec(:,3)~=1, :) = [];
% and subtract that one day again:
BigMatrixStrLast = cellstr(datestr(datenum(BigMatrixVec)-1));
Or use the datetime object that comes with R2014b:
dt = datetime(BigMatrix, 'ConvertFrom', 'datenum');
t = unique(dateshift(dt, 'end', 'month'));
% remove the last month if it's past the last dt
t(t>dt(end)) = [];
Titus

更多回答(2 个)

Sean de Wolski
Sean de Wolski 2015-1-28

You could use lbusdate to get the last business day of the month specifying no weekend days:

weekend = zeros(1,7); % that's depressing :)
web(fullfile(docroot, 'finance/lbusdate.html'))

Andrei Bobrov
Andrei Bobrov 2015-1-28
BigMatrix = cellstr(datestr(b+(1:a)'));

类别

Help CenterFile Exchange 中查找有关 Dates and Time 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by