Date in a loop

Question

ARS 2012-4-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/35464-date-in-a-loop

Hi All,

I am using the following code to use a sorted file which matches elements of sorted file with financial time series table/objects of two price series. I don't know how to run a loop which changes dates as well alongwith matrix elements. The code is as follows:

for r= 2:40   
    for c=1:5
      if sorted{c,r}=='Alpha';
sortednew{c,r}= fts2mat(Apple.ARG('1-Jan-0019')) -fts2mat(Applenew.ARG('1-Jan-0019'));
elseif sorted{c,r}=='Beta';
sortednew{c,r}=fts2mat(Apple.BXD('1-Jan-0019')) - fts2mat(Applenew.BXD('1-Jan-0019'));
elseif sorted{c,r}=='theta';
sortednew{c,r}=fts2mat(Apple.ASD('1-Jan-0019')) - fts2mat(Applenew.ASD('1-Jan-0019'));
else sorted{c,r}=='gamma';
sortednew{c,r}=fts2mat(Apple.STA('1-Jan-0019')) - fts2mat(Applenew.STA('1-Jan-0019'));
        end;
   end;
 end;

I want to add a date loop after the very first loop which increments the date by 7days (weekly) and that incremented date is then used for indexing in the forthcoming statements in place of '1-Jan-0019':

 sortednew{c,r}= fts2mat(Apple.ARG('1-Jan-0019')) -     
  fts2mat(Applenew.ARG('1-Jan-0019'))

Any help will be highly appreciated

Regards,

Amd.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jan 2012-4-14

Do not use "sorted{c,r}=='Alpha'" to compare strings, because this fails if the number of characters do not match. Use STRCMP instead.

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2012-4-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/35464-date-in-a-loop#answer_44437

在 MATLAB Online 中打开

startdatevec = [19, 1, 1];  %year 19 ??, month 1, day 1
for weekno = 1 : 20
    startedate = datestr(startedatevec);
    [....]
    startedatevec(3) = startdatevec(3) + 7;
end

Don't worry about the date number becoming 36 and 43 and so on: datestr will automatically do the proper wrapping to find the right day of the right month.