Find the rate of return for each product in a large set of data

Iron Contributor

Hi,

 

I have a large data set of values for each product. There is a range of 30 years, and different scenarios for each product. I want to find the number of results which fall within a range of <5%, 5-7%, 7% for each stock. Attached is an example. There is 30 years for each stock, within 10,000 values. Need to find the return % return number for each stock, each year.

 

Can someone assist.

 

Kind regards,

0 Replies