count the number of new listings and delistings across time

Question

Qian cao 2015-12-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/261560-count-the-number-of-new-listings-and-delistings-across-time

编辑： Walter Roberson 2015-12-29

Dear there, Happy Christmas. Could you gift me by helping me to solve my problem:) haha.

I have the following price matrix, with rows for time from date 1 to date 7 and columns for 5 assets. The values available in each column means the asset is traded on the market. For asset 1, it is listed on date 4 and is delisted on date 6. Asset 2 is listed on date 1 and not listed. Asset 3 is listed on date 1 and listed on date 4...so on...I want to know to summarize how many assets are newly listed and how many are just right delisted from the market over time.The result is expected be two vectors,one is new=[2 0 1 1 0 1 0] and the other is new delisting=[0 0 0 1 0 1 0].

Thank you very much. I am waiting online for your answers.

p2 =
     NaN     2     4   NaN   NaN
     NaN     1     1   NaN   NaN
     NaN     3     1     1   NaN
       1     4   NaN     1   NaN
       2     2   NaN     2   NaN
     NaN     1   NaN     3     2
     NaN     1   NaN     4     2

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

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2015-12-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/261560-count-the-number-of-new-listings-and-delistings-across-time#answer_204188

在 MATLAB Online 中打开

p2 =[ NaN     2     4   NaN   NaN
   NaN     1     1   NaN   NaN
   NaN     3     1     1   NaN
     1     4   NaN     1   NaN
     2     2   NaN     2   NaN
   NaN     1   NaN     3     2
   NaN     1   NaN     4     2]
ii=~isnan(p2);
new=sum([ii(1,:) ;diff(ii)]==1,2)
new_delesting=sum([ii(1,:) ;diff(ii)]==-1,2)