How to calculate the return rates of the assets?

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!

Answer 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

[Peian MAO]

Hello. That's helpful. Thank you a lot.