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
Frequent 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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies