mmyyy date to matlab date

Hi there.

I have a column vector with dates on the following format: yyyymm

E.g. [199001, 199002, 199003 ...]'

They are all the last trading day of the month.

How can I transform them into matlab serial date numbers?

Thanks

Answer 1

[Sean de Wolski]

x = [199001, 199012, 199003]';

% Calculate year and month
mm = rem(x,100);
yyyy = (x-mm)./100;

% get last business day (Financial Toolbox Req'd)
last_bus_day = lbusdate(yyyy,mm)

Answer 2

[Azzi Abdelmalek]

d=[199001, 199002, 199003 ]
a=arrayfun(@(x) datenum(num2str(x),'yyyymm'),d)

[Azzi Abdelmalek]

V commented

Dear Azzi, Thank you for your answer. However, the code you mentioned gives me the first day of month and not the last trading day. Thanks

[Azzi Abdelmalek]

There are no days in your data, look at your question, (yyyy/mm)