-p 0 (plotting) -f orders/orders3.csv (ordersfile) -n -1 (order_id) -c 1000000 (start_value) -t 9.95 (transaction_fee) -m 0.005 (market_impact_factor) -l 0 (do_leverage) -s solution (do_leverage) --- begin student code ------------------------------------------------ 1) orders are (panda frame): Symbol Order Shares Date 2011-01-10 AAPL BUY 1500 2011-01-13 AAPL SELL 1500 2011-01-13 IBM BUY 4000 2011-01-26 GOOG BUY 1000 2011-02-02 XOM SELL 4000 2011-02-10 XOM BUY 4000 2011-03-03 GOOG SELL 1000 2011-03-03 IBM SELL 2200 2011-06-03 IBM SELL 3300 2011-05-03 IBM BUY 1500 2011-08-01 GOOG BUY 55 2011-08-01 GOOG SELL 55: 2) orders are (sorted): Symbol Order Shares Date 2011-01-10 AAPL BUY 1500 2011-01-13 AAPL SELL 1500 2011-01-13 IBM BUY 4000 2011-01-26 GOOG BUY 1000 2011-02-02 XOM SELL 4000 2011-02-10 XOM BUY 4000 2011-03-03 GOOG SELL 1000 2011-03-03 IBM SELL 2200 2011-05-03 IBM BUY 1500 2011-06-03 IBM SELL 3300 2011-08-01 GOOG BUY 55 2011-08-01 GOOG SELL 55 4) 'change' order (list) is: [('2011-01-10', 'AAPL', 1500), ('2011-01-13', 'AAPL', -1500), ('2011-01-13', 'IBM', 4000), ('2011-01-26', 'GOOG', 1000), ('2011-02-02', 'XOM', -4000), ('2011-02-10', 'XOM', 4000), ('2011-03-03', 'GOOG', -1000), ('2011-03-03', 'IBM', -2200), ('2011-05-03', 'IBM', 1500), ('2011-06-03', 'IBM', -3300), ('2011-08-01', 'GOOG', 55), ('2011-08-01', 'GOOG', -55)] 5) symbols to pull are: ['AAPL', 'AAPL', 'IBM', 'GOOG', 'XOM', 'XOM', 'GOOG', 'IBM', 'IBM', 'IBM', 'GOOG', 'GOOG'] 6) symbols (non duplicates) to pull are: ['GOOG', 'AAPL', 'XOM', 'IBM'] 7) dates: DatetimeIndex(['2011-01-10', '2011-01-11', '2011-01-12', '2011-01-13', '2011-01-14', '2011-01-15', '2011-01-16', '2011-01-17', '2011-01-18', '2011-01-19', ... '2011-07-23', '2011-07-24', '2011-07-25', '2011-07-26', '2011-07-27', '2011-07-28', '2011-07-29', '2011-07-30', '2011-07-31', '2011-08-01'], dtype='datetime64[ns]', length=204, freq='D') 8) get adjusting closing prices of symbols date range : SPY GOOG AAPL XOM IBM 2011-01-10 123.19 614.21 340.99 72.02 143.41 2011-01-11 123.63 616.01 340.18 72.56 143.06 2011-01-12 124.74 616.87 342.95 73.41 144.82 2011-01-13 124.54 616.69 344.20 73.54 144.55 2011-01-14 125.44 624.18 346.99 74.62 145.70 2011-01-18 125.65 639.63 339.19 75.45 146.33 2011-01-19 124.42 631.75 337.39 75.00 151.22 2011-01-20 124.26 626.77 331.26 74.53 151.33 2011-01-21 124.54 611.83 325.32 75.71 151.04 2011-01-24 125.25 611.08 336.01 75.34 155.05 2011-01-25 125.31 619.91 339.94 75.43 156.81 2011-01-26 125.80 616.50 342.38 76.37 156.42 2011-01-27 126.11 616.79 341.74 76.58 156.45 2011-01-28 123.91 600.99 334.66 75.72 154.64 2011-01-31 124.84 600.36 337.87 77.34 157.35 2011-02-01 126.84 611.04 343.55 80.44 158.87 2011-02-02 126.60 612.00 342.85 79.96 158.62 2011-02-03 126.88 610.15 341.97 79.99 158.84 2011-02-04 127.24 610.98 345.02 79.84 159.30 2011-02-07 128.03 614.29 350.38 80.46 160.09 2011-02-08 128.61 618.38 353.68 79.97 161.93 2011-02-09 128.32 616.50 356.63 79.55 160.56 2011-02-10 128.37 616.44 353.02 80.18 160.02 2011-02-11 129.14 624.50 355.32 79.81 159.78 2011-02-14 129.45 628.15 357.64 81.83 159.17 2011-02-15 129.04 624.15 358.36 79.96 158.80 2011-02-16 129.85 624.22 361.58 80.65 159.34 2011-02-17 130.24 625.26 356.77 80.83 160.16 2011-02-18 130.51 630.08 349.06 81.43 160.75 2011-02-22 127.90 610.21 337.16 82.34 157.93 ... ... ... ... ... ... 2011-06-20 125.04 484.58 313.97 77.25 161.64 2011-06-21 126.76 493.00 323.91 78.09 162.82 2011-06-22 125.99 487.01 321.23 77.36 162.29 2011-06-23 125.63 480.22 329.81 76.02 162.72 2011-06-24 124.17 474.88 324.95 74.41 161.69 2011-06-27 125.28 482.80 330.62 75.52 164.19 2011-06-28 126.91 493.65 333.83 77.17 166.53 2011-06-29 128.00 497.57 332.61 77.78 167.05 2011-06-30 129.22 506.38 334.23 78.87 168.04 2011-07-01 131.13 521.03 341.79 79.48 170.97 2011-07-05 131.03 532.44 347.94 79.08 171.84 2011-07-06 131.18 535.36 350.26 79.05 174.07 2011-07-07 132.54 546.60 355.67 79.82 172.87 2011-07-08 131.60 531.99 358.17 79.88 172.88 2011-07-11 129.22 527.28 352.49 79.37 171.41 2011-07-12 128.67 534.01 352.24 79.36 170.49 2011-07-13 129.10 538.26 356.49 79.94 170.75 2011-07-14 128.21 528.94 356.24 79.70 170.66 2011-07-15 128.95 597.62 363.36 80.44 171.95 2011-07-18 127.89 594.94 372.20 80.10 171.69 2011-07-19 129.97 602.55 375.24 81.05 181.42 2011-07-20 129.89 595.35 385.25 80.73 179.89 2011-07-21 131.69 606.99 385.63 82.40 181.11 2011-07-22 131.78 618.23 391.62 82.59 181.39 2011-07-25 131.05 618.98 396.80 81.96 179.94 2011-07-26 130.56 622.52 401.69 81.77 179.19 2011-07-27 127.88 607.22 390.91 80.74 177.64 2011-07-28 127.51 610.94 390.14 78.95 178.08 2011-07-29 126.64 603.69 388.81 77.33 178.13 2011-08-01 126.10 606.77 395.05 77.15 177.05 [141 rows x 5 columns] 9) extract SPY from prices : GOOG AAPL XOM IBM 2011-01-10 614.21 340.99 72.02 143.41 2011-01-11 616.01 340.18 72.56 143.06 2011-01-12 616.87 342.95 73.41 144.82 2011-01-13 616.69 344.20 73.54 144.55 2011-01-14 624.18 346.99 74.62 145.70 2011-01-18 639.63 339.19 75.45 146.33 2011-01-19 631.75 337.39 75.00 151.22 2011-01-20 626.77 331.26 74.53 151.33 2011-01-21 611.83 325.32 75.71 151.04 2011-01-24 611.08 336.01 75.34 155.05 2011-01-25 619.91 339.94 75.43 156.81 2011-01-26 616.50 342.38 76.37 156.42 2011-01-27 616.79 341.74 76.58 156.45 2011-01-28 600.99 334.66 75.72 154.64 2011-01-31 600.36 337.87 77.34 157.35 2011-02-01 611.04 343.55 80.44 158.87 2011-02-02 612.00 342.85 79.96 158.62 2011-02-03 610.15 341.97 79.99 158.84 2011-02-04 610.98 345.02 79.84 159.30 2011-02-07 614.29 350.38 80.46 160.09 2011-02-08 618.38 353.68 79.97 161.93 2011-02-09 616.50 356.63 79.55 160.56 2011-02-10 616.44 353.02 80.18 160.02 2011-02-11 624.50 355.32 79.81 159.78 2011-02-14 628.15 357.64 81.83 159.17 2011-02-15 624.15 358.36 79.96 158.80 2011-02-16 624.22 361.58 80.65 159.34 2011-02-17 625.26 356.77 80.83 160.16 2011-02-18 630.08 349.06 81.43 160.75 2011-02-22 610.21 337.16 82.34 157.93 ... ... ... ... ... 2011-06-20 484.58 313.97 77.25 161.64 2011-06-21 493.00 323.91 78.09 162.82 2011-06-22 487.01 321.23 77.36 162.29 2011-06-23 480.22 329.81 76.02 162.72 2011-06-24 474.88 324.95 74.41 161.69 2011-06-27 482.80 330.62 75.52 164.19 2011-06-28 493.65 333.83 77.17 166.53 2011-06-29 497.57 332.61 77.78 167.05 2011-06-30 506.38 334.23 78.87 168.04 2011-07-01 521.03 341.79 79.48 170.97 2011-07-05 532.44 347.94 79.08 171.84 2011-07-06 535.36 350.26 79.05 174.07 2011-07-07 546.60 355.67 79.82 172.87 2011-07-08 531.99 358.17 79.88 172.88 2011-07-11 527.28 352.49 79.37 171.41 2011-07-12 534.01 352.24 79.36 170.49 2011-07-13 538.26 356.49 79.94 170.75 2011-07-14 528.94 356.24 79.70 170.66 2011-07-15 597.62 363.36 80.44 171.95 2011-07-18 594.94 372.20 80.10 171.69 2011-07-19 602.55 375.24 81.05 181.42 2011-07-20 595.35 385.25 80.73 179.89 2011-07-21 606.99 385.63 82.40 181.11 2011-07-22 618.23 391.62 82.59 181.39 2011-07-25 618.98 396.80 81.96 179.94 2011-07-26 622.52 401.69 81.77 179.19 2011-07-27 607.22 390.91 80.74 177.64 2011-07-28 610.94 390.14 78.95 178.08 2011-07-29 603.69 388.81 77.33 178.13 2011-08-01 606.77 395.05 77.15 177.05 [141 rows x 4 columns] 10) address the NaNs : GOOG AAPL XOM IBM 2011-01-10 614.21 340.99 72.02 143.41 2011-01-11 616.01 340.18 72.56 143.06 2011-01-12 616.87 342.95 73.41 144.82 2011-01-13 616.69 344.20 73.54 144.55 2011-01-14 624.18 346.99 74.62 145.70 2011-01-18 639.63 339.19 75.45 146.33 2011-01-19 631.75 337.39 75.00 151.22 2011-01-20 626.77 331.26 74.53 151.33 2011-01-21 611.83 325.32 75.71 151.04 2011-01-24 611.08 336.01 75.34 155.05 2011-01-25 619.91 339.94 75.43 156.81 2011-01-26 616.50 342.38 76.37 156.42 2011-01-27 616.79 341.74 76.58 156.45 2011-01-28 600.99 334.66 75.72 154.64 2011-01-31 600.36 337.87 77.34 157.35 2011-02-01 611.04 343.55 80.44 158.87 2011-02-02 612.00 342.85 79.96 158.62 2011-02-03 610.15 341.97 79.99 158.84 2011-02-04 610.98 345.02 79.84 159.30 2011-02-07 614.29 350.38 80.46 160.09 2011-02-08 618.38 353.68 79.97 161.93 2011-02-09 616.50 356.63 79.55 160.56 2011-02-10 616.44 353.02 80.18 160.02 2011-02-11 624.50 355.32 79.81 159.78 2011-02-14 628.15 357.64 81.83 159.17 2011-02-15 624.15 358.36 79.96 158.80 2011-02-16 624.22 361.58 80.65 159.34 2011-02-17 625.26 356.77 80.83 160.16 2011-02-18 630.08 349.06 81.43 160.75 2011-02-22 610.21 337.16 82.34 157.93 ... ... ... ... ... 2011-06-20 484.58 313.97 77.25 161.64 2011-06-21 493.00 323.91 78.09 162.82 2011-06-22 487.01 321.23 77.36 162.29 2011-06-23 480.22 329.81 76.02 162.72 2011-06-24 474.88 324.95 74.41 161.69 2011-06-27 482.80 330.62 75.52 164.19 2011-06-28 493.65 333.83 77.17 166.53 2011-06-29 497.57 332.61 77.78 167.05 2011-06-30 506.38 334.23 78.87 168.04 2011-07-01 521.03 341.79 79.48 170.97 2011-07-05 532.44 347.94 79.08 171.84 2011-07-06 535.36 350.26 79.05 174.07 2011-07-07 546.60 355.67 79.82 172.87 2011-07-08 531.99 358.17 79.88 172.88 2011-07-11 527.28 352.49 79.37 171.41 2011-07-12 534.01 352.24 79.36 170.49 2011-07-13 538.26 356.49 79.94 170.75 2011-07-14 528.94 356.24 79.70 170.66 2011-07-15 597.62 363.36 80.44 171.95 2011-07-18 594.94 372.20 80.10 171.69 2011-07-19 602.55 375.24 81.05 181.42 2011-07-20 595.35 385.25 80.73 179.89 2011-07-21 606.99 385.63 82.40 181.11 2011-07-22 618.23 391.62 82.59 181.39 2011-07-25 618.98 396.80 81.96 179.94 2011-07-26 622.52 401.69 81.77 179.19 2011-07-27 607.22 390.91 80.74 177.64 2011-07-28 610.94 390.14 78.95 178.08 2011-07-29 603.69 388.81 77.33 178.13 2011-08-01 606.77 395.05 77.15 177.05 [141 rows x 4 columns] 11) add cash column (value of cash $1 is worth $1) to prices : GOOG AAPL XOM IBM _CASH 2011-01-10 614.21 340.99 72.02 143.41 1.0 2011-01-11 616.01 340.18 72.56 143.06 1.0 2011-01-12 616.87 342.95 73.41 144.82 1.0 2011-01-13 616.69 344.20 73.54 144.55 1.0 2011-01-14 624.18 346.99 74.62 145.70 1.0 2011-01-18 639.63 339.19 75.45 146.33 1.0 2011-01-19 631.75 337.39 75.00 151.22 1.0 2011-01-20 626.77 331.26 74.53 151.33 1.0 2011-01-21 611.83 325.32 75.71 151.04 1.0 2011-01-24 611.08 336.01 75.34 155.05 1.0 2011-01-25 619.91 339.94 75.43 156.81 1.0 2011-01-26 616.50 342.38 76.37 156.42 1.0 2011-01-27 616.79 341.74 76.58 156.45 1.0 2011-01-28 600.99 334.66 75.72 154.64 1.0 2011-01-31 600.36 337.87 77.34 157.35 1.0 2011-02-01 611.04 343.55 80.44 158.87 1.0 2011-02-02 612.00 342.85 79.96 158.62 1.0 2011-02-03 610.15 341.97 79.99 158.84 1.0 2011-02-04 610.98 345.02 79.84 159.30 1.0 2011-02-07 614.29 350.38 80.46 160.09 1.0 2011-02-08 618.38 353.68 79.97 161.93 1.0 2011-02-09 616.50 356.63 79.55 160.56 1.0 2011-02-10 616.44 353.02 80.18 160.02 1.0 2011-02-11 624.50 355.32 79.81 159.78 1.0 2011-02-14 628.15 357.64 81.83 159.17 1.0 2011-02-15 624.15 358.36 79.96 158.80 1.0 2011-02-16 624.22 361.58 80.65 159.34 1.0 2011-02-17 625.26 356.77 80.83 160.16 1.0 2011-02-18 630.08 349.06 81.43 160.75 1.0 2011-02-22 610.21 337.16 82.34 157.93 1.0 ... ... ... ... ... ... 2011-06-20 484.58 313.97 77.25 161.64 1.0 2011-06-21 493.00 323.91 78.09 162.82 1.0 2011-06-22 487.01 321.23 77.36 162.29 1.0 2011-06-23 480.22 329.81 76.02 162.72 1.0 2011-06-24 474.88 324.95 74.41 161.69 1.0 2011-06-27 482.80 330.62 75.52 164.19 1.0 2011-06-28 493.65 333.83 77.17 166.53 1.0 2011-06-29 497.57 332.61 77.78 167.05 1.0 2011-06-30 506.38 334.23 78.87 168.04 1.0 2011-07-01 521.03 341.79 79.48 170.97 1.0 2011-07-05 532.44 347.94 79.08 171.84 1.0 2011-07-06 535.36 350.26 79.05 174.07 1.0 2011-07-07 546.60 355.67 79.82 172.87 1.0 2011-07-08 531.99 358.17 79.88 172.88 1.0 2011-07-11 527.28 352.49 79.37 171.41 1.0 2011-07-12 534.01 352.24 79.36 170.49 1.0 2011-07-13 538.26 356.49 79.94 170.75 1.0 2011-07-14 528.94 356.24 79.70 170.66 1.0 2011-07-15 597.62 363.36 80.44 171.95 1.0 2011-07-18 594.94 372.20 80.10 171.69 1.0 2011-07-19 602.55 375.24 81.05 181.42 1.0 2011-07-20 595.35 385.25 80.73 179.89 1.0 2011-07-21 606.99 385.63 82.40 181.11 1.0 2011-07-22 618.23 391.62 82.59 181.39 1.0 2011-07-25 618.98 396.80 81.96 179.94 1.0 2011-07-26 622.52 401.69 81.77 179.19 1.0 2011-07-27 607.22 390.91 80.74 177.64 1.0 2011-07-28 610.94 390.14 78.95 178.08 1.0 2011-07-29 603.69 388.81 77.33 178.13 1.0 2011-08-01 606.77 395.05 77.15 177.05 1.0 [141 rows x 5 columns] 12) create change frame with index and symbols : GOOG AAPL XOM IBM 2011-01-10 NaN NaN NaN NaN 2011-01-11 NaN NaN NaN NaN 2011-01-12 NaN NaN NaN NaN 2011-01-13 NaN NaN NaN NaN 2011-01-14 NaN NaN NaN NaN 2011-01-18 NaN NaN NaN NaN 2011-01-19 NaN NaN NaN NaN 2011-01-20 NaN NaN NaN NaN 2011-01-21 NaN NaN NaN NaN 2011-01-24 NaN NaN NaN NaN 2011-01-25 NaN NaN NaN NaN 2011-01-26 NaN NaN NaN NaN 2011-01-27 NaN NaN NaN NaN 2011-01-28 NaN NaN NaN NaN 2011-01-31 NaN NaN NaN NaN 2011-02-01 NaN NaN NaN NaN 2011-02-02 NaN NaN NaN NaN 2011-02-03 NaN NaN NaN NaN 2011-02-04 NaN NaN NaN NaN 2011-02-07 NaN NaN NaN NaN 2011-02-08 NaN NaN NaN NaN 2011-02-09 NaN NaN NaN NaN 2011-02-10 NaN NaN NaN NaN 2011-02-11 NaN NaN NaN NaN 2011-02-14 NaN NaN NaN NaN 2011-02-15 NaN NaN NaN NaN 2011-02-16 NaN NaN NaN NaN 2011-02-17 NaN NaN NaN NaN 2011-02-18 NaN NaN NaN NaN 2011-02-22 NaN NaN NaN NaN ... ... ... ... ... 2011-06-20 NaN NaN NaN NaN 2011-06-21 NaN NaN NaN NaN 2011-06-22 NaN NaN NaN NaN 2011-06-23 NaN NaN NaN NaN 2011-06-24 NaN NaN NaN NaN 2011-06-27 NaN NaN NaN NaN 2011-06-28 NaN NaN NaN NaN 2011-06-29 NaN NaN NaN NaN 2011-06-30 NaN NaN NaN NaN 2011-07-01 NaN NaN NaN NaN 2011-07-05 NaN NaN NaN NaN 2011-07-06 NaN NaN NaN NaN 2011-07-07 NaN NaN NaN NaN 2011-07-08 NaN NaN NaN NaN 2011-07-11 NaN NaN NaN NaN 2011-07-12 NaN NaN NaN NaN 2011-07-13 NaN NaN NaN NaN 2011-07-14 NaN NaN NaN NaN 2011-07-15 NaN NaN NaN NaN 2011-07-18 NaN NaN NaN NaN 2011-07-19 NaN NaN NaN NaN 2011-07-20 NaN NaN NaN NaN 2011-07-21 NaN NaN NaN NaN 2011-07-22 NaN NaN NaN NaN 2011-07-25 NaN NaN NaN NaN 2011-07-26 NaN NaN NaN NaN 2011-07-27 NaN NaN NaN NaN 2011-07-28 NaN NaN NaN NaN 2011-07-29 NaN NaN NaN NaN 2011-08-01 NaN NaN NaN NaN [141 rows x 4 columns] 13) fill changes with zeros : GOOG AAPL XOM IBM 2011-01-10 0 0 0 0 2011-01-11 0 0 0 0 2011-01-12 0 0 0 0 2011-01-13 0 0 0 0 2011-01-14 0 0 0 0 2011-01-18 0 0 0 0 2011-01-19 0 0 0 0 2011-01-20 0 0 0 0 2011-01-21 0 0 0 0 2011-01-24 0 0 0 0 2011-01-25 0 0 0 0 2011-01-26 0 0 0 0 2011-01-27 0 0 0 0 2011-01-28 0 0 0 0 2011-01-31 0 0 0 0 2011-02-01 0 0 0 0 2011-02-02 0 0 0 0 2011-02-03 0 0 0 0 2011-02-04 0 0 0 0 2011-02-07 0 0 0 0 2011-02-08 0 0 0 0 2011-02-09 0 0 0 0 2011-02-10 0 0 0 0 2011-02-11 0 0 0 0 2011-02-14 0 0 0 0 2011-02-15 0 0 0 0 2011-02-16 0 0 0 0 2011-02-17 0 0 0 0 2011-02-18 0 0 0 0 2011-02-22 0 0 0 0 ... ... ... ... ... 2011-06-20 0 0 0 0 2011-06-21 0 0 0 0 2011-06-22 0 0 0 0 2011-06-23 0 0 0 0 2011-06-24 0 0 0 0 2011-06-27 0 0 0 0 2011-06-28 0 0 0 0 2011-06-29 0 0 0 0 2011-06-30 0 0 0 0 2011-07-01 0 0 0 0 2011-07-05 0 0 0 0 2011-07-06 0 0 0 0 2011-07-07 0 0 0 0 2011-07-08 0 0 0 0 2011-07-11 0 0 0 0 2011-07-12 0 0 0 0 2011-07-13 0 0 0 0 2011-07-14 0 0 0 0 2011-07-15 0 0 0 0 2011-07-18 0 0 0 0 2011-07-19 0 0 0 0 2011-07-20 0 0 0 0 2011-07-21 0 0 0 0 2011-07-22 0 0 0 0 2011-07-25 0 0 0 0 2011-07-26 0 0 0 0 2011-07-27 0 0 0 0 2011-07-28 0 0 0 0 2011-07-29 0 0 0 0 2011-08-01 0 0 0 0 [141 rows x 4 columns] 14) A separae cash series index by prices with zeros: 2011-01-10 0.0 2011-01-11 0.0 2011-01-12 0.0 2011-01-13 0.0 2011-01-14 0.0 2011-01-18 0.0 2011-01-19 0.0 2011-01-20 0.0 2011-01-21 0.0 2011-01-24 0.0 2011-01-25 0.0 2011-01-26 0.0 2011-01-27 0.0 2011-01-28 0.0 2011-01-31 0.0 2011-02-01 0.0 2011-02-02 0.0 2011-02-03 0.0 2011-02-04 0.0 2011-02-07 0.0 2011-02-08 0.0 2011-02-09 0.0 2011-02-10 0.0 2011-02-11 0.0 2011-02-14 0.0 2011-02-15 0.0 2011-02-16 0.0 2011-02-17 0.0 2011-02-18 0.0 2011-02-22 0.0 ... 2011-06-20 0.0 2011-06-21 0.0 2011-06-22 0.0 2011-06-23 0.0 2011-06-24 0.0 2011-06-27 0.0 2011-06-28 0.0 2011-06-29 0.0 2011-06-30 0.0 2011-07-01 0.0 2011-07-05 0.0 2011-07-06 0.0 2011-07-07 0.0 2011-07-08 0.0 2011-07-11 0.0 2011-07-12 0.0 2011-07-13 0.0 2011-07-14 0.0 2011-07-15 0.0 2011-07-18 0.0 2011-07-19 0.0 2011-07-20 0.0 2011-07-21 0.0 2011-07-22 0.0 2011-07-25 0.0 2011-07-26 0.0 2011-07-27 0.0 2011-07-28 0.0 2011-07-29 0.0 2011-08-01 0.0 Length: 141, dtype: float64 15) first value in cash series is amount that we start out with: 2011-01-10 1000000.0 2011-01-11 0.0 2011-01-12 0.0 2011-01-13 0.0 2011-01-14 0.0 2011-01-18 0.0 2011-01-19 0.0 2011-01-20 0.0 2011-01-21 0.0 2011-01-24 0.0 2011-01-25 0.0 2011-01-26 0.0 2011-01-27 0.0 2011-01-28 0.0 2011-01-31 0.0 2011-02-01 0.0 2011-02-02 0.0 2011-02-03 0.0 2011-02-04 0.0 2011-02-07 0.0 2011-02-08 0.0 2011-02-09 0.0 2011-02-10 0.0 2011-02-11 0.0 2011-02-14 0.0 2011-02-15 0.0 2011-02-16 0.0 2011-02-17 0.0 2011-02-18 0.0 2011-02-22 0.0 ... 2011-06-20 0.0 2011-06-21 0.0 2011-06-22 0.0 2011-06-23 0.0 2011-06-24 0.0 2011-06-27 0.0 2011-06-28 0.0 2011-06-29 0.0 2011-06-30 0.0 2011-07-01 0.0 2011-07-05 0.0 2011-07-06 0.0 2011-07-07 0.0 2011-07-08 0.0 2011-07-11 0.0 2011-07-12 0.0 2011-07-13 0.0 2011-07-14 0.0 2011-07-15 0.0 2011-07-18 0.0 2011-07-19 0.0 2011-07-20 0.0 2011-07-21 0.0 2011-07-22 0.0 2011-07-25 0.0 2011-07-26 0.0 2011-07-27 0.0 2011-07-28 0.0 2011-07-29 0.0 2011-08-01 0.0 Length: 141, dtype: float64 16) iterate through sorted series of orders and execute the orders impacts our cash series, and the change frame 2011-01-10: BUYING 1500 AAPL Other costs +2,567.3750 price +511,485.0000 @ +340.9900 Total cash CHANGE is: -514,052.3750 Total cash available: +485,947.6250 2011-01-13: SELLING -1500 AAPL Other costs +2,591.4500 price -516,300.0000 @ +344.2000 Total cash CHANGE is: +513,708.5500 Total cash available: +999,656.1750 2011-01-13: BUYING 4000 IBM Other costs +2,900.9500 price +578,200.0000 @ +144.5500 Total cash CHANGE is: -581,100.9500 Total cash available: +418,555.2250 2011-01-26: BUYING 1000 GOOG Other costs +3,092.4500 price +616,500.0000 @ +616.5000 Total cash CHANGE is: -619,592.4500 Total cash available: -201,037.2250 2011-02-02: SELLING -4000 XOM Other costs +1,609.1500 price -319,840.0000 @ +79.9600 Total cash CHANGE is: +318,230.8500 Total cash available: +117,193.6250 2011-02-10: BUYING 4000 XOM Other costs +1,613.5500 price +320,720.0000 @ +80.1800 Total cash CHANGE is: -322,333.5500 Total cash available: -205,139.9250 2011-03-03: SELLING -1000 GOOG Other costs +3,057.7500 price -609,560.0000 @ +609.5600 Total cash CHANGE is: +606,502.2500 Total cash available: +401,362.3250 2011-03-03: SELLING -2200 IBM Other costs +1,763.5700 price -350,724.0000 @ +159.4200 Total cash CHANGE is: +348,960.4300 Total cash available: +750,322.7550 2011-05-03: BUYING 1500 IBM Other costs +1,274.3000 price +252,870.0000 @ +168.5800 Total cash CHANGE is: -254,144.3000 Total cash available: +496,178.4550 2011-06-03: SELLING -3300 IBM Other costs +2,677.5050 price -533,511.0000 @ +161.6700 Total cash CHANGE is: +530,833.4950 Total cash available: +1,027,011.9500 2011-08-01: BUYING 55 GOOG Other costs +176.8120 price +33,372.3500 @ +606.7700 Total cash CHANGE is: -33,549.1620 Total cash available: +993,462.7880 2011-08-01: SELLING -55 GOOG Other costs +176.8120 price -33,372.3500 @ +606.7700 Total cash CHANGE is: +33,195.5380 Total cash available: +1,026,658.3260 16) append cash to changes: GOOG AAPL XOM IBM _CASH 2011-01-10 0 1500 0 0 485947.625 2011-01-11 0 0 0 0 0.000 2011-01-12 0 0 0 0 0.000 2011-01-13 0 -1500 0 4000 -67392.400 2011-01-14 0 0 0 0 0.000 2011-01-18 0 0 0 0 0.000 2011-01-19 0 0 0 0 0.000 2011-01-20 0 0 0 0 0.000 2011-01-21 0 0 0 0 0.000 2011-01-24 0 0 0 0 0.000 2011-01-25 0 0 0 0 0.000 2011-01-26 1000 0 0 0 -619592.450 2011-01-27 0 0 0 0 0.000 2011-01-28 0 0 0 0 0.000 2011-01-31 0 0 0 0 0.000 2011-02-01 0 0 0 0 0.000 2011-02-02 0 0 -4000 0 318230.850 2011-02-03 0 0 0 0 0.000 2011-02-04 0 0 0 0 0.000 2011-02-07 0 0 0 0 0.000 2011-02-08 0 0 0 0 0.000 2011-02-09 0 0 0 0 0.000 2011-02-10 0 0 4000 0 -322333.550 2011-02-11 0 0 0 0 0.000 2011-02-14 0 0 0 0 0.000 2011-02-15 0 0 0 0 0.000 2011-02-16 0 0 0 0 0.000 2011-02-17 0 0 0 0 0.000 2011-02-18 0 0 0 0 0.000 2011-02-22 0 0 0 0 0.000 ... ... ... ... ... ... 2011-06-20 0 0 0 0 0.000 2011-06-21 0 0 0 0 0.000 2011-06-22 0 0 0 0 0.000 2011-06-23 0 0 0 0 0.000 2011-06-24 0 0 0 0 0.000 2011-06-27 0 0 0 0 0.000 2011-06-28 0 0 0 0 0.000 2011-06-29 0 0 0 0 0.000 2011-06-30 0 0 0 0 0.000 2011-07-01 0 0 0 0 0.000 2011-07-05 0 0 0 0 0.000 2011-07-06 0 0 0 0 0.000 2011-07-07 0 0 0 0 0.000 2011-07-08 0 0 0 0 0.000 2011-07-11 0 0 0 0 0.000 2011-07-12 0 0 0 0 0.000 2011-07-13 0 0 0 0 0.000 2011-07-14 0 0 0 0 0.000 2011-07-15 0 0 0 0 0.000 2011-07-18 0 0 0 0 0.000 2011-07-19 0 0 0 0 0.000 2011-07-20 0 0 0 0 0.000 2011-07-21 0 0 0 0 0.000 2011-07-22 0 0 0 0 0.000 2011-07-25 0 0 0 0 0.000 2011-07-26 0 0 0 0 0.000 2011-07-27 0 0 0 0 0.000 2011-07-28 0 0 0 0 0.000 2011-07-29 0 0 0 0 0.000 2011-08-01 0 0 0 0 -353.624 [141 rows x 5 columns] 17) compute the holding everyday (same as) cumulative sum (cumsum): GOOG AAPL XOM IBM _CASH 2011-01-10 0.0 1500.0 0.0 0.0 485947.625 2011-01-11 0.0 1500.0 0.0 0.0 485947.625 2011-01-12 0.0 1500.0 0.0 0.0 485947.625 2011-01-13 0.0 0.0 0.0 4000.0 418555.225 2011-01-14 0.0 0.0 0.0 4000.0 418555.225 2011-01-18 0.0 0.0 0.0 4000.0 418555.225 2011-01-19 0.0 0.0 0.0 4000.0 418555.225 2011-01-20 0.0 0.0 0.0 4000.0 418555.225 2011-01-21 0.0 0.0 0.0 4000.0 418555.225 2011-01-24 0.0 0.0 0.0 4000.0 418555.225 2011-01-25 0.0 0.0 0.0 4000.0 418555.225 2011-01-26 1000.0 0.0 0.0 4000.0 -201037.225 2011-01-27 1000.0 0.0 0.0 4000.0 -201037.225 2011-01-28 1000.0 0.0 0.0 4000.0 -201037.225 2011-01-31 1000.0 0.0 0.0 4000.0 -201037.225 2011-02-01 1000.0 0.0 0.0 4000.0 -201037.225 2011-02-02 1000.0 0.0 -4000.0 4000.0 117193.625 2011-02-03 1000.0 0.0 -4000.0 4000.0 117193.625 2011-02-04 1000.0 0.0 -4000.0 4000.0 117193.625 2011-02-07 1000.0 0.0 -4000.0 4000.0 117193.625 2011-02-08 1000.0 0.0 -4000.0 4000.0 117193.625 2011-02-09 1000.0 0.0 -4000.0 4000.0 117193.625 2011-02-10 1000.0 0.0 0.0 4000.0 -205139.925 2011-02-11 1000.0 0.0 0.0 4000.0 -205139.925 2011-02-14 1000.0 0.0 0.0 4000.0 -205139.925 2011-02-15 1000.0 0.0 0.0 4000.0 -205139.925 2011-02-16 1000.0 0.0 0.0 4000.0 -205139.925 2011-02-17 1000.0 0.0 0.0 4000.0 -205139.925 2011-02-18 1000.0 0.0 0.0 4000.0 -205139.925 2011-02-22 1000.0 0.0 0.0 4000.0 -205139.925 ... ... ... ... ... ... 2011-06-20 0.0 0.0 0.0 0.0 1027011.950 2011-06-21 0.0 0.0 0.0 0.0 1027011.950 2011-06-22 0.0 0.0 0.0 0.0 1027011.950 2011-06-23 0.0 0.0 0.0 0.0 1027011.950 2011-06-24 0.0 0.0 0.0 0.0 1027011.950 2011-06-27 0.0 0.0 0.0 0.0 1027011.950 2011-06-28 0.0 0.0 0.0 0.0 1027011.950 2011-06-29 0.0 0.0 0.0 0.0 1027011.950 2011-06-30 0.0 0.0 0.0 0.0 1027011.950 2011-07-01 0.0 0.0 0.0 0.0 1027011.950 2011-07-05 0.0 0.0 0.0 0.0 1027011.950 2011-07-06 0.0 0.0 0.0 0.0 1027011.950 2011-07-07 0.0 0.0 0.0 0.0 1027011.950 2011-07-08 0.0 0.0 0.0 0.0 1027011.950 2011-07-11 0.0 0.0 0.0 0.0 1027011.950 2011-07-12 0.0 0.0 0.0 0.0 1027011.950 2011-07-13 0.0 0.0 0.0 0.0 1027011.950 2011-07-14 0.0 0.0 0.0 0.0 1027011.950 2011-07-15 0.0 0.0 0.0 0.0 1027011.950 2011-07-18 0.0 0.0 0.0 0.0 1027011.950 2011-07-19 0.0 0.0 0.0 0.0 1027011.950 2011-07-20 0.0 0.0 0.0 0.0 1027011.950 2011-07-21 0.0 0.0 0.0 0.0 1027011.950 2011-07-22 0.0 0.0 0.0 0.0 1027011.950 2011-07-25 0.0 0.0 0.0 0.0 1027011.950 2011-07-26 0.0 0.0 0.0 0.0 1027011.950 2011-07-27 0.0 0.0 0.0 0.0 1027011.950 2011-07-28 0.0 0.0 0.0 0.0 1027011.950 2011-07-29 0.0 0.0 0.0 0.0 1027011.950 2011-08-01 0.0 0.0 0.0 0.0 1026658.326 [141 rows x 5 columns] 18) compute the portfolue value (multiply * holdings): GOOG AAPL XOM IBM _CASH 2011-01-10 0.0 511485.0 0.0 0.0 485947.625 2011-01-11 0.0 510270.0 0.0 0.0 485947.625 2011-01-12 0.0 514425.0 0.0 0.0 485947.625 2011-01-13 0.0 0.0 0.0 578200.0 418555.225 2011-01-14 0.0 0.0 0.0 582800.0 418555.225 2011-01-18 0.0 0.0 0.0 585320.0 418555.225 2011-01-19 0.0 0.0 0.0 604880.0 418555.225 2011-01-20 0.0 0.0 0.0 605320.0 418555.225 2011-01-21 0.0 0.0 0.0 604160.0 418555.225 2011-01-24 0.0 0.0 0.0 620200.0 418555.225 2011-01-25 0.0 0.0 0.0 627240.0 418555.225 2011-01-26 616500.0 0.0 0.0 625680.0 -201037.225 2011-01-27 616790.0 0.0 0.0 625800.0 -201037.225 2011-01-28 600990.0 0.0 0.0 618560.0 -201037.225 2011-01-31 600360.0 0.0 0.0 629400.0 -201037.225 2011-02-01 611040.0 0.0 0.0 635480.0 -201037.225 2011-02-02 612000.0 0.0 -319840.0 634480.0 117193.625 2011-02-03 610150.0 0.0 -319960.0 635360.0 117193.625 2011-02-04 610980.0 0.0 -319360.0 637200.0 117193.625 2011-02-07 614290.0 0.0 -321840.0 640360.0 117193.625 2011-02-08 618380.0 0.0 -319880.0 647720.0 117193.625 2011-02-09 616500.0 0.0 -318200.0 642240.0 117193.625 2011-02-10 616440.0 0.0 0.0 640080.0 -205139.925 2011-02-11 624500.0 0.0 0.0 639120.0 -205139.925 2011-02-14 628150.0 0.0 0.0 636680.0 -205139.925 2011-02-15 624150.0 0.0 0.0 635200.0 -205139.925 2011-02-16 624220.0 0.0 0.0 637360.0 -205139.925 2011-02-17 625260.0 0.0 0.0 640640.0 -205139.925 2011-02-18 630080.0 0.0 0.0 643000.0 -205139.925 2011-02-22 610210.0 0.0 0.0 631720.0 -205139.925 ... ... ... ... ... ... 2011-06-20 0.0 0.0 0.0 0.0 1027011.950 2011-06-21 0.0 0.0 0.0 0.0 1027011.950 2011-06-22 0.0 0.0 0.0 0.0 1027011.950 2011-06-23 0.0 0.0 0.0 0.0 1027011.950 2011-06-24 0.0 0.0 0.0 0.0 1027011.950 2011-06-27 0.0 0.0 0.0 0.0 1027011.950 2011-06-28 0.0 0.0 0.0 0.0 1027011.950 2011-06-29 0.0 0.0 0.0 0.0 1027011.950 2011-06-30 0.0 0.0 0.0 0.0 1027011.950 2011-07-01 0.0 0.0 0.0 0.0 1027011.950 2011-07-05 0.0 0.0 0.0 0.0 1027011.950 2011-07-06 0.0 0.0 0.0 0.0 1027011.950 2011-07-07 0.0 0.0 0.0 0.0 1027011.950 2011-07-08 0.0 0.0 0.0 0.0 1027011.950 2011-07-11 0.0 0.0 0.0 0.0 1027011.950 2011-07-12 0.0 0.0 0.0 0.0 1027011.950 2011-07-13 0.0 0.0 0.0 0.0 1027011.950 2011-07-14 0.0 0.0 0.0 0.0 1027011.950 2011-07-15 0.0 0.0 0.0 0.0 1027011.950 2011-07-18 0.0 0.0 0.0 0.0 1027011.950 2011-07-19 0.0 0.0 0.0 0.0 1027011.950 2011-07-20 0.0 0.0 0.0 0.0 1027011.950 2011-07-21 0.0 0.0 0.0 0.0 1027011.950 2011-07-22 0.0 0.0 0.0 0.0 1027011.950 2011-07-25 0.0 0.0 0.0 0.0 1027011.950 2011-07-26 0.0 0.0 0.0 0.0 1027011.950 2011-07-27 0.0 0.0 0.0 0.0 1027011.950 2011-07-28 0.0 0.0 0.0 0.0 1027011.950 2011-07-29 0.0 0.0 0.0 0.0 1027011.950 2011-08-01 0.0 0.0 0.0 0.0 1026658.326 [141 rows x 5 columns] 19) sum the rows you got the value of portfolio!: 2011-01-10 997432.625 2011-01-11 996217.625 2011-01-12 1000372.625 2011-01-13 996755.225 2011-01-14 1001355.225 2011-01-18 1003875.225 2011-01-19 1023435.225 2011-01-20 1023875.225 2011-01-21 1022715.225 2011-01-24 1038755.225 2011-01-25 1045795.225 2011-01-26 1041142.775 2011-01-27 1041552.775 2011-01-28 1018512.775 2011-01-31 1028722.775 2011-02-01 1045482.775 2011-02-02 1043833.625 2011-02-03 1042743.625 2011-02-04 1046013.625 2011-02-07 1050003.625 2011-02-08 1063413.625 2011-02-09 1057733.625 2011-02-10 1051380.075 2011-02-11 1058480.075 2011-02-14 1059690.075 2011-02-15 1054210.075 2011-02-16 1056440.075 2011-02-17 1060760.075 2011-02-18 1067940.075 2011-02-22 1036790.075 ... 2011-06-20 1027011.950 2011-06-21 1027011.950 2011-06-22 1027011.950 2011-06-23 1027011.950 2011-06-24 1027011.950 2011-06-27 1027011.950 2011-06-28 1027011.950 2011-06-29 1027011.950 2011-06-30 1027011.950 2011-07-01 1027011.950 2011-07-05 1027011.950 2011-07-06 1027011.950 2011-07-07 1027011.950 2011-07-08 1027011.950 2011-07-11 1027011.950 2011-07-12 1027011.950 2011-07-13 1027011.950 2011-07-14 1027011.950 2011-07-15 1027011.950 2011-07-18 1027011.950 2011-07-19 1027011.950 2011-07-20 1027011.950 2011-07-21 1027011.950 2011-07-22 1027011.950 2011-07-25 1027011.950 2011-07-26 1027011.950 2011-07-27 1027011.950 2011-07-28 1027011.950 2011-07-29 1027011.950 2011-08-01 1026658.326 Length: 141, dtype: float64 --- end student code ------------------------------------------------ portfolio values: 2011-01-10 997432.625 2011-01-11 996217.625 2011-01-12 1000372.625 2011-01-13 996755.225 2011-01-14 1001355.225 2011-01-18 1003875.225 2011-01-19 1023435.225 2011-01-20 1023875.225 2011-01-21 1022715.225 2011-01-24 1038755.225 2011-01-25 1045795.225 2011-01-26 1041142.775 2011-01-27 1041552.775 2011-01-28 1018512.775 2011-01-31 1028722.775 2011-02-01 1045482.775 2011-02-02 1043833.625 2011-02-03 1042743.625 2011-02-04 1046013.625 2011-02-07 1050003.625 2011-02-08 1063413.625 2011-02-09 1057733.625 2011-02-10 1051380.075 2011-02-11 1058480.075 2011-02-14 1059690.075 2011-02-15 1054210.075 2011-02-16 1056440.075 2011-02-17 1060760.075 2011-02-18 1067940.075 2011-02-22 1036790.075 ... 2011-06-20 1027011.950 2011-06-21 1027011.950 2011-06-22 1027011.950 2011-06-23 1027011.950 2011-06-24 1027011.950 2011-06-27 1027011.950 2011-06-28 1027011.950 2011-06-29 1027011.950 2011-06-30 1027011.950 2011-07-01 1027011.950 2011-07-05 1027011.950 2011-07-06 1027011.950 2011-07-07 1027011.950 2011-07-08 1027011.950 2011-07-11 1027011.950 2011-07-12 1027011.950 2011-07-13 1027011.950 2011-07-14 1027011.950 2011-07-15 1027011.950 2011-07-18 1027011.950 2011-07-19 1027011.950 2011-07-20 1027011.950 2011-07-21 1027011.950 2011-07-22 1027011.950 2011-07-25 1027011.950 2011-07-26 1027011.950 2011-07-27 1027011.950 2011-07-28 1027011.950 2011-07-29 1027011.950 2011-08-01 1026658.326 Length: 141, dtype: float64 --- begin statistic ------------------------------------------------- Date Range: 2011-01-10 to 2011-08-01 (portfolio) Date Range: 2011-01-10 to 2011-12-20 (on web page) Number of Trading Days: 141 Sharpe Ratio of Fund: +0.62764356583 Average Daily Return of Fund: +0.00022201372 Final Portfolio Value: +1,026,658.32600000012 XX solution 3 141 +0.62764356583 +0.00022201372 +1,026,658.32600000012