Spreadsheet: 52881d1252690010-first-in-first-out-fifo-accounting-for-equity-trades-book-cost-fifo-test
Sheet: Sheet2

 | Values
Row Labels | Sum of TradeQuantity | 0.903 | Trading Activity | Current Position | Sum of BaseCost |  | px close 2d | px yest close | MKT Value | Unrealized
AKS | -117390 | -130000 | 4515 | -112875 | -2347605.179 | 19.99834039526365 | 20.91 | 21.21 | -2394078.75 | -46473.571 | -34892.2 |  | AKS equity
 | -117390 |  |  | -117390 | -2443043.52 | 20.81134270380782 | 20.91 |  | -2454624.9 | -11581.37999999989 | -34892.19100000011
 |  |  |  | -67725 |  | 21.87 | -1481145.75 |  |  | -86190.2 | -39716.629
 |  |  |  | -45150 | -985567.61 | 21.8287399778516 | -952649.63 | 21.09965957918051
APA | 22575 | 25000 |  | 25000 | 1979573.77 | 87.68876057585825 |  | 87.46 | 1974409.5 | -5164.270000000251 |  |  | APA equity
APC | 22575 | 25000 |  | 25000 | 1236113.09 | 54.75584008859358 |  | 56.34 | 1271875.5 | 35762.40999999992 |  |  | APC equity
CAM | -54180 | -60000 |  | -60000 | -1910960.926 | 31.84934876666667 |  | 36.78 | -1992740.4 | -81779.47400000016 |  |  | CAM equity
CAT | -45150 | -50000 |  | -50000 | -2035328.019 | 40.70656038 |  | 48.41 | -2185711.5 | -150383.4810000001 |  |  | CAT equity
CCK | 63210 | 70000 |  | 70000 | 1599420.606 | 22.8488658 |  | 24.76 | 1565079.6 | -34341.00600000005 |  |  | CCK equity
CLF | -117390 | -130000 |  | -130000 | -3149798.46 | 24.22921892307692 |  | 26.68 | -3131965.2 | 17833.25999999978 |  |  | CLF equity
COP | -49665 | -55000 |  | -55000 | -2200837.316 | 40.01522392727273 |  | 45.83 | -2276146.95 | -75309.63399999961 |  |  | COP equity
CP | -49665 | -55000 |  | -55000 | -2394833.22 | 43.54242218181818 |  | 48.78 | -2422658.7 | -27825.47999999998 |  |  | CP equity
DE | -135450 | -150000 |  | -150000 | -5832750.393999999 | 38.88500262666666 |  | 43.01 | -5825704.5 | 7045.893999999389 |  |  | DE equity
DHR | 54180 | 60000 |  | 60000 | 3344661.87 | 55.7443645 |  | 66.57 | 3606762.6 | 262100.7299999995 |  |  | DHR equity
DO | -45150 | -50000 |  | -50000 | -4077921.061 | 81.55842122 |  | 91 | -4108650 | -30728.93900000025 |  |  | DO equity
DOV | -45150 | -50000 |  | -50000 | -1497782.363 | 29.95564726 |  | 36.42 | -1644363 | -146580.6370000001 |  |  | DOV equity
DVN | -45150 | -50000 |  | -50000 | -2804593.795 | 56.0918759 |  | 63.73 | -2877409.5 | -72815.70500000007 |  |  | DVN equity
ECA | -22575 | -25000 |  | -25000 | -1202547.45 | 48.10189800000001 |  | 53.44 | -1206408 | -3860.549999999814 |  |  | ECA equity
EMR | -45150 | -50000 |  | -50000 | -1597580.834 | 31.95161668 |  | 38.78 | -1750917 | -153336.1660000002 |  |  | [NAME] equity
FCX | -22575 | -25000 |  | -25000 | -1478348.716 | 59.13394864 |  | 67.68 | -1527876 | -49527.28400000022 |  |  | FCX equity
FLR | -49665 | -55000 |  | -55000 | -2719966.15 | 49.45393 |  | 53.44 | -2654097.6 | 65868.54999999981 |  |  | FLR equity
FTI | -31605 | -35000 |  | -35000 | -1458245.657 | 41.66416162857143 |  | 49.75 | -1572348.75 | -114103.0929999999 |  |  | FTI equity
CBE | 27090 | 30000 |  | 30000 | 929426.29 | 30.98087633333333 |  | 35.5 | 961695 | 32268.70999999996 |  |  | CBE equity
GE | 632100 | 700000 |  | 700000 | 8715258.405000001 | 12.45036915 |  | 14.87 | 9399327 | 684068.5949999988 |  |  | GE equity
HAL | 90300 | 100000 |  | 100000 | 2146957.199 | 21.46957199 |  | 24.94 | 2252082 | 105124.801 |  |  | HAL equity
HLX | -90300 | -100000 |  | -100000 | -1143238.95 | 11.4323895 |  | 13.33 | -1203699 | -60460.05000000005 |  |  | HLX equity
ITW | 45150 | 50000 |  | 50000 | 1908542.885 | 38.17085769999999 |  | 43.93 | 1983439.5 | 74896.61500000022 |  |  | ITW equity
JEC | 45150 | 50000 |  | 50000 | 1835155.215 | 40.64574119601329 |  | 46.42 | 2095863 | 260707.7849999999 |  |  | JEC equity
MDR | 22575 | 25000 |  | 25000 | 560028.865 | 22.4011546 |  | 26.66 | 601849.5 | 41820.63500000001 |  |  | MDR equity
MT | -45150 | -50000 |  | -50000 | -1647683.437 | 32.95366874 |  | 37.89 | -1710733.5 | -63050.06300000008 |  |  | MT equity
NBR | 90300 | 100000 |  | 100000 | 1577526.654 | 15.77526654 |  | 18.55 | 1675065 | 97538.3459999999 |  |  | NBR equity
NSC | 31605 | 35000 |  | 35000 | 1471000.55 | 42.02858714285714 |  | 48.39 | 1529365.95 | 58365.39999999991 |  |  | NSC equity
RIG | 22575 | 25000 |  | 25000 | 1735426.637 | 69.41706547999999 |  | 79.94 | 1804645.5 | 69218.86300000013 |  |  | RIG equity
RRC | -54180 | -60000 |  | -60000 | -2632655.11 | 43.87758516666666 |  | 49.03 | -2656445.4 | -23790.29000000004 |  |  | RRC equity
SD | 117390 | 130000 |  | 130000 | 1200015.17 | 9.230885923076922 |  | 12.28 | 1441549.2 | 241534.03 |  |  | SD equity
SFY | 27090 | 30000 |  | 30000 | 488454.368 | 16.28181226666667 |  | 21.64 | 586227.6 | 97773.23199999996 |  |  | SFY equity
SII | -90300 | -100000 |  | -100000 | -2435776.62 | 24.3577662 |  | 27.24 | -2459772 | -23995.37999999989 |  |  | SII equity
SLB | 45150 | 50000 |  | 50000 | 2523705.68 | 50.4741136 |  | 57.36 | 2589804 | 66098.3200000003 |  |  | SLB equity
SPY | -4515 | -5000 |  | -5000 | -468396.635 | 93.679327 |  | 103.73 | -468340.95 | 55.68499999999767 |  |  | SPY equity
STLD | 270899 | 299998.8925802879 |  | 299998.8925802879 | 4503221.390000001 | 15.01079337749493 |  | 17.27 | 4678425.73 | 175204.3399999989 |  |  | STLD equity
SWN | 90300 | 100000 |  | 100000 | 3474196.763 | 34.74196763 |  | 39.65 | 3580395 | 106198.2370000002 |  |  | SWN equity
TEX | 81270 | 90000 |  | 90000 | 1256909.56 | 13.96566177777778 |  | 17.5 | 1422225 | 165315.4399999999 |  |  | TEX equity
URS | 22575 | 25000 |  | 25000 | 964587.672 | 38.58350688 |  | 44.28 | 999621 | 35033.32799999998 |  |  | URS equity
UTX | 22575 | 25000 |  | 25000 | 1295039.738 | 51.80158951999999 |  | 61.24 | 1382493 | 87453.2620000001 |  |  | UTX equity
X | 67725 | 75000 |  | 75000 | 2911722.521 | 38.82296694666666 |  | 44.3 | 3000217.5 | 88494.97900000028 |  |  | X equity
 |  |  |  |  |  |  |  |  |  | 1712256.373999996
 |  |  |  |  |  |  |  |  |  | 1712256.37
AKS |  | 0 |  |  |  |  |  | 0 |  | 0.003999996231868863
APA |  | 0 |  |  |  |  |  | 0
APA |  | 30000 |  |  |  |  |  | 88.219307 | 2646579.21
APA |  | 5000 |  |  |  |  |  | 88.192 | 440959.9999999999
GE |  | -25000 |  |  |  |  |  | 14.6 | -365000 | -53740.77124999993
GE |  | -25000 |  |  |  |  |  | 14.6012 | -365030 | -53770.77124999993
 |  | 9030 |  |  |  |  |  | 21.09360022 | 190475.2099866 | 180585.0137692307 | 9890.19621736923
 |  | -4515 |  |  |  |  |  | -21.06125802879291 | 95091.58 | -90292.50688461537 | 185384.0868846154
 |  | 4515 |  |  |  |  |  | 63.24845846879291 | 285566.7899866 |  | 195274.2831019846
 |  |  |  |  |  |  |  | -9030 | -190475.21 | -190529.93
 |  |  |  |  |  |  |  |  | 21.09360022148394 | 21.0996600221484
 |  |  |  |  |  |  |  |  | 21.0886