MATLAB Answers

0

Two "Time" colunm in a time table

Asked by Alvaro Persichini on 18 Jun 2019
Latest activity Edited by Peter Perkins
on 19 Jun 2019
Hello I have two groups of "Dates", one is the "buy-date" and the other is the "sell-date"
I want to add this two "rowTime" to a timetable. But timetables admits just one rowTime
The following code, doesn't work.
Buy_Dates = datetime(BuyDate);
Sell_Dates = datetime(SellDate);
TT_Trades = table2timetable(T_Trades, 'RowTimes', Buy_Dates, 'RowTimes', SellDate);
Thank you.

  0 Comments

Sign in to comment.

1 Answer

Answer by Peter Perkins
on 19 Jun 2019
Edited by Peter Perkins
on 19 Jun 2019
 Accepted Answer

Correct, there is only one vector of times to label the rows of a timetable. But that's not to say you can't put both vectors in a timetable, just that only one of them can be the "row times". Just add the other one as an ordinary timetable variable, on the same footing as T_Trades.
The row times in a table are special because those are the ones used for subscripting by time. I can't say which of your two vectors is the more "fundamental" one, or which one should be the row times. Maybe neither one is more fundamental, so maybe you want a table (not a timetable) two of whose variables are datetime vectors. But I would think you'd want to make a timetable and choose one of the two as your row times.

  1 Comment

Ok. Clear. thank you!

Sign in to comment.