Spreadsheet: 58126d1258453094-formula-for-multiple-conditions-stochastics
Sheet: Sheet1

EMDZ9-FUT-GLOBEX  0.5 rng - #1 |  |  | Formula Source Sheet #1.  Enter and modify formulas for this sheet on Sheet1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Preferred Stochastic -DiNapoli |  |  |  |  | EMDZ9-FUT-GLOBEX  1.0 rng - #2 Preferred Stochastic -DiNapoli |  |  |  |  | EMDZ9-FUT-GLOBEX  89 vol - #3 Preferred Stochastic -DiNapoli |  |  |  |  | EMDZ9-FUT-GLOBEX  144 vol - #4 Preferred Stochastic -DiNapoli |  |  |  |  | EMDZ9-FUT-GLOBEX  144 tick - #5 Preferred Stochastic -DiNapoli |  |  |  |  | EMDZ9-FUT-GLOBEX  233 tick - #6 Preferred Stochastic -DiNapoli
Date Time | Open | High | Low | Last | Volume | # of Trades |  |  |  | Buy Entry | [NAME] (Sell) | Sell Entry | [NAME] (Buy) |  |  |  |  |  |  |  |  |  |  |  |  | %K | %D | Line1 | Line2 |  | %K | %D | Line1 | Line2 |  | %K | %D | Line1 | Line2 |  | %K | %D | Line1 | Line2 |  | %K | %D | Line1 | Line2 |  | %K | %D | Line1 | Line2
2009-11-17 10:03:39 | 707.5 | 707.5 | 707.2999877929688 | 707.2999877929688 | 2 | 2 |  | Working Orders Quantity: | 0 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 78.70992279052734 | 66.92987060546875 | 70 | 30 |  | 75.27259826660156 | 64.4137191772461 | 70 | 30 |  | 76.46794128417969 | 58.16958236694336 | 70 | 30 |  | 61.75448989868164 | 39.96388626098633 | 70 | 30 |  | 65.93704223632812 | 78.29730987548828 | 70 | 30 |  | 65.93704223632812 | 78.29730987548828 | 70 | 30
2009-11-17 09:46:50 | 707.7999877929688 | 708.0999755859375 | 707.5999755859375 | 708.0999755859375 | 9 | 7 |  | Session Position with Working Orders Quantity: | 0 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 84.08610534667969 | 61.03984451293945 | 70 | 30 |  | 75.27259826660156 | 64.4137191772461 | 70 | 30 |  | 76.46794128417969 | 58.16958236694336 | 70 | 30 |  | 61.75448989868164 | 39.96388626098633 | 70 | 30 |  | 65.93704223632812 | 78.29730987548828 | 70 | 30 |  | 65.93704223632812 | 78.29730987548828 | 70 | 30
2009-11-17 09:33:00 | 707.0999755859375 | 707.5999755859375 | 707.0999755859375 | 707.0999755859375 | 3 | 1 |  | Session Position Quantity: | 0 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68.17221069335938 | 49.5167121887207 | 70 | 30 |  | 77.2114486694336 | 58.98427581787109 | 70 | 30 |  | 76.46794128417969 | 58.16958236694336 | 70 | 30 |  | 61.75448989868164 | 39.96388626098633 | 70 | 30 |  | 65.93704223632812 | 78.29730987548828 | 70 | 30 |  | 65.93704223632812 | 78.29730987548828 | 70 | 30
2009-11-17 09:30:00 | 707.5 | 707.7000122070312 | 707.2000122070312 | 707.2999877929688 | 16 | 9 |  | Session Position Quantity with Working Exit Orders: | 0 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59.42242813110352 | 40.18896102905273 | 70 | 30 |  | 77.2114486694336 | 58.98427581787109 | 70 | 30 |  | 76.46794128417969 | 58.16958236694336 | 70 | 30 |  | 61.75448989868164 | 39.96388626098633 | 70 | 30 |  | 87.4976806640625 | 95.54496002197266 | 70 | 30 |  | 87.4976806640625 | 95.54496002197266 | 70 | 30
2009-11-17 09:15:00 | 705.7000122070312 | 706.2000122070312 | 705.7000122070312 | 706.0999755859375 | 30 | 2 |  |  |  | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34.23019409179688 | 30.57222557067871 | 70 | 30 |  | 54.42289733886719 | 49.87068939208984 | 70 | 30 |  | 73.98826599121094 | 49.02040481567383 | 70 | 30 |  | 61.75448989868164 | 39.96388626098633 | 70 | 30 |  | 69.75933837890625 | 45.5633430480957 | 70 | 30 |  | 69.75933837890625 | 45.5633430480957 | 70 | 30
2009-11-17 09:13:00 | 705.0999755859375 | 705.5999755859375 | 705.0999755859375 | 705.0999755859375 | 4 | 1 |  | Session Position Quantity: | 0 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.90633964538574 | 28.74324035644531 | 70 | 30 |  | 52.59638977050781 | 47.59458541870117 | 70 | 30 |  | 73.98826599121094 | 49.02040481567383 | 70 | 30 |  | 61.75448989868164 | 39.96388626098633 | 70 | 30 |  | 12.36843395233154 | 30.43867874145508 | 70 | 30 |  | 12.36843395233154 | 30.43867874145508 | 70 | 30
2009-11-17 08:57:30 | 705.9000244140625 | 706.0999755859375 | 705.5999755859375 | 706 | 38 | 9 |  | Session Position Average Price: | 0 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.81267929077148 | 36.66168975830078 | 70 | 30 |  | 48.94337463378906 | 45.09368515014648 | 70 | 30 |  | 73.98826599121094 | 49.02040481567383 | 70 | 30 |  | 61.75448989868164 | 39.96388626098633 | 70 | 30 |  | 29.06797027587891 | 40.32395553588867 | 70 | 30 |  | 29.06797027587891 | 40.32395553588867 | 70 | 30
2009-11-17 08:53:00 | 705.9000244140625 | 706.2999877929688 | 705.7999877929688 | 706.2999877929688 | 18 | 9 |  | Session Open Profit/Loss: | 0 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30.57171058654785 | 42.08619689941406 | 70 | 30 |  | 48.94337463378906 | 45.09368515014648 | 70 | 30 |  | 73.98826599121094 | 49.02040481567383 | 70 | 30 |  | 44.56135559082031 | 29.06858253479004 | 70 | 30 |  | 24.99961853027344 | 63.75580978393555 | 70 | 30 |  | 24.99961853027344 | 63.75580978393555 | 70 | 30
2009-11-17 08:13:00 | 706.4000244140625 | 706.5 | 706 | 706.0999755859375 | 81 | 5 |  | Session Cumulative Profit/Loss: | 0 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31.73186683654785 | 47.84343719482422 | 70 | 30 |  | 49.31497192382812 | 43.16884231567383 | 70 | 30 |  | 47.97652816772461 | 36.53647613525391 | 70 | 30 |  | 44.56135559082031 | 29.06858253479004 | 70 | 30 |  | 58.32802581787109 | 72.82149505615234 | 70 | 30 |  | 58.32802581787109 | 72.82149505615234 | 70 | 30
2009-11-17 08:10:30 | 706.7999877929688 | 706.9000244140625 | 706.4000244140625 | 706.4000244140625 | 7 | 5 |  | Bid: | 707.0999755859375 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45.81752014160156 | 55.89921951293945 | 70 | 30 |  | 49.31497192382812 | 43.16884231567383 | 70 | 30 |  | 51.83572769165039 | 30.81645011901855 | 70 | 30 |  | 44.56135559082031 | 29.06858253479004 | 70 | 30 |  | 71.20301818847656 | 80.06822967529297 | 70 | 30 |  | 71.20301818847656 | 80.06822967529297 | 70 | 30
2009-11-17 08:00:30 | 705.7999877929688 | 706.2999877929688 | 705.7999877929688 | 706.0999755859375 | 12 | 6 |  | Bid Size: | 3 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51.56787872314453 | 63.2405891418457 | 70 | 30 |  | 52.91460800170898 | 40.09577941894531 | 70 | 30 |  | 51.83572769165039 | 30.81645011901855 | 70 | 30 |  | 40.47454833984375 | 21.32219696044922 | 70 | 30 |  | 42.49858856201172 | 56.6689338684082 | 70 | 30 |  | 42.49858856201172 | 56.6689338684082 | 70 | 30
2009-11-17 07:32:00 | 706.2999877929688 | 706.2999877929688 | 705.7999877929688 | 705.7999877929688 | 57 | 4 |  | Ask: | 707.2999877929688 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64.00670623779297 | 69.07694244384766 | 70 | 30 |  | 52.91460800170898 | 40.09577941894531 | 70 | 30 |  | 51.83572769165039 | 30.81645011901855 | 70 | 30 |  | 40.47454833984375 | 21.32219696044922 | 70 | 30 |  | 0.2794508337974548 | 5.893773078918457 | 70 | 30 |  | 0.2794508337974548 | 5.893773078918457 | 70 | 30
2009-11-17 07:25:30 | 706.9000244140625 | 706.9000244140625 | 706.4000244140625 | 706.7000122070312 | 15 | 4 |  | Ask [NAME]: | 1 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81.13858795166016 | 71.612060546875 | 70 | 30 |  | 43.32921600341797 | 33.68636322021484 | 70 | 30 |  | 40.81396484375 | 20.30681228637695 | 70 | 30 |  | 40.47454833984375 | 21.32219696044922 | 70 | 30 |  | 17.88485336303711 | 52.43202972412109 | 70 | 30 |  | 17.88485336303711 | 52.43202972412109 | 70 | 30
2009-11-17 07:23:30 | 706.7999877929688 | 707.2999877929688 | 706.7999877929688 | 707.2999877929688 | 10 | 6 |  | Daily Open: | 707.0999755859375 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87.27670288085938 | 66.84880065917969 | 70 | 30 |  | 43.32921600341797 | 33.68636322021484 | 70 | 30 |  | 40.81396484375 | 20.30681228637695 | 70 | 30 |  | 40.47454833984375 | 21.32219696044922 | 70 | 30 |  | 35.76970672607422 | 69.70561981201172 | 70 | 30 |  | 35.76970672607422 | 69.70561981201172 | 70 | 30
2009-11-17 07:17:00 | 707.2999877929688 | 707.5 | 707 | 707.4000244140625 | 14 | 4 |  | Daily High: | 708.0999755859375 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80.80375671386719 | 56.63485336303711 | 70 | 30 |  | 43.32921600341797 | 33.68636322021484 | 70 | 30 |  | 40.81396484375 | 20.30681228637695 | 70 | 30 |  | 40.47454833984375 | 21.32219696044922 | 70 | 30 |  | 96.37615966796875 | 97.44927215576172 | 70 | 30 |  | 96.37615966796875 | 97.44927215576172 | 70 | 30
2009-11-17 07:14:00 | 706.7000122070312 | 707.2000122070312 | 706.7000122070312 | 706.7000122070312 | 6 | 1 |  | Daily Low: | 704.2999877929688 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64.73173522949219 | 44.5504035949707 | 70 | 30 |  | 37.67858123779297 | 28.86493682861328 | 70 | 30 |  | 40.81396484375 | 20.30681228637695 | 70 | 30 |  | 40.47454833984375 | 21.32219696044922 | 70 | 30 |  | 99.57325744628906 | 95.65483093261719 | 70 | 30 |  | 99.57325744628906 | 95.65483093261719 | 70 | 30
2009-11-17 07:00:30 | 706 | 706.5 | 706 | 706.0999755859375 | 27 | 1 |  | Daily Net: | -0.5 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46.70470428466797 | 34.45973587036133 | 70 | 30 |  | 37.67858123779297 | 28.86493682861328 | 70 | 30 |  | 40.81396484375 | 20.30681228637695 | 70 | 30 |  | 40.47454833984375 | 21.32219696044922 | 70 | 30 |  | 72.72651672363281 | 86.86831665039062 | 70 | 30 |  | 72.72651672363281 | 86.86831665039062 | 70 | 30
2009-11-17 06:59:30 | 706.2000122070312 | 706.4000244140625 | 705.9000244140625 | 705.9000244140625 | 4 | 4 |  | Daily Volume: | 197 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41.98118209838867 | 28.33724975585938 | 70 | 30 |  | 37.67858123779297 | 28.86493682861328 | 70 | 30 |  | 24.48507690429688 | 10.05323505401611 | 70 | 30 |  | 23.44940567016602 | 11.74602127075195 | 70 | 30 |  | 81.81767272949219 | 93.93921661376953 | 70 | 30 |  | 81.81767272949219 | 93.93921661376953 | 70 | 30
2009-11-17 06:59:30 | 705.7000122070312 | 706.2000122070312 | 705.7000122070312 | 706.2000122070312 | 0 | 0 |  | [NAME]: | 0.1000000014901161 | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38.24703216552734 | 21.51528358459473 | 70 | 30 |  | 26.37731552124023 | 24.45811462402344 | 70 | 30 |  | 24.48507690429688 | 10.05323505401611 | 70 | 30 |  | 23.44940567016602 | 11.74602127075195 | 70 | 30 |  | 81.81767272949219 | 93.93921661376953 | 70 | 30 |  | 81.81767272949219 | 93.93921661376953 | 70 | 30
2009-11-17 06:34:30 | 705.2000122070312 | 705.7000122070312 | 705.2000122070312 | 705.7000122070312 | 74 | 26 |  | Limit - Buy Entry (K): |  | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22.20764923095703 | 13.1494083404541 | 70 | 30 |  | 26.37731552124023 | 24.45811462402344 | 70 | 30 |  | 24.48507690429688 | 10.05323505401611 | 70 | 30 |  | 23.44940567016602 | 11.74602127075195 | 70 | 30 |  | 100 | 99.99999237060547 | 70 | 30 |  | 100 | 99.99999237060547 | 70 | 30
2009-11-17 05:42:00 | 704.2999877929688 | 704.7999877929688 | 704.2999877929688 | 704.2999877929688 | 105 | 1 |  | Limit - Buy Exit (L): |  | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.41459846496582 | 8.620287895202637 | 70 | 30 |  | 15.01869773864746 | 23.49851417541504 | 70 | 30 |  | 0.3983769714832306 | 2.837314367294312 | 70 | 30 |  | 23.44940567016602 | 11.74602127075195 | 70 | 30 |  | 0.08790254592895508 | 3.039670705795288 | 70 | 30 |  | 0.08790254592895508 | 3.039670705795288 | 70 | 30
2009-11-17 05:32:30 | 705.0999755859375 | 705.0999755859375 | 704.5999755859375 | 704.5999755859375 | 25 | 8 |  | Limit - Sell Entry (M): |  | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.82919692993164 | 10.72313213348389 | 70 | 30 |  | 15.01869773864746 | 23.49851417541504 | 70 | 30 |  | 0.7967539429664612 | 4.056783199310303 | 70 | 30 |  | 1.899114727973938 | 5.894328594207764 | 70 | 30 |  | 22.5030517578125 | 57.65322875976562 | 70 | 30 |  | 22.5030517578125 | 57.65322875976562 | 70 | 30
2009-11-17 05:05:18 | 706 | 706 | 705.5 | 706 | 31 | 7 |  | Limit - Sell Exit (N): |  | #[NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.65839385986328 | 11.67010021209717 | 70 | 30 |  | 11.16942882537842 | 27.73842239379883 | 70 | 30 |  | 0.7967539429664612 | 4.056783199310303 | 70 | 30 |  | 1.899114727973938 | 5.894328594207764 | 70 | 30 |  | 92.5018310546875 | 96.38976287841797 | 70 | 30 |  | 92.5018310546875 | 96.38976287841797 | 70 | 30