Calculate running hold duration

Question

david crowley 2021-9-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1448879-calculate-running-hold-duration

回答： KSSV 2021-9-8

example.xlsx

I have a table that lists the history of stock transaction (extract attached). I require assistance to find out how long I've held each stock for?

For example, I held AAP within the 12 stocks (fixed scalar) I held on 31/12/1999 and 7/1/2000. However it was not held in the portfolio of 14/1/2000. This would mean the hold period for this stock is two weeks (2 weeks). I require this calculation to go into a separate table.

Row 1 - '31-Dec-1999' 'AAP'

Row 13 - '07-Jan-2000' 'AAP'

Can someone please assist as to how i can go about implementing this?

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

请先登录，再进行评论。

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

Answer 1

KSSV 2021-9-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1448879-calculate-running-hold-duration#answer_783059

在 MATLAB Online 中打开

% T = readtable('example.xlsx') ;
T = readtable('https://in.mathworks.com/matlabcentral/answers/uploaded_files/732154/example.xlsx');
idx = strcmp(T.(2),{'''AAP'''}) ;
T(idx,:)
ans = 2×2 table
          date             code   
    _________________    _________

    {''31-Dec-1999''}    {''AAP''}
    {''07-Jan-2000''}    {''AAP''}