How to calculate the return rates of the assets?

1 次查看（过去 30 天）
Peian MAO
Peian MAO 2021-10-3
评论： Peian MAO 2021-10-10
Excuse-me, I have three questions while dealing with a financial evaluation project using Matlab.
Given the following data, the annual time series of Total Return for each asset:
Year StocksA StocksB StocksC
2003 20.2558 262.933 101.00
2004 25.6862 268.731 106.33
2005 23.4299 284.092 108.33
.
.
.
(There are 43 rows)
Question 1. I want to know how to generate the table of return rates for the three assets (A B and C)?
Question 2. How to definite an objective function as a Handle?
Question 3. For the stocks B, how to extract the information about the years when its value is larger than 270?
Thank you and best regards!

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

回答（1 个）

Shravan Kumar Vankaramoni
Hi,
I assume that, you have data in a file and want to import to a MATLAB table. You can use "readtable" function as below
T = readtable(filename);
To filter out the table based on a condition, you can do the following:
T = (T.stocksB > 270, :)
Refer the below links to define objective funciton as a handle
https://www.mathworks.com/help/optim/ug/writing-scalar-objective-functions.html
https://www.mathworks.com/help/matlab/function-handles.html

类别

在 Help Center 和 File Exchange 中查找有关 Financial Toolbox 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by