Using Price2Ret to calculate Return

5 次查看（过去 30 天）

alpedhuez 2018-7-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/409329-using-price2ret-to-calculate-return

回答： Akshay Srivastava 2018-7-9

Sample4.xlsx

Suppose I have a data with the first column is Date and the second column is Price. I would like to calculate Returns using price2ret and put that information on the third column. Please advise.

3 个评论
显示 1更早的评论隐藏 1更早的评论

alpedhuez 2018-7-8

I have done this and would like to see the code sample because I would think it is a reasonable question that would be of interest.

dpb 2018-7-8

编辑：dpb 2018-7-8

在 MATLAB Online 中打开

Post your work...I don't have the requisite toolbox nor data to work from. Best would be a small self-contained example illustrating the problem you ran into instead of expecting volunteers to try recreate your (unknownst to us) problem scenario.

What happens with

t=readtable('sample4.xlsx');
[ret,ints]=price2ret(t.Price,t.Date);

??? Does it barf on datetime array?

请先登录，再进行评论。

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

回答（1 个）

Akshay Srivastava 2018-7-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/409329-using-price2ret-to-calculate-return#answer_328022

It will be better, if you could send the code you are working on to understand the exact need of your question and it would help in answering properly.