SOS: How to use datenum for a vector ??

12 次查看（过去 30 天）
Zoe
Zoe 2011-6-10
today = datenum('20110609','yyyymmdd');
today =
734663
D = 20110609;
d = datenum('D','yyyymmdd')
d =
734504
Why cannot the above code work ???????????????????
d1 = datenum('20110610','yyyymmdd');
d2 = datenum('20110716','yyyymmdd');
d2-d1 % it gives me 36, number of days between these two dates
HOWEVER, if I have a vector of time D(N,1), N is more than 100 K.
It looks like this: (and not sorted)
maturity =
[20110618
20110619
20110716
20110718
20110719
20111217
...];
And I wanna to get a vector of tenor, from the date in the vector to today's date: 20110610.
How may I do that? Obviously I cannot type them in...
Any experts, plz help! Thx in advance!

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-6-10
a=[20110711 20110712 20110712];
b=datenum(arrayfun(@num2str,a,'un',0),'yyyymmdd');
tenor=b-datenum('20110610','yyyymmdd')
  4 个评论
显示 2更早的评论
Fangjun Jiang
Fangjun Jiang 2011-6-10
Great. Thanks Walter.
@Zoe, follow Wlater's improvement
a=[20110711 20110712 20110712];
tenor=datenum(num2str(a'),'yyyymmdd')-datenum('20110610','yyyymmdd');
What does "tenor" mean?
Zoe
Zoe 2011-6-10
days to maturity (expiration - current)
It's a term used in derivative contract.
Thx~

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2011-6-10
datenum('D') attempts to convert the string "D" to a date. With all the various default values that are applied when fields are missing, it comes out as being Jan 1 of the current year.
datenum(D) would use the value of the variable D. However, it is not valid to pass a scalar integer to datenum() to be converted.
datenum(cellstr(num2str(maturity)),'YYMMDD') would do your entire vector.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by