Spreadsheet: 194696d1353300580-conditional-formulas-for-stock-picking-scenarios-stock
Sheet: Sheet1

 |  |  | oscillator
 | PX_LAST | oscillator | differential
2012-11-19 00:00:00 | 0.675 | -97.57575988769531 | -51.15151807665825
2012-11-16 00:00:00 | 0.775 | -90.3030276298523 | -75.63636228442192
2012-11-15 00:00:00 | 0.825 | -64.84848260879517 | -82.66666576266289
2012-11-14 00:00:00 | 1.375 | -10.3030301630497 | -56.9696980714798 |  | need to create a formula that buys the stock ( price in column b when)
2012-11-13 00:00:00 | 1.33 | 30.90909123420715 | -29.33333396911621 |  | buy when oscillator (B) moves below 90
2012-11-12 00:00:00 | 1.91 | 61.21212244033813 | 2.18181848526001 |  | and sell when reaches above 90 or differential (column c)  becomes less than zero, which
2012-11-09 00:00:00 | 2.015 | 72.12121486663818 | 29.09091114997864 |  | ever comes first
2012-11-08 00:00:00 | 2.51 | 79.39394116401672 | 65.45454740524292
2012-11-07 00:00:00 | 3.06 | 57.57575631141663 | 77.81818151473999
2012-11-06 00:00:00 | 2.675 | 24.84848499298096 | 74.6666669845581
2012-11-05 00:00:00 | 2.24 | -18.78787875175476 | 43.87878835201263
2012-11-02 00:00:00 | 1.385 | -73.33333492279053 | -14.78787992149591
2012-11-01 00:00:00 | 0.91 | -91.51515364646912 | -53.81818387657404
2012-10-31 00:00:00 | 1.225 | -90.3030276298523 | -80.72727058082819
2012-10-30 00:00:00 | 1.255 | -39.39394056797028 | -60.36363754421473
2012-10-29 00:00:00 | 1.33 | 1.81818176060915 | -38.78787860274315
2012-10-26 00:00:00 | 1.21 | 30.90909123420715 | -18.42424213886261
2012-10-25 00:00:00 | 1.71 | 49.09090995788574 | -2.424241304397583
2012-10-24 00:00:00 | 1.665 | 62.42424249649048 | 15.27272760868073
2012-10-23 00:00:00 | 2.015 | 58.78787636756897 | 18.66666436195374
2012-10-22 00:00:00 | 2.025 | 45.45454680919647 | 7.757576704025269
2012-10-19 00:00:00 | 2.93 | 41.81818068027496 | -2.181819081306458
2012-10-18 00:00:00 | 2.635 | 27.27272808551788 | -24.48484778404236
2012-10-17 00:00:00 | 1.175 | 27.27272808551788 | -33.21211993694305
2012-10-16 00:00:00 | 0.905 | 46.66666686534882 | -20.60606002807617
2012-10-15 00:00:00 | 1.175 | 76.96969509124756 | 10.66666543483734
2012-10-12 00:00:00 | 1.405 | 80.60606122016907 | 32.24242508411407
2012-10-11 00:00:00 | 1.095 | 70.90908885002136 | 49.69696819782257
2012-10-10 00:00:00 | 1.29 | 61.21212244033813 | 72.0000010728836
2012-10-09 00:00:00 | 1.28 | 41.81818068027496 | 82.90908932685852
2012-10-08 00:00:00 | 1.055 | -12.72727251052856 | 54.78787779808044
2012-10-05 00:00:00 | 1.125 | -55.15151619911194 | 29.33333158493042
2012-10-04 00:00:00 | 0.84 | -89.09090757369995 | 3.393939733505249
2012-10-03 00:00:00 | 0.83 | -90.3030276298523 | 1.939395666122437
2012-10-02 00:00:00 | 0.97 | -90.3030276298523 | -3.393937349319458
2012-10-01 00:00:00 | 0.85 | -97.57575988769531 | -22.5454568862915
2012-09-28 00:00:00 | 0.85 | -95.15151381492615 | -44.3636354804039
2012-09-27 00:00:00 | 1.01 | -87.87878751754761 | -69.33333367109299
2012-09-26 00:00:00 | 0.865 | -63.63636255264282 | -79.51515048742294
2012-09-25 00:00:00 | 1.175 | -30.90909123420715 | -78.78787845373154
2012-09-24 00:00:00 | 1.545 | 23.63636344671249 | -49.69696879386902
2012-09-21 00:00:00 | 2.07 | 66.06060862541199 | -21.33332967758179
2012-09-20 00:00:00 | 2.2 | 84.2424213886261 | -8.242425918579102
2012-09-19 00:00:00 | 2.865 | 96.36363387107849 | 3.393937349319458
2012-09-18 00:00:00 | 2.605 | 96.36363387107849 | 5.090906620025635
2012-09-17 00:00:00 | 2.84 | 93.9393937587738 | 4.606059789657593
2012-09-14 00:00:00 | 2.33 | 91.51515364646912 | 4.121214151382446
2012-09-13 00:00:00 | 1.665 | 86.66666746139526 | 2.181819677352905
2012-09-12 00:00:00 | 1.705 | 87.87878751754761 | 7.757576704025269
2012-09-11 00:00:00 | 1.52 | 86.66666746139526 | 14.3030321598053
2012-09-10 00:00:00 | 1.585 | 84.2424213886261 | 23.03030133247375
2012-09-07 00:00:00 | 0.91 | 76.96969509124756 | 33.21211993694305
2012-09-06 00:00:00 | 0.57 | 64.84848260879517 | 45.57575583457947
2012-09-05 00:00:00 | 0.475 | 49.09090995788574 | 62.78787970542908
2012-09-04 00:00:00 | 0.615 | 30.90909123420715 | 74.42424297332764
2012-09-03 00:00:00 | 0.515 | -3.030303120613098 | 66.66666686534882
2012-08-31 00:00:00 | 0.535 | -45.45454680919647 | 43.63636255264282