Spreadsheet: 102548d1300468473-creating-a-list-of-random-s-with-bounds-stock-px
Sheet: Sheet1

 |  | Stock [NAME] | Future Stock Px = $18
 | 2009-07-15 00:00:00 | 11.39
 | 2009-07-16 00:00:00 | 12.15
 | 2009-07-17 00:00:00 | 12.03
 | 2009-07-20 00:00:00 | 12.51
 | 2009-07-21 00:00:00 | 12.18
 | 2009-07-22 00:00:00 | 12.2
 | 2009-07-23 00:00:00 | 13.01
 | 2009-07-24 00:00:00 | 12.98
 | 2009-07-27 00:00:00 | 12.96
 | 2009-07-28 00:00:00 | 13.04
 | 2009-07-29 00:00:00 | 12.72
 | 2009-07-30 00:00:00 | 13.48
 | 2009-07-31 00:00:00 | 13.66
 | 2009-08-03 00:00:00 | 14.03
 | 2009-08-04 00:00:00 | 14.46
 | 2009-08-05 00:00:00 | 14.46
 | 2009-08-06 00:00:00 | 14.07
 | 2009-08-07 00:00:00 | 14.4
 | 2009-08-10 00:00:00 | 13.95
 | 2009-08-11 00:00:00 | 13.53
 | 2009-08-12 00:00:00 | 14.33
 | 2009-08-13 00:00:00 | 14.35
 | 2009-08-14 00:00:00 | 13.88
 | 2009-08-17 00:00:00 | 13.06
 | 2009-08-18 00:00:00 | 13.08
 | 2009-08-19 00:00:00 | 13.08
 | 2009-08-20 00:00:00 | 13.34
 | 2009-08-21 00:00:00 | 13.69
 | 2009-08-24 00:00:00 | 13.46
 | 2009-08-25 00:00:00 | 13.28
 | 2009-08-26 00:00:00 | 13.11
 | 2009-08-27 00:00:00 | 12.8
 | 2009-08-28 00:00:00 | 12.87
 | 2009-08-31 00:00:00 | 12.72
 | 2009-09-01 00:00:00 | 11.93
 | 2009-09-02 00:00:00 | 12.14
 | 2009-09-03 00:00:00 | 12.39
 | 2009-09-04 00:00:00 | 12.44
 | 2009-09-08 00:00:00 | 12.8
 | 2009-09-09 00:00:00 | 13.1
 | 2009-09-10 00:00:00 | 13.42
 | 2009-09-11 00:00:00 | 13.63
 | 2009-09-14 00:00:00 | 13.55
 | 2009-09-15 00:00:00 | 13.75
 | 2009-09-16 00:00:00 | 14.58
 | 2009-09-17 00:00:00 | 14.22
 | 2009-09-18 00:00:00 | 14.47
 | 2009-09-21 00:00:00 | 14.27
 | 2009-09-22 00:00:00 | 14.9
 | 2009-09-23 00:00:00 | 14.48
 | 2009-09-24 00:00:00 | 13.84
 | 2009-09-25 00:00:00 | 13.66
 | 2009-09-28 00:00:00 | 14.52
 | 2009-09-29 00:00:00 | 14.28
 | 2009-09-30 00:00:00 | 14.18
 | 2009-10-01 00:00:00 | 13.43
 | 2009-10-02 00:00:00 | 13.19
 | 2009-10-05 00:00:00 | 13.96
 | 2009-10-06 00:00:00 | 13.87
 | 2009-10-07 00:00:00 | 14.26
 | 2009-10-08 00:00:00 | 14.55
 | 2009-10-09 00:00:00 | 14.52
 | 2009-10-12 00:00:00 | 14.5
 | 2009-10-13 00:00:00 | 14.33
 | 2009-10-14 00:00:00 | 15.42
 | 2009-10-15 00:00:00 | 15.59
 | 2009-10-16 00:00:00 | 15.24
 | 2009-10-19 00:00:00 | 15.82
 | 2009-10-20 00:00:00 | 15.8
 | 2009-10-21 00:00:00 | 15.75
 | 2009-10-22 00:00:00 | 14.76
 | 2009-10-23 00:00:00 | 14.83
 | 2009-10-26 00:00:00 | 14.55
 | 2009-10-27 00:00:00 | 13.93
 | 2009-10-28 00:00:00 | 12.93
 | 2009-10-29 00:00:00 | 13.7
 | 2009-10-30 00:00:00 | 13.12
 | 2009-11-02 00:00:00 | 13.01
 | 2009-11-03 00:00:00 | 13.22
 | 2009-11-04 00:00:00 | 13.07
 | 2009-11-05 00:00:00 | 13.26
 | 2009-11-06 00:00:00 | 13.32
 | 2009-11-09 00:00:00 | 13.98
 | 2009-11-10 00:00:00 | 13.77
 | 2009-11-11 00:00:00 | 14.01
 | 2009-11-12 00:00:00 | 13.61
 | 2009-11-13 00:00:00 | 13.72
 | 2009-11-16 00:00:00 | 14.01
 | 2009-11-17 00:00:00 | 14.04
 | 2009-11-18 00:00:00 | 13.8
 | 2009-11-19 00:00:00 | 13.47
 | 2009-11-20 00:00:00 | 13.21
 | 2009-11-23 00:00:00 | 13.35
 | 2009-11-24 00:00:00 | 13.27
 | 2009-11-25 00:00:00 | 13.27
 | 2009-11-27 00:00:00 | 12.7
 | 2009-11-30 00:00:00 | 13.09
 | 2009-12-01 00:00:00 | 13.1
 | 2009-12-02 00:00:00 | 12.87
 | 2009-12-03 00:00:00 | 12.6
 | 2009-12-04 00:00:00 | 12.97
 | 2009-12-07 00:00:00 | 12.76
 | 2009-12-08 00:00:00 | 12.66
 | 2009-12-09 00:00:00 | 12.71
 | 2009-12-10 00:00:00 | 12.8
 | 2009-12-11 00:00:00 | 13.01
 | 2009-12-14 00:00:00 | 12.97
 | 2009-12-15 00:00:00 | 12.82
 | 2009-12-16 00:00:00 | 13.21
 | 2009-12-17 00:00:00 | 12.95
 | 2009-12-18 00:00:00 | 13.17
 | 2009-12-21 00:00:00 | 13.36
 | 2009-12-22 00:00:00 | 13.42
 | 2009-12-23 00:00:00 | 13.31
 | 2009-12-24 00:00:00 | 13.5
 | 2009-12-28 00:00:00 | 13.47
 | 2009-12-29 00:00:00 | 13.52
 | 2009-12-30 00:00:00 | 13.44
 | 2009-12-31 00:00:00 | 13.45
 | 2010-01-04 00:00:00 | 13.83
 | 2010-01-05 00:00:00 | 14.28
 | 2010-01-06 00:00:00 | 14.33
 | 2010-01-07 00:00:00 | 14.05
 | 2010-01-08 00:00:00 | 14.31
 | 2010-01-11 00:00:00 | 15
 | 2010-01-12 00:00:00 | 14.55
 | 2010-01-13 00:00:00 | 14.63
 | 2010-01-14 00:00:00 | 14.67
 | 2010-01-15 00:00:00 | 14.5
 | 2010-01-19 00:00:00 | 14.69
 | 2010-01-20 00:00:00 | 14.35
 | 2010-01-21 00:00:00 | 13.86
 | 2010-01-22 00:00:00 | 13.01
 | 2010-01-25 00:00:00 | 13.42
 | 2010-01-26 00:00:00 | 12.98
 | 2010-01-27 00:00:00 | 13.18
 | 2010-01-28 00:00:00 | 12.93
 | 2010-01-29 00:00:00 | 12.21
 | 2010-02-01 00:00:00 | 12.51
 | 2010-02-02 00:00:00 | 12.14
 | 2010-02-03 00:00:00 | 12.12
 | 2010-02-04 00:00:00 | 11.66
 | 2010-02-05 00:00:00 | 11.98
 | 2010-02-08 00:00:00 | 11.67
 | 2010-02-09 00:00:00 | 11.83
 | 2010-02-10 00:00:00 | 11.94
 | 2010-02-11 00:00:00 | 11.98
 | 2010-02-12 00:00:00 | 11.95
 | 2010-02-16 00:00:00 | 12.39
 | 2010-02-17 00:00:00 | 12.41
 | 2010-02-18 00:00:00 | 12.41
 | 2010-02-19 00:00:00 | 12.41
 | 2010-02-22 00:00:00 | 12.36
 | 2010-02-23 00:00:00 | 12.09
 | 2010-02-24 00:00:00 | 12.21
 | 2010-02-25 00:00:00 | 11.99
 | 2010-02-26 00:00:00 | 12.5
 | 2010-03-01 00:00:00 | 12.91
 | 2010-03-02 00:00:00 | 13.04
 | 2010-03-03 00:00:00 | 13.24
 | 2010-03-04 00:00:00 | 13.27
 | 2010-03-05 00:00:00 | 13.67
 | 2010-03-08 00:00:00 | 13.7
 | 2010-03-09 00:00:00 | 13.78
 | 2010-03-10 00:00:00 | 13.95
 | 2010-03-11 00:00:00 | 13.77
 | 2010-03-12 00:00:00 | 13.98
 | 2010-03-15 00:00:00 | 14
 | 2010-03-16 00:00:00 | 14
 | 2010-03-17 00:00:00 | 14.35
 | 2010-03-18 00:00:00 | 14.37
 | 2010-03-19 00:00:00 | 14.02
 | 2010-03-22 00:00:00 | 14.15
 | 2010-03-23 00:00:00 | 14.33
 | 2010-03-24 00:00:00 | 14.13
 | 2010-03-25 00:00:00 | 14.43
 | 2010-03-26 00:00:00 | 14.27
 | 2010-03-29 00:00:00 | 14.54
 | 2010-03-30 00:00:00 | 14.45
 | 2010-03-31 00:00:00 | 14.29
 | 2010-04-01 00:00:00 | 14.7
 | 2010-04-05 00:00:00 | 14.98
 | 2010-04-06 00:00:00 | 15.3
 | 2010-04-07 00:00:00 | 14.9
 | 2010-04-08 00:00:00 | 14.68
 | 2010-04-09 00:00:00 | 14.59
 | 2010-04-12 00:00:00 | 14.67
 | 2010-04-13 00:00:00 | 14.86
 | 2010-04-14 00:00:00 | 15.45
 | 2010-04-15 00:00:00 | 15.72
 | 2010-04-16 00:00:00 | 15.09
 | 2010-04-19 00:00:00 | 14.83
 | 2010-04-20 00:00:00 | 15.38
 | 2010-04-21 00:00:00 | 15.17
 | 2010-04-22 00:00:00 | 14.14
 | 2010-04-23 00:00:00 | 14.44
 | 2010-04-26 00:00:00 | 14.27
 | 2010-04-27 00:00:00 | 13.66
 | 2010-04-28 00:00:00 | 13.74
 | 2010-04-29 00:00:00 | 14.56
 | 2010-04-30 00:00:00 | 14.08
 | 2010-05-03 00:00:00 | 14.32
 | 2010-05-04 00:00:00 | 13.49
 | 2010-05-05 00:00:00 | 13.2
 | 2010-05-06 00:00:00 | 12.5
 | 2010-05-07 00:00:00 | 12.11
 | 2010-05-10 00:00:00 | 12.98
 | 2010-05-11 00:00:00 | 12.83
 | 2010-05-12 00:00:00 | 13.18
 | 2010-05-13 00:00:00 | 12.8
 | 2010-05-14 00:00:00 | 12.31
 | 2010-05-17 00:00:00 | 12.34
 | 2010-05-18 00:00:00 | 11.87
 | 2010-05-19 00:00:00 | 11.78
 | 2010-05-20 00:00:00 | 11.02
 | 2010-05-21 00:00:00 | 11.36
 | 2010-05-24 00:00:00 | 10.51
 | 2010-05-25 00:00:00 | 10.79
 | 2010-05-26 00:00:00 | 10.28
 | 2010-05-27 00:00:00 | 10.8
 | 2010-05-28 00:00:00 | 10.66
 | 2010-06-01 00:00:00 | 10.08
 | 2010-06-02 00:00:00 | 10.45
 | 2010-06-03 00:00:00 | 10.45
 | 2010-06-04 00:00:00 | 9.95
 | 2010-06-07 00:00:00 | 9.68
 | 2010-06-08 00:00:00 | 9.76
 | 2010-06-09 00:00:00 | 9.61
 | 2010-06-10 00:00:00 | 10.44
 | 2010-06-11 00:00:00 | 10.6
 | 2010-06-14 00:00:00 | 10.39
 | 2010-06-15 00:00:00 | 10.43
 | 2010-06-16 00:00:00 | 10.3
 | 2010-06-17 00:00:00 | 10.2
 | 2010-06-18 00:00:00 | 10.22
 | 2010-06-21 00:00:00 | 10.15
 | 2010-06-22 00:00:00 | 10.03
 | 2010-06-23 00:00:00 | 9.87
 | 2010-06-24 00:00:00 | 9.48
 | 2010-06-25 00:00:00 | 9.72
 | 2010-06-28 00:00:00 | 9.73
 | 2010-06-29 00:00:00 | 9
 | 2010-06-30 00:00:00 | 8.88
 | 2010-07-01 00:00:00 | 9
 | 2010-07-02 00:00:00 | 8.87
 | 2010-07-06 00:00:00 | 8.81
 | 2010-07-07 00:00:00 | 9.49
 | 2010-07-08 00:00:00 | 9.76
 | 2010-07-09 00:00:00 | 10.09
 | 2010-07-12 00:00:00 | 9.87
 | 2010-07-13 00:00:00 | 10.24
 | 2010-07-14 00:00:00 | 9.96
 | 2010-07-15 00:00:00 | 9.96
 | 2010-07-16 00:00:00 | 9.45
 | 2010-07-19 00:00:00 | 9.46
 | 2010-07-20 00:00:00 | 9.57
 | 2010-07-21 00:00:00 | 9.47
 | 2010-07-22 00:00:00 | 10.59
 | 2010-07-23 00:00:00 | 10.71
 | 2010-07-26 00:00:00 | 10.9
 | 2010-07-27 00:00:00 | 10.7
 | 2010-07-28 00:00:00 | 10.58
 | 2010-07-29 00:00:00 | 10.55
 | 2010-07-30 00:00:00 | 10.48
 | 2010-08-02 00:00:00 | 10.88
 | 2010-08-03 00:00:00 | 10.69
 | 2010-08-04 00:00:00 | 10.91
 | 2010-08-05 00:00:00 | 10.91
 | 2010-08-06 00:00:00 | 10.7
 | 2010-08-09 00:00:00 | 10.79
 | 2010-08-10 00:00:00 | 10.35
 | 2010-08-11 00:00:00 | 9.88
 | 2010-08-12 00:00:00 | 9.7
 | 2010-08-13 00:00:00 | 9.75
 | 2010-08-16 00:00:00 | 9.78
 | 2010-08-17 00:00:00 | 10.06
 | 2010-08-18 00:00:00 | 10.18
 | 2010-08-19 00:00:00 | 9.97
 | 2010-08-20 00:00:00 | 10
 | 2010-08-23 00:00:00 | 9.87
 | 2010-08-24 00:00:00 | 9.63
 | 2010-08-25 00:00:00 | 9.52
 | 2010-08-26 00:00:00 | 9.39
 | 2010-08-27 00:00:00 | 9.51
 | 2010-08-30 00:00:00 | 9.09
 | 2010-08-31 00:00:00 | 9.08
 | 2010-09-01 00:00:00 | 9.36
 | 2010-09-02 00:00:00 | 9.49
 | 2010-09-03 00:00:00 | 10.12
 | 2010-09-07 00:00:00 | 9.97
 | 2010-09-08 00:00:00 | 10.29
 | 2010-09-09 00:00:00 | 10.27
 | 2010-09-10 00:00:00 | 10.35
 | 2010-09-13 00:00:00 | 10.56
 | 2010-09-14 00:00:00 | 10.4
 | 2010-09-15 00:00:00 | 10.49
 | 2010-09-16 00:00:00 | 10.46
 | 2010-09-17 00:00:00 | 10.5
 | 2010-09-20 00:00:00 | 10.91
 | 2010-09-21 00:00:00 | 10.78
 | 2010-09-22 00:00:00 | 10.49
 | 2010-09-23 00:00:00 | 10.3
 | 2010-09-24 00:00:00 | 10.88
 | 2010-09-27 00:00:00 | 10.81
 | 2010-09-28 00:00:00 | 11.08
 | 2010-09-29 00:00:00 | 10.89
 | 2010-09-30 00:00:00 | 10.95
 | 2010-10-01 00:00:00 | 11.1
 | 2010-10-04 00:00:00 | 10.85
 | 2010-10-05 00:00:00 | 11.35
 | 2010-10-06 00:00:00 | 11.46
 | 2010-10-07 00:00:00 | 11.28
 | 2010-10-08 00:00:00 | 11.54
 | 2010-10-11 00:00:00 | 11.57
 | 2010-10-12 00:00:00 | 11.39
 | 2010-10-13 00:00:00 | 11.63
 | 2010-10-14 00:00:00 | 11.49
 | 2010-10-15 00:00:00 | 11.31
 | 2010-10-18 00:00:00 | 11.58
 | 2010-10-19 00:00:00 | 11.25
 | 2010-10-20 00:00:00 | 11.53
 | 2010-10-21 00:00:00 | 10.85
 | 2010-10-22 00:00:00 | 10.73
 | 2010-10-25 00:00:00 | 10.78
 | 2010-10-26 00:00:00 | 10.76
 | 2010-10-27 00:00:00 | 10.69
 | 2010-10-28 00:00:00 | 10.47
 | 2010-10-29 00:00:00 | 10.56
 | 2010-11-01 00:00:00 | 10.67
 | 2010-11-02 00:00:00 | 11.07
 | 2010-11-03 00:00:00 | 11.22
 | 2010-11-04 00:00:00 | 11.9
 | 2010-11-05 00:00:00 | 12.24
 | 2010-11-08 00:00:00 | 12.02
 | 2010-11-09 00:00:00 | 11.71
 | 2010-11-10 00:00:00 | 11.76
 | 2010-11-11 00:00:00 | 11.7
 | 2010-11-12 00:00:00 | 11.41
 | 2010-11-15 00:00:00 | 11.38
 | 2010-11-16 00:00:00 | 11
 | 2010-11-17 00:00:00 | 10.95
 | 2010-11-18 00:00:00 | 11.15
 | 2010-11-19 00:00:00 | 11.31
 | 2010-11-22 00:00:00 | 10.96
 | 2010-11-23 00:00:00 | 10.65
 | 2010-11-24 00:00:00 | 11.12
 | 2010-11-26 00:00:00 | 10.84
 | 2010-11-29 00:00:00 | 10.48
 | 2010-11-30 00:00:00 | 10.44
 | 2010-12-01 00:00:00 | 10.76
 | 2010-12-02 00:00:00 | 11.36
 | 2010-12-03 00:00:00 | 11.6
 | 2010-12-06 00:00:00 | 11.59
 | 2010-12-07 00:00:00 | 11.64
 | 2010-12-08 00:00:00 | 11.78
 | 2010-12-09 00:00:00 | 12.31
 | 2010-12-10 00:00:00 | 12.38
 | 2010-12-13 00:00:00 | 12.32
 | 2010-12-14 00:00:00 | 12.35
 | 2010-12-15 00:00:00 | 12.31
 | 2010-12-16 00:00:00 | 12.44
 | 2010-12-17 00:00:00 | 12.47
 | 2010-12-20 00:00:00 | 12.31
 | 2010-12-21 00:00:00 | 12.73
 | 2010-12-22 00:00:00 | 13.11
 | 2010-12-23 00:00:00 | 13.01
 | 2010-12-27 00:00:00 | 13.11
 | 2010-12-28 00:00:00 | 13.05
 | 2010-12-29 00:00:00 | 13.07
 | 2010-12-30 00:00:00 | 12.91
 | 2010-12-31 00:00:00 | 12.97
 | 2011-01-03 00:00:00 | 13.4
 | 2011-01-04 00:00:00 | 13.31
 | 2011-01-05 00:00:00 | 13.36
 | 2011-01-06 00:00:00 | 13.45
 | 2011-01-07 00:00:00 | 13.07
 | 2011-01-10 00:00:00 | 13.15
 | 2011-01-11 00:00:00 | 13.12
 | 2011-01-12 00:00:00 | 13.6
 | 2011-01-13 00:00:00 | 13.56
 | 2011-01-14 00:00:00 | 13.59
 | 2011-01-18 00:00:00 | 13.54
 | 2011-01-19 00:00:00 | 12.95
 | 2011-01-20 00:00:00 | 12.73
 | 2011-01-21 00:00:00 | 12.95
 | 2011-01-24 00:00:00 | 13.07
 | 2011-01-25 00:00:00 | 12.98
 | 2011-01-26 00:00:00 | 13
 | 2011-01-27 00:00:00 | 13.14
 | 2011-01-28 00:00:00 | 12.67
 | 2011-01-31 00:00:00 | 12.91
 | 2011-02-01 00:00:00 | 13.06
 | 2011-02-02 00:00:00 | 12.7
 | 2011-02-03 00:00:00 | 12.78
 | 2011-02-04 00:00:00 | 12.92
 | 2011-02-07 00:00:00 | 13.1
 | 2011-02-08 00:00:00 | 13.04
 | 2011-02-09 00:00:00 | 12.9
 | 2011-02-10 00:00:00 | 13.37
 | 2011-02-11 00:00:00 | 13.86
 | 2011-02-14 00:00:00 | 13.81
 | 2011-02-15 00:00:00 | 13.66
 | 2011-02-16 00:00:00 | 14.2
 | 2011-02-17 00:00:00 | 14.37
 | 2011-02-18 00:00:00 | 14.54
 | 2011-02-22 00:00:00 | 13.61
 | 2011-02-23 00:00:00 | 13.15
 | 2011-02-24 00:00:00 | 13.15
 | 2011-02-25 00:00:00 | 13.55
 | 2011-02-28 00:00:00 | 13.43
 | 2011-03-01 00:00:00 | 13.06
 | 2011-03-02 00:00:00 | 12.8
 | 2011-03-03 00:00:00 | 13.3
 | 2011-03-04 00:00:00 | 13.09
 | 2011-03-07 00:00:00 | 12.59
 | 2011-03-08 00:00:00 | 12.83
 | 2011-03-09 00:00:00 | 12.71
 | 2011-03-10 00:00:00 | 12.17
 | 2011-03-11 00:00:00 | 12.36
 | 2011-03-14 00:00:00 | 12.12
 | 2011-03-15 00:00:00 | 11.97
 | 2011-03-16 00:00:00 | 11.56
 | 2011-03-17 00:00:00 | 11.67
 | 2011-03-18 00:00:00 | 11.86
 |  |  |  |  | =mu*dt+(sigma*(dt^.5)*norminv(rand(),0,1)))
 |  |  |  | 0.2 | [NAME]expected return
 |  |  |  |  | sigma=stdev
 |  |  |  |  | dt=change in time, [for ex... monthly [NAME])]