help with my finance class

profilefai9alp
fin120_stock_excel.xlsx
Home>Business & Finance homework help>help with my finance class

Trans log

Weekly Log
Week 1 Stock trak starts
Week 2 We bought 3 stocks, we only spend a little money to try. Thay were GE, FB, MSFT.
Week 3 We are watching our stocks go up and researching new ones to buy.
Week 4 according to yahoo finicial, we decision to buy SNAP 700 stock that is first crash!
Week 5 However, after two days, SNAP Fell sharply, we loss a lot of money. We decision to buy GILD, because it is top 5 stock in a website.
Week 6 We bought 2 stocks that are INTC, QBAK and sold 2 stocks that are MSFT and SNAP.
Week 7 QBAK was falling, so we sold it, and are reseaching other stock.
Week 8 We buy the APPL, because it is stable, we found FB stock is increasing.
Week 9 We are watching our stocks go up and researching new ones to buy.
Week 10 We bought 1 stock that is TWTR, because social media is developing.
Week 11 We bought back the HD because it was going up instead of down and we wanted to cut our losses.
Week 12 Last day of stocktrak. Sold everything.

Feb 10

Week 1
Index Standings (Km)
Date Ticker Symbol Company Name Purchase Price Current Price Volume SPY QQQ Beta (Bj) Weight (Wi) T-Bill Rate
10-Feb * Nothing purchased yet
Return on Portfolio Risk on Portfolio
Weight Calculations Date Stock Ki x Wi Date Stock Bpi x Wi
Cash Balance $100,000.00
Interest Earned
Purchase Totals $ - 0 Return on Portfolio Risk on Portfolio
Risk on Portfolio
Date Stock Krf + ( Km - Krf ) * Bj
Expected Rate of Return

Feb 17

Week 2
Index Standings (Km)
Date Ticker Symbol Company Name Purchase Price Current Price Volume SPY QQQ Beta (Bj) Weight (Wi)
17-Feb GE General Electric Company 30.42 30.37 25 235.09 129.81 1.1 22.53%
17-Feb FB Facebook, Inc 133.84 133.53 10 235.09 129.81 0.49 39.43%
17-Feb MSFT Microsoft 64.52 64.62 20 235.09 129.81 1.38 38.03%
Weight Calculations Return on Portfolio Risk on Portfolio
Cash Balance $96,580.70 Date Stock Ki x Wi Date Stock Bpi x Wi
General Electric Company 770.50 17-Feb GE 0.0266 17-Feb GE 0.2479
Facebook, Inc 1348.40 17-Feb FB 0.0273 17-Feb FB 0.1932
Microsoft 1300.40 17-Feb MSFT 0.0534 17-Feb MSFT 0.5248
Purchase Totals $ 3,419.30 Return on Portfolio 0.1073 Risk on Portfolio 0.9659
Expected Rated of Return
Date Stock Krf + ( Km - Krf ) * Bj
17-Feb GE 0.1180
17-Feb FB 0.0692
17-Feb MSFT 0.1404
Expected Rate of Return 0.3276

Feb 24

Week 3 Index Standings (Km)
Date Ticker Symbol Company Name Purchase Price Current Price Volume SPY QQQ Beta (Bj) Weight (Wi)
24-Feb GE General Electric Company 30.42 30.19 25 236.74 130.26 1.1 22.53%
24-Feb FB Facebook, Inc 133.84 135.44 10 236.74 130.26 0.49 39.43%
24-Feb MSFT Microsoft 64.52 64.62 20 236.74 130.26 1.38 38.03%
Weight Calculations Return on Portfolio Risk on Portfolio
Cash Balance $96,580.70 Date Stock Ki x Wi Date Stock Bpi x Wi
General Electric Company 770.50 24-Feb GE 0.0266 24-Feb GE 0.2479
Facebook, Inc 1348.40 24-Feb FB 0.0273 24-Feb FB 0.1932
Microsoft 1300.40 24-Feb MSFT 0.0534 24-Feb MSFT 0.5248
Purchase Totals $ 3,419.30 Return on Portfolio 0.1073 Risk on Portfolio 0.9659
Expected Rated of Return
Date Stock Krf + ( Km - Krf ) * Bj
24-Feb GE 0.1180
24-Feb FB 0.0692
24-Feb MSFT 0.1404
Expected Rate of Return 0.3276

Mar 3

Week 4 Index Standings (Km)
Date Ticker Symbol Company Name Purchase Price Current Price Volume SPY QQQ Beta (Bj) Weight (Wi)
3-Mar GE General Electric Company 30.42 30.12 25 238.42 131.02 1.1 3.45%
3-Mar FB Facebook, Inc 133.84 137.17 10 238.42 131.02 0.49 6.03%
3-Mar MSFT Microsoft 64.52 64.25 20 238.42 131.02 1.38 5.82%
3-Mar SNAP Snap Inc. 27.03 27.09 700 238.42 131.02 84.70%
Weight Calculations Return on Portfolio Risk on Portfolio
Cash Balance $77,649.70 Date Stock Ki x Wi Date Stock Bpi x Wi
General Electric Company 770.50 3-Mar GE 0.0041 3-Mar GE 0.0379
Facebook, Inc 1348.40 3-Mar FB 0.0042 3-Mar FB 0.0296
Microsoft 1300.40 3-Mar MSFT 0.0082 3-Mar MSFT 0.0803
Snap Inc. 18931.00 3-Mar SNAP 0.0254 3-Mar SNAP 0.0000
Purchase Totals $ 22,350.30 Return on Portfolio 0.0418 Risk on Portfolio 0.1478
Expected Rated of Return
Date Stock Krf + ( Km - Krf ) * Bj
3-Mar GE 0.1180
3-Mar FB 0.0692
3-Mar MSFT 0.1404
3-Mar SNAP 0.0300
Expected Rate of Return 0.3576

Mar 10

Week 5 Index Standings (Km)
Date Ticker Symbol Company Name Purchase Price Current Price Volume SPY QQQ Beta (Bj) Weight (Wi)
10-Mar GE General Electric Company 30.42 30.28 25 237.69 131.39 1.1 1.80%
10-Mar FB Facebook, Inc 133.84 138.79 10 237.69 131.39 0.49 3.15%
10-Mar MSFT Microsoft 64.52 64.93 20 237.69 131.39 1.38 3.03%
10-Mar SNAP Snap Inc. 27.03 22.07 700 237.69 131.39 44.18%
10-Mar GILD Gilead Sciences Inc. 68.3 68.19 300 237.69 131.39 0.99 47.84%
Weight Calculations Return on Portfolio Risk on Portfolio
Cash Balance $57,149.70 Date Stock Ki x Wi Date Stock Bpi x Wi
General Electric Company 770.50 10-Mar GE 0.0021 10-Mar GE 0.0198
Facebook, Inc 1348.40 10-Mar FB 0.0022 10-Mar FB 0.0154
Microsoft 1300.40 10-Mar MSFT 0.0043 10-Mar MSFT 0.0419
Snap Inc. 18931.00 10-Mar SNAP 0.0133 10-Mar SNAP 0.0000
Gilead Sciences Inc. 20500.00 10-Mar GILD 0.2233 10-Mar GILD 0.4736
Purchase Totals $ 42,850.30 Return on Portfolio 0.2451 Risk on Portfolio 0.5507
Expected Rated of Return
Date Stock Krf + ( Km - Krf ) * Bj
10-Mar GE 0.1180
10-Mar FB 0.0692
10-Mar MSFT 0.1404
10-Mar SNAP 0.0300
10-Mar GILD 0.1092
Expected Rate of Return 0.4668

Mar 17

Week 6 Index Standings (Km)
Date Ticker Symbol Company Name Purchase Price Current Price Volume SPY QQQ Beta (Bj) Weight (Wi)
17-Mar GE General Electric Company 30.42 29.88 25 237.03 131.69 1.1 1.35%
17-Mar FB Facebook, Inc 133.84 139.84 10 237.03 131.69 0.49 2.36%
17-Mar GILD Gilead Sciences Inc. 68.3 69.06 300 237.03 131.69 0.99 35.86%
17-Mar INTC Intel Corporation 35.15 35.27 500 237.03 131.69 1.11 30.76%
17-Mar QBAK Qualstar Corporation 8.48 7.29 2000 237.03 131.69 0.07 29.68%
Date Ticker Symbol Company Name Purchase Price Selling Price Volume SPY QQQ Beta (Bj)
16-Mar SNAP Snap Inc. 27.03 19.92 700 237.03 131.69
17-Mar MSFT Microsoft 64.52 64.87 20 237.03 131.69 1.38
Weight Calculations Return on Portfolio Risk on Portfolio
Cash Balance $42,826.10 Date Stock Ki x Wi Date Stock Bpi x Wi
General Electric Company 770.50 17-Mar GE 0.0016 17-Mar GE 0.0148
Facebook, Inc 1348.40 17-Mar FB 0.0016 17-Mar FB 0.0116
Gilead Sciences Inc. 20500.00 17-Mar GILD 0.0392 17-Mar GILD 0.3550
Intel Corporation 17585.00 17-Mar INTC 0.0365 17-Mar INTC 0.3414
Qualstar Corporation 16970.00 17-Mar QBAK 0.0106 17-Mar QBAK 0.0208
Purchase Totals $ 57,173.90 Return on Portfolio 0.0895 Risk on Portfolio 0.7435
Expected Rated of Return
Date Stock Krf + ( Km - Krf ) * Bj
17-Mar GE 0.1180
17-Mar FB 0.0692
17-Mar GILD 0.1092
17-Mar INTC 0.1188
17-Mar QBAK 0.0356
Expected Rate of Return 0.4508

Mar 24

Week 7 Index Standings (Km)
Date Ticker Symbol Company Name Purchase Price Current Price Volume SPY QQQ Beta (Bj) Weight (Wi)
24-Mar GE General Electric Company 30.42 29.72 25 233.86 130.63 1.1 1.92%
24-Mar FB Facebook, Inc 133.84 140.34 10 233.86 130.63 0.49 3.35%
24-Mar GILD Gilead Sciences Inc. 68.3 67.51 300 233.86 130.63 0.99 50.99%
24-Mar INTC Intel Corporation 35.15 35.17 500 233.86 130.63 1.11 43.74%
Date Ticker Symbol Company Name Purchase Price Selling Price Volume SPY QQQ Beta (Bj)
16-Mar SNAP Snap Inc. 27.03 19.92 700 237.03 131.69
17-Mar MSFT Microsoft 64.52 64.87 20 237.03 131.69 1.38
24-Mar QBAK Qualstar Corporation 8.48 6.02 2000 233.86 130.63 0.07
Weight Calculations Return on Portfolio Risk on Portfolio
Cash Balance $59,796.10 Date Stock Ki x Wi Date Stock Bpi x Wi
General Electric Company 770.50 24-Mar GE 0.0023 24-Mar GE 0.0211
Facebook, Inc 1348.40 24-Mar FB 0.0023 24-Mar FB 0.0164
Gilead Sciences Inc. 20500.00 24-Mar GILD 0.0557 24-Mar GILD 0.5048
Intel Corporation 17585.00 24-Mar INTC 0.0520 24-Mar INTC 0.4855
Purchase Totals $ 40,203.90 Return on Portfolio 0.1122 Risk on Portfolio 1.0278
Expected Rated of Return
Date Stock Krf + ( Km - Krf ) * Bj
24-Mar GE 0.1180
24-Mar FB 0.0692
24-Mar GILD 0.1092
24-Mar INTC 0.1188
Expected Rate of Return 0.4152

Mar 31

Week 8 Index Standings (Km)
Date Ticker Symbol Company Name Purchase Price Current Price Volume SPY QQQ Beta (Bj) Weight (Wi)
31-Mar GE General Electric Company 30.42 29.8 25 235.74 132.38 1.1 1.41%
31-Mar FB Facebook, Inc 133.84 142.05 10 235.74 132.38 0.49 2.47%
31-Mar GILD Gilead Sciences Inc. 68.3 67.92 300 235.74 132.38 0.99 37.54%
31-Mar INTC Intel Corporation 35.15 36.07 500 235.74 132.38 1.11 32.20%
31-Mar APPL Apple Inc. 143.91 140.68 100 235.74 132.38 1.44 26.37%
Date Ticker Symbol Company Name Purchase Price Selling Price Volume SPY QQQ Beta (Bj)
16-Mar SNAP Snap Inc. 27.03 19.92 700 237.03 131.69
17-Mar MSFT Microsoft 64.52 64.87 20 237.03 131.69 1.38
24-Mar QBAK Qualstar Corporation 8.48 6.02 2000 233.86 130.63 0.07
Weight Calculations Return on Portfolio Risk on Portfolio
Cash Balance $45,395.10 Date Stock Ki x Wi Date Stock Bpi x Wi
General Electric Company 770.50 31-Mar GE 0.0017 31-Mar GE 0.0155
Facebook, Inc 1348.40 31-Mar FB 0.0017 31-Mar FB 0.0121
Gilead Sciences Inc. 20500.00 31-Mar GILD 0.0410 31-Mar GILD 0.3717
Intel Corporation 17585.00 31-Mar INTC 0.0383 31-Mar INTC 0.3575
Apple Inc. 14401.00 31-Mar APPL 0.0383 31-Mar APPL 0.3798
Purchase Totals $ 54,604.90 Return on Portfolio 0.1209 Risk on Portfolio 1.1365
Expected Rated of Return
Date Stock Krf + ( Km - Krf ) * Bj
31-Mar GE 0.1180
31-Mar FB 0.0692
31-Mar GILD 0.1092
31-Mar INTC 0.1188
31-Mar APPL 0.1452
Expected Rate of Return 0.5604

Apr 5

Week 9
Date Ticker Symbol Company Name Purchase Price Current Price Volume SPY QQQ Beta (Bj) Weight (Wi)
5-Apr GE General Electric Company 30.42 29.97 25 235.2 131.97 1.1 1.41%
5-Apr FB Facebook, Inc 133.84 141.85 10 235.2 131.97 0.49 2.47%
5-Apr GILD Gilead Sciences Inc. 68.3 67.47 300 235.2 131.97 0.99 37.54%
5-Apr INTC Intel Corporation 35.15 36.22 500 235.2 131.97 1.11 32.20%
5-Apr APPL Apple inc. 143.91 144.02 100 235.2 131.97 1.44 26.37%
Date Ticker Symbol Company Name Purchase Price Selling Price Volume SPY QQQ Beta (Bj)
16-Mar SNAP Snap Inc. 27.03 19.92 700 237.03 131.69
17-Mar MSFT Microsoft 64.52 64.87 20 237.03 131.69 1.38
24-Mar QBAK Qualstar Corporation 8.48 6.02 2000 233.86 130.63 0.07
Weight Calculations Return on Portfolio Risk on Portfolio
Cash Balance $45,395.10 Date Stock Ki x Wi Date Stock Bpi x Wi
General Electric Company 770.50 5-Apr GE 0.0017 5-Apr GE 0.0155
Facebook, Inc 1348.40 5-Apr FB 0.0017 5-Apr FB 0.0121
Gilead Sciences Inc. 20500.00 5-Apr GILD 0.0410 5-Apr GILD 0.3717
Intel Corporation 17585.00 5-Apr INTC 0.0383 5-Apr INTC 0.3575
Apple Inc. 14401.00 5-Apr APPL 0.0383 5-Apr APPL 0.3798
Purchase Totals $ 54,604.90 Return on Portfolio 0.1209 Risk on Portfolio 1.1365
Expected Rated of Return
Date Stock Krf + ( Km - Krf ) * Bj
5-Apr GE 0.1180
5-Apr FB 0.0692
5-Apr GILD 0.1092
5-Apr INTC 0.1188
5-Apr APPL 0.1452
Expected Rate of Return 0.5604

Apr 12

Week 10
Date Ticker Symbol Company Name Purchase Price Current Price Volume SPY QQQ Beta (Bj) Weight (Wi)
12-Apr GE General Electric Company 30.42 29.77 25 234.03 130.92 1.1 1.34%
12-Apr FB Facebook, Inc 133.84 139.58 10 234.03 130.92 0.49 2.35%
12-Apr GILD Gilead Sciences Inc. 68.3 66.22 300 234.03 130.92 0.99 35.66%
12-Apr INTC Intel Corporation 35.15 35.91 500 234.03 130.92 1.11 30.59%
12-Apr APPL Apple Inc 143.91 141.8 100 234.03 130.92 1.44 25.05%
12-Apr TWTR Twitter Inc 14.36 14.42 200 234.03 130.92 1.07 5.01%
Date Ticker Symbol Company Name Purchase Price Selling Price Volume SPY QQQ Beta (Bj)
16-Mar SNAP Snap Inc. 27.03 19.92 700 237.03 131.69
17-Mar MSFT Microsoft 64.52 64.87 20 237.03 131.69 1.38
24-Mar QBAK Qualstar Corporation 8.48 6.02 2000 233.86 130.63 0.07
Weight Calculations Return on Portfolio Risk on Portfolio
Cash Balance $42,513.10 Date Stock Ki x Wi Date Stock Bpi x Wi
General Electric Company 770.50 12-Apr GE 0.0016 12-Apr GE 0.0147
Facebook, Inc 1348.40 12-Apr FB 0.0016 12-Apr FB 0.0115
Gilead Sciences Inc. 20500.00 12-Apr GILD 0.0389 12-Apr GILD 0.3530
Intel Corporation 17585.00 12-Apr INTC 0.0363 12-Apr INTC 0.3395
Apple Inc 14401.00 12-Apr APPL 0.0364 12-Apr APPL 0.3607
Twitter Inc 2882.00 12-Apr TWTR 0.0058 12-Apr TWTR 0.0536
Purchase Totals $ 57,486.90 Return on Portfolio 0.1207 Risk on Portfolio 1.1332
Expected Rated of Return
Date Stock Krf + ( Km - Krf ) * Bj
12-Apr GE 0.1180
12-Apr FB 0.0692
12-Apr GILD 0.1092
12-Apr INTC 0.1188
12-Apr APPL 0.1452
12-Apr TWTR 0.1156
Expected Rate of Return 0.6760

Apr 19

Week 11
Date Ticker Symbol Company Name Purchase Price Selling Price Volume SPY QQQ Beta (Bj) Weight (Wi)
12-Apr GE General Electric Company 30.42 30 25 233.44 131.49 1.1 1.28%
12-Apr FB Facebook, Inc 133.84 142.27 10 233.44 131.49 0.49 2.47%
12-Apr GILD Gilead Sciences Inc. 68.3 66.28 300 233.44 131.49 0.99 34.93%
12-Apr INTC Intel Corporation 35.15 35.91 500 233.44 131.49 1.11 31.54%
12-Apr APPL Apple Inc 143.91 140.68 100 233.44 131.49 1.44 24.70%
12-Apr TWTR Twitter Inc 14.36 14.54 200 233.44 131.49 1.07 5.08%
16-Mar SNAP Snap Inc. 27.03 19.92 700 237.03 131.69
17-Mar MSFT Microsoft 64.52 64.87 20 237.03 131.69 1.38
24-Mar QBAK Qualstar Corporation 8.48 6.02 2000 233.86 130.63 0.07
Weight Calculations Return on Portfolio Risk on Portfolio
Date Stock Ki x Wi Date Stock Bpi x Wi
General Electric Company 730.00 12-Apr GE 0.0015 12-Apr GE 0.0141
Facebook, Inc 1402.70 12-Apr FB 0.0017 12-Apr FB 0.0121
Gilead Sciences Inc. 19864.00 12-Apr GILD 0.0381 12-Apr GILD 0.3458
Intel Corporation 17935.00 12-Apr INTC 0.0375 12-Apr INTC 0.3501
Apple Inc 14048.00 12-Apr APPL 0.0359 12-Apr APPL 0.3557
Twitter inc 2888.00 12-Apr TWTR 0.0059 12-Apr TWTR 0.0543
Return on Portfolio 0.1206 Risk on Portfolio 1.1322
Purchase Totals $ 56,867.70
Expected Rated of Return
Date Stock Krf + ( Km - Krf ) * Bj Purchase Totals $ 56,867.70
12-Apr GE 0.1180 Snap Inc. -4997.00
12-Apr FB 0.0692 Microsoft -13.00
12-Apr GILD 0.1092 Qualstar Corporation -4940
12-Apr INTC 0.1188
12-Apr APPL 0.1452 Cash Balance $ 89,430.80
12-Apr TWTR 0.1156 Return Precentage -11%
Expected Rate of Return 0.6760

Stock list

STOCKS
WEEK SPY GE FB MSFT SNAP GILD INTC QBAK APPL TWTR
1 231.51
2 235.09 30.37 133.53 64.62
2 30.42 133.84 64.52
3 236.74 30.19 135.44 64.62
4 238.42 30.12 137.17 64.25 27.09
4 27.03
5 237.69 30.42 138.79 64.93 22.07 68.19
5 68.03
6 237.03 29.88 139.84 69.06 35.27 7.29
6 35.15 8.48
7 233.86 29.72 140.34 67.51 35.17
8 235.74 29.8 142.05 67.92 36.07 140.68
8 143.91
9 235.2 29.97 141.85 67.47 36.22 144.02
10 234.03 29.77 139.58 66.22 35.91 141.8 14.42
10 140.68 14.36
11
WEEK SPY GE FB MSFT SNAP GILD INTC QBAK APPL TWTR
1 231.51
2 235.09 30.37 133.53 64.62
3 236.74 30.19 135.44 64.62
4 238.42 30.12 137.17 64.25 27.09
5 237.69 30.42 138.79 64.93 22.07 68.19
6 237.03 29.88 139.84 69.06 35.27 7.29
7 233.86 29.72 140.34 67.51 35.17
8 235.74 29.8 142.05 67.92 36.07 140.68
9 235.2 29.97 141.85 67.47 36.22 144.02
10 234.03 29.77 139.58 66.22 35.91 141.8 14.42
11 233.44 30 142.27 66.28 35.91 28.85 14.54

Raw data

SPY Closing GE Closing FB Closing MSFT Closing SNAP Closing GILD Closing INTC Closing QBAK Closing APPL Closing TEVA Closing
Week Return Return Return Return Return Return Return Return Return Return
1 231.51
2 235.09 0.0154636949 30.37 133.53 64.62
3 236.74 0.0070185886 30.19 -0.0059269015 135.44 0.0143039017 64.62 0
4 238.42 0.0070963927 30.12 -0.0023186486 137.17 0.0127731837 64.25 -0.0057257815 27.09
5 237.69 -0.0030618237 30.42 0.0099601594 138.79 0.0118101626 64.93 0.0105836576 22.07 -0.1853082318 68.19
6 237.03 -0.002776726 29.88 -0.0177514793 139.84 0.0075653866 69.06 0.012758469 35.27 7.29
7 233.86 -0.0133738345 29.72 -0.0053547523 140.34 0.0035755149 67.51 -0.0224442514 35.17 -0.0028352708
8 235.74 0.0080389977 29.8 0.00269179 142.05 0.0121846943 67.92 0.0060731743 36.07 0.0255899915 140.68
9 235.2 -0.0022906592 29.97 0.005704698 141.85 -0.0014079549 67.47 -0.0066254417 36.22 0.0041585805 144.02 0.0237418254
10 234.03 -0.0049744898 29.77 -0.00667334 139.58 -0.0160028199 66.22 -0.0185267526 35.91 -0.0085588073 141.8 -0.0154145258 14.42
11 -1 -1 -1 -1 -1 -1
Mean return -0.0988859859 -0.1132964972 -0.1061331035 0.001619292 -0.1853082318 -0.1714608004 -0.1963291012 -0.3305575668
Std. Dev. 0.3167271742 0.3326114388 0.3353367102 0.0082744203 0.406127494 0.4494518477 0.5800846348

Sharpe ratio

Date Value Return TradesMade Rank
2/14/17 0:00 100008.22 0.0000821932 0 0
2/15/17 0:00 100016.44 0.0000821865 0 0
2/16/17 0:00 100024.66 -0.0006701347 0 0
2/17/17 0:00 99957.63 0.0000790335 2 105
2/18/17 0:00 99965.53 0.0000790272 2 105
2/19/17 0:00 99973.43 0.000079021 2 104
2/20/17 0:00 99981.33 0.0002275425 2 106
2/21/17 0:00 100004.08 0.0000854965 2 150
2/22/17 0:00 100012.63 -0.0001019871 2 136
2/23/17 0:00 100002.43 0.0005820859 2 116
2/24/17 0:00 100060.64 0.0000790521 2 103
2/25/17 0:00 100068.55 0.0000790458 2 112
2/26/17 0:00 100076.46 0.0002369189 2 113
2/27/17 0:00 100100.17 0.0004211781 2 123
2/28/17 0:00 100142.33 0.0005842684 2 84
3/1/17 0:00 100200.84 -0.0001336316 2 113
3/2/17 0:00 100187.45 0.0005904931 2 89
3/3/17 0:00 100246.61 0.0000634435 3 91
3/4/17 0:00 100252.97 0.0000634395 3 91
3/5/17 0:00 100259.33 -0.0233303973 3 91
3/6/17 0:00 97920.24 -0.0158291074 3 245
3/7/17 0:00 96370.25 0.0099238095 3 260
3/8/17 0:00 97326.61 -0.0004627717 3 245
3/9/17 0:00 97281.57 -0.0049930321 4 244
3/10/17 0:00 96795.84 0 4 262
3/11/17 0:00 96795.84 0 4 261
3/12/17 0:00 96795.84 -0.0072807881 4 260
3/13/17 0:00 96091.09 -0.0049643521 4 274
3/14/17 0:00 95614.06 0.0038631348 4 284
3/15/17 0:00 95983.43 -0.0096061372 4 285
3/16/17 0:00 95061.4 -0.0193350824 7 295
3/17/17 0:00 93223.38 0.0000319662 7 299
3/18/17 0:00 93226.36 0.0000319652 7 295
3/19/17 0:00 93229.34 -0.0031966332 7 291
3/20/17 0:00 92931.32 -0.0172118506 7 302
3/21/17 0:00 91331.8 -0.0055273191 7 303
3/22/17 0:00 90826.98 -0.0065847174 7 302
3/23/17 0:00 90228.91 -0.0025836508 7 305
3/24/17 0:00 89995.79 0.0000441132 8 299
3/25/17 0:00 89999.76 0.0000441112 8 295
3/26/17 0:00 90003.73 0.0005790871 8 292
3/27/17 0:00 90055.85 0.0002189752 8 298
3/28/17 0:00 90075.57 0.0006693269 9 301
3/29/17 0:00 90135.86 0.0019763499 9 301
3/30/17 0:00 90314 0.0026583918 9 306
3/31/17 0:00 90554.09 0.0000308103 9 298
4/1/17 0:00 90556.88 0.0000308094 9 291
4/2/17 0:00 90559.67 0.0000308084 9 283
4/3/17 0:00 90562.46 0.0001760111 9 0
4/4/17 0:00 90578.4 0.000030802 9 300
4/5/17 0:00 90581.19 -0.0039987331 9 0
4/6/17 0:00 90218.98 -0.0005482217 9 301
4/7/17 0:00 90169.52 0 10 290
4/8/17 0:00 90169.52 0 10 0
4/9/17 0:00 90169.52 0.0000848402 10 0
4/10/17 0:00 90177.17 0.0000282777 10 0
4/11/17 0:00 90179.72 0.0000283878 10 0
4/12/17 0:00 90182.28 0.000028387 10 0
4/13/17 0:00 90184.84 -1 10 0
Average Return -0.0186853179
Geometric Mean -0.175%
Annualized Portfolio Return -64%
Standard Deviation 0.1289655662
Annualize The Standard Deviation 2.4638742462
` `
Sharpe Ratio: -0.2593729909

TransactionHistory_5_4_2017

Symbol TransactionType CompanyName Exchange Quantity FXRate Currency SecurityType Price CreateDate
TWTR Market - Sell Twitter Inc. US 200 1 USD Equities $14.54 4/18/17
AAPL Market - Sell Apple Inc. US 100 1 USD Equities $140.68 4/18/17
INTC Market - Sell Intel Corporation US 500 1 USD Equities $35.91 4/18/17
GILD Market - Sell Gilead Sciences Inc. US 300 1 USD Equities $66.28 4/18/17
FB Market - Sell Facebook Inc. US 10 1 USD Equities $142.27 4/18/17
GE Market - Sell General Electric Company US 25 1 USD Equities $30.00 4/18/17
TWTR Market - Buy Twitter Inc. US 200 1 USD Equities $14.36 4/7/17
AAPL Market - Buy Apple Inc. US 100 1 USD Equities $143.91 3/28/17
QBAK Market - Sell Qualstar Corporation US -2000 1 USD Equities $6.02 3/24/17
QBAK Market - Buy Qualstar Corporation US 2000 1 USD Equities $8.48 3/16/17
INTC Market - Buy Intel Corporation US 500 1 USD Equities $35.15 3/16/17
SNAP Market - Sell Snap Inc. US -700 1 USD Equities $19.92 3/16/17
MSFT Market - Sell Microsoft US 20 1 USD Equities $64.87 3/16/17
GILD Market - Buy Gilead Sciences Inc. US 300 1 USD Equities $68.30 3/9/17
SNAP Market - Buy Snap Inc. US 700 1 USD Equities $27.03 3/3/17
GE Dividends General Electric Company US 25 1 USD Equities $0.24 2/23/17
GE Dividends General Electric Company US 25 1 USD Equities $0.24 2/23/17
MSFT Market - Buy Microsoft US 20 1 USD Equities $64.52 2/17/17
FB Market - Buy Facebook Inc. US 10 1 USD Equities $133.87 2/17/17
GE Market - Buy General Electric Company US 25 1 USD Equities $30.42 2/17/17