How do I create another column in a table which basically divides a T+1 / T number?

Question

Andy Simmons 2021-4-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/792887-how-do-i-create-another-column-in-a-table-which-basically-divides-a-t-1-t-number

评论： Andy Simmons 2021-4-5

I have a table (let's say X) with various colums. The first column is based on date.

I thought I could just do this;

DataVTAQ.Ret = (DataVTAQ(1,6)./(DataVTAQ(2,6)))

So I create a new column (RET), which is nothing else but the % change between 2,6 and 1,6 (a lag of t-1) basically.

How would one go about that?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KSSV 2021-4-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/792887-how-do-i-create-another-column-in-a-table-which-basically-divides-a-t-1-t-number#answer_667297

x = rand(10,1) ; 
y = rand(10,1) ; 
T = table(x,y) 
T = 10×2 table
       x          y    
    _______    ________

    0.13482     0.74789
    0.40312     0.25586
    0.31269       0.604
    0.83958     0.52914
    0.31587     0.46031
    0.79854     0.25194
    0.81289    0.082865
    0.17218     0.69191
    0.54784     0.15748
    0.21236     0.57421
T.ratio = T.y./T.x 
T = 10×3 table
       x          y         ratio 
    _______    ________    _______

    0.13482     0.74789     5.5472
    0.40312     0.25586    0.63469
    0.31269       0.604     1.9317
    0.83958     0.52914    0.63024
    0.31587     0.46031     1.4573
    0.79854     0.25194     0.3155
    0.81289    0.082865    0.10194
    0.17218     0.69191     4.0186
    0.54784     0.15748    0.28746
    0.21236     0.57421     2.7039