How to calculate the return rates of the assets?

8 views (last 30 days)
Peian MAO
Peian MAO on 3 Oct 2021
Commented: Peian MAO on 10 Oct 2021
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!

Answers (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

Products


Release

R2021a

Community Treasure Hunt

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

Start Hunting!