Monte Carlo Simulation

G

Gosor

New Member
Joined
Feb 9, 2021
Messages
8
Office Version
  1. 365
  2. 2019
Hello Community :)
I would ask , that how can i create Monte Carlo Simulation in excel?
(These are stock trades) In B-column are my results. And i want to simulate my result in antoher sequences. Maybe 10-20 result and all result on 1chart or on separat chart all results.
Can you please help me? :)
Thnaks!


10000200
10200.00204
9996.00199.92
9796.08195.9216
9600.16192.0032
9408.16188.1631
9596.32191.9264
9404.39188.0878
9216.30184.3261
9031.98180.6396
8851.34177.0268
9028.37180.5673
8974.20179.4839
9153.68183.0736
9336.75186.7351
9150.02183.0003
9333.02186.6604
9519.68190.3936
9710.07194.2014
9515.87190.3174
9706.19194.1238
9900.31198.0062
9702.31194.0461
9896.35197.927
9896.35197.927
10094.28201.8856
10296.16205.9233
10090.24201.8048
10292.05205.8409
10497.89209.9577
10707.84214.1569
10493.69209.8737
10703.56214.0712
10489.49209.7898
10699.28213.9856
10913.27218.2653
11131.53222.6306
10908.90218.178
11127.08222.5416
11349.62226.9924
11576.61231.5322
11345.08226.9016
11118.18222.3636
10895.81217.9163
10677.90213.558
10891.46217.8291
11109.29222.1857
11331.47226.6294
11558.10231.162
11326.94226.5388
11326.94226.5388
11553.48231.0695
11322.41226.4482
11548.86230.9771
11779.83235.5967
12015.43240.3086
12255.74245.1148
12500.85250.0171
12750.87255.0174
13005.89260.1177
12745.77254.9154
13000.68260.0137
13260.70265.214
12995.48259.9097
13255.39265.1079
12990.29259.8057
13250.09265.0018
13515.09270.3019
13244.79264.8958
13244.79264.8958
13496.44269.9289
13766.37275.3274
13491.04269.8209
13760.87275.2173
13444.37268.8873
13175.48263.5096
13431.08268.6217
13154.40263.088
13154.40263.088
12909.73258.1946
13167.92263.3585
12907.20258.144
12912.36258.2473
12656.70253.134
12922.49258.4498
12935.41258.7082
12966.46259.3291
13225.79264.5157
13249.59264.9918
12979.30259.586
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Sort by date Sort by votes
There is a basic simulator here.
I don't know how much it does but it might get you started
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
Is there a way to simulate data with just median and minimum amount of a dataset?
Replies
2
Views
251
Gotham
G
M
  • Question
VLOOKUP help - return value if two partial matches are met (I think??)
Replies
5
Views
293
MountainFog
M
S
  • Question
Macro: Search and then copy the result and paste into Excel
Replies
0
Views
280
Siops
S
A
  • Question
Line Chart with dates / hours
Replies
7
Views
265
awoohaw
awoohaw
M
  • Question
How can I use simulation tool in Excel for solving the following problem related to probability?
Replies
3
Views
578
Kaper
Kaper

Forum statistics

Threads
1,214,791
Messages
6,121,611
Members
449,038
Latest member
apwr

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top