Home

Run monte carlo simulation simulation for stock returns. Have multiple stocks and time periods

%3CLINGO-SUB%20id%3D%22lingo-sub-727394%22%20slang%3D%22en-US%22%3ERun%20monte%20carlo%20simulation%20simulation%20for%20stock%20returns.%20Have%20multiple%20stocks%20and%20time%20periods%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-727394%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20hoping%20to%20run%20monte%20carlo%20simulations%20in%20excel.%20I%20have%20a%20large%20data%20set%20which%20involves%20numerous%20shares%2Fproducts.%20I%20am%20hoping%20to%20find%20a%20script%2C%20macro%20or%20formula%20that%20will%20find%20the%20min%2C%20median%20and%20max%20return%20for%20each%20stock.%20I%20am%20open%20to%20any%20function%2C%20macro%2C%20python%2C%20VBA%20etc%20to%20solve%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20assist.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECallum%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-727394%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%3C%2FLINGO-LABS%3E
calof1
Contributor

Hi,

 

I am hoping to run monte carlo simulations in excel. I have a large data set which involves numerous shares/products. I am hoping to find a script, macro or formula that will find the min, median and max return for each stock. I am open to any function, macro, python, VBA etc to solve this.

 

Can someone please assist.

 

Kind regards,

 

Callum