Spreadsheet: 102082d1300133259-adding-additional-criterial-to-statement-test
Sheet: Live Trades

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-14 15:54:02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | -0.03
 | Ticker | Position | Days | Trade % Δ: Open | Trailing Stop: Open | Target Position % Δ: Open | Basket % Δ: Open | Trade % Δ: Close | Trailing Stop: Close | Target Position % Δ: Close | Basket % Δ: Close | Daily % Δ Live | Daily % Δ Static | Cumulative % Δ Static: Open | Cumulative % Δ Static: Close | Position Open?: Open | Position Open?: Close | Trade Code |  | Ticker | Position | Days | Trade % Δ: Open | Trailing Stop: Open | Target Position % Δ: Open | Basket % Δ: Open | Trade % Δ: Close | Trailing Stop: Close | Target Position % Δ: Close | Basket % Δ: Close | Daily % Δ Live | Daily % Δ Static | Cumulative % Δ Static: Open | Cumulative % Δ Static: Close | Position Open?: Open | Position Open?: Close | Trade Code |  |  | Trailing Stop | 0.02
1 | WEC | Short | 49 | 0.0001407090139709799 |  | 0.01087325857968061 | 0.01101396759365159 | 0.0004636991706801728 |  | 0.01190476190476183 | 0.012368461075442 | 0.0135032126417806 | 0.004033140229960167 | -0.01336250362780962 | -0.01304924406494291 | Yes | Yes | Non Event | 1 | WEC | Short | 49 | 0.0001407090139709799 |  | 0.01087325857968061 | 0.01101396759365159 | 0.0004636991706801728 |  | 0.01190476190476183 | 0.012368461075442 | 0.0135032126417806 | 0.004033140229960167 | -0.01336250362780962 | -0.01304924406494291 | Yes | Yes | Non Event |  |  | Lock In Profit | 0.03
2 | SWX | Short | 48 | 0.008148263992973553 |  | 0.03443600867678948 | 0.04258427266976303 | -0.00324097941122143 |  | 0.05009633911368017 | 0.04685535970245874 | 0.004727723290750996 | 0.0074591513758962 | 0.003420540702222558 | -0.008404717434054104 | Yes | Yes | Non Event | 2 | SWX | Short | 48 | 0.008148263992973553 |  | 0.03443600867678948 | 0.04258427266976303 | -0.00324097941122143 |  | 0.05009633911368017 | 0.04685535970245874 | 0.004727723290750996 | 0.0074591513758962 | 0.003420540702222558 | -0.008404717434054104 | Yes | Yes | Non Event
3 | CIM | Long | 37 | -0.0155095040348516 |  | 0.02179176755447939 | 0.03730127158933099 | -0.01804795634280563 |  | 0.01932367149758456 | 0.03737162784039019 | -0.002844460335205978 | -0.008887567082947849 | -0.01266504369964563 | -0.01522891865701755 | Yes | No | Non Event | 3 | CIM | Long | 37 | -0.0155095040348516 |  | 0.02179176755447939 | 0.03730127158933099 | -0.01804795634280563 |  | 0.01932367149758456 | 0.03737162784039019 | -0.002844460335205978 | -0.008887567082947849 | -0.01266504369964563 | -0.01522891865701755 | Yes | No | Non Event
4 | SPH | Short | 35 | 0.008576713309999349 |  | -0.03192046049188903 | -0.02334374718188969 | 0.01987150238866056 | 0.01067347343317036 | -0.05063291139240508 | -0.03076140900374451 | 0.003244609338151182 | 0.005686001639739144 | 0.005332103971848167 | 0.01702234175685693 | Yes | No | Non Event | 4 | SPH | Short | 35 | 0.008576713309999349 |  | -0.03192046049188903 | -0.02334374718188969 | 0.01987150238866056 |  | -0.05063291139240508 | -0.03076140900374451 | 0.003244609338151182 | 0.005686001639739144 | 0.005332103971848167 | 0.01702234175685693 | Yes | Yes | Non Event |  |  | Holidays |  | Ticker Lookup | WEC
5 | LLTC | Short | 19 | -0.01708906855195938 |  | -0.05895756194816293 | -0.07604663050012231 | -0.00933174063160657 |  | -0.05976095617529884 | -0.06909269680690541 | 0.007350785964390191 | -0.004635247875770972 | -0.02443985451634957 | -0.0164673911901861 | No | Yes | Non Event | 5 | LLTC | Short | 19 | -0.01708906855195938 |  | -0.05895756194816293 | -0.07604663050012231 | -0.00933174063160657 |  | -0.05976095617529884 | -0.06909269680690541 | 0.007350785964390191 | -0.004635247875770972 | -0.02443985451634957 | -0.0164673911901861 | No | Yes | Non Event |  |  | 2010-01-01 00:00:00 |  | Total Stocks
6 | ADI | Long | 19 | 0.00204602170696852 |  | -0.08150734408861059 | -0.08355336579557911 | 0.006679632289736406 |  | -0.06963414634146334 | -0.07631377863119974 | 0.003242153889982446 | -0.003520091990343373 | -0.001196132183013926 | 0.003390097755742873 | Yes | No | Earnings | 6 | ADI | Long | 19 | 0.00204602170696852 |  | -0.08150734408861059 | -0.08355336579557911 | 0.006679632289736406 |  | -0.06963414634146334 | -0.07631377863119974 | 0.003242153889982446 | -0.003520091990343373 | -0.001196132183013926 | 0.003390097755742873 | Yes | Yes | Earnings |  |  | 2010-01-18 00:00:00 |  | # Data Points
7 | GSIC | Short | 15 | 0.1065857344630144 | 0.09563079269684255 | -0.1479472954230235 | -0.04136156096000912 | 0.09756300836046253 | 0.0866269020262879 | -0.1244703087885986 | -0.02690730042813608 | -0.01221033482035598 | 0.004326965769644975 | 0.1187960692833704 | 0.1098628926975045 | No | No | Non Event | 7 | GSIC | Short | 15 | 0.1065857344630144 | 0.0987960692833704 | -0.1479472954230235 | -0.04136156096000912 | 0.09756300836046253 | 0.0898628926975045 | -0.1244703087885986 | -0.02690730042813608 | -0.01221033482035598 | 0.004326965769644975 | 0.1187960692833704 | 0.1098628926975045 | No | No | Non Event |  |  | 2010-02-15 00:00:00 |  | ColumnOffset
8 | MCP | Long | 15 | 0.006765348636385095 | 0.07776428590919825 | -0.02792581539117449 | -0.03469116402755958 | 0.01728189637331149 | 0.09100707218073179 | 0.0006583278472679643 | -0.01662356852604352 | -0.03754431712544027 | -0.02052614929102275 | 0.04430966576182536 | 0.05621703142212341 | No | No | Non Event | 8 | MCP | Long | 15 | 0.006765348636385095 | 0.05218979545355408 | -0.02792581539117449 | -0.03469116402755958 | 0.01728189637331149 | 0.064728358495465 | 0.0006583278472679643 | -0.01662356852604352 | -0.03754431712544027 | -0.02052614929102275 | 0.04430966576182536 | 0.05621703142212341 | No | No | Non Event |  |  | 2010-04-02 00:00:00
9 | CPN | Long | 15 | 0.03645254725269646 | 0.02637291077063954 | 0.04377104377104379 | 0.007318496518347341 | 0.048387046611045 | 0.03833720533588678 | 0.05442176870748305 | 0.006034722096438047 | 0.02675717877342074 | 0.008886767585328897 | 0.009695368479275716 | 0.02159928220078594 | No | No | Earnings | 9 | CPN | Long | 15 | 0.03645254725269646 |  | 0.04377104377104379 | 0.007318496518347341 | 0.048387046611045 | 0.0178261971728125 | 0.05442176870748305 | 0.006034722096438047 | 0.02675717877342074 | 0.008886767585328897 | 0.009695368479275716 | 0.02159928220078594 | Yes | No | Earnings |  |  | 2010-05-31 00:00:00
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-05 00:00:00
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-09-06 00:00:00
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-11-25 00:00:00
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-12-24 00:00:00
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-17 00:00:00
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-21 00:00:00
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-04-22 00:00:00
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-05-30 00:00:00
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-04 00:00:00
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-05 00:00:00
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-24 00:00:00
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-26 00:00:00
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41
42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43
44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47
48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48
49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49
50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50