Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-738933%22%20slang%3D%22en-US%22%3EFind%20the%20rate%20of%20return%20for%20each%20product%20in%20a%20large%20set%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738933%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20large%20data%20set%20of%20values%20for%20each%20product.%20There%20is%20a%20range%20of%2030%20years%2C%20and%20different%20scenarios%20for%20each%20product.%20I%20want%20to%20find%20the%20number%20of%20results%20which%20fall%20within%20a%20range%20of%20%26lt%3B5%25%2C%205-7%25%2C%207%25%20for%20each%20stock.%20Attached%20is%20an%20example.%20There%20is%2030%20years%20for%20each%20stock%2C%20within%2010%2C000%20values.%20Need%20to%20find%20the%20return%20%25%20return%20number%20for%20each%20stock%2C%20each%20year.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20assist.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-738933%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
calof1
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,

Related Conversations