Standard deviation and Gaussian distributions
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This spreadsheet forms part of additional material for the following book:
2
Leveraged Trading
3
Written by Robert Carver. Website: www.systematicmoney.org/leveraged-trading
4
This sheet is copyright, Robert Carver 2019. Shared under https://www.gnu.org/licenses/gpl-3.0.en.html You may copy, modify, and share this sheet as long as this front cover is retained, and you disclose that it has been edited. This sheet comes with no warranty, is not guaranteed to be accurate, and the author is not responsible for any losses that may result from it’s use.
5
Sheet name: Standard deviation and Gaussian distributions
6
7
This sheet is linked as shareable, read only, on google docs. DO NOT ASK FOR WRITE ACCESS! Instead make your own copy to edit.
8
9
Instructions: This sheet shows how to calculate standard deviations, and the expected probability of different gains or losses if you asssume returns follow a Gaussian distribution. All values in yellow can be changed.
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...