kombinasi GA + RS BUY = GARS BUY =IF(AND(GA>0,RS=1),C,0) sisipkan VO kombinasi GA + VO + RS BUY = GAVORS BUY
=IF(AND(GA>0,VO>1,RS=1),C,0) ganti GA dgn GB kombinasi GB + VO + RS BUY = GBVORS BUY =IF(AND(GB>0,VO>1,RS=1),C,0) ganti GB dgn EMB kombinasi EMB + VO + RS BUY = EMBVORS BUY =IF(AND(EMB>0,VO>1,RS=1),C,0) tambahkan TS kombinasi TS + EMB + VO + RS BUY = EMBVORS BUY =IF(AND(TS>0,EMB>0,VO>1,RS=1),C,0) cukup banyak kombinasi yg bisa dilakukan.. silahkan dicoba bagi yg serius saja. ________________________________ From: tsunamizawa tsunamizawa <[email protected]> To: "[email protected]" <[email protected]> Cc: "[email protected]" <[email protected]> Sent: Saturday, May 26, 2012 11:04 PM Subject: Re: [gainhunter] TIPS sorting dgn EXCEL lupa masukkan operator AND kombinasi GA + RS BUY = GARS BUY =IF(AND(GA>0,RS=1),C,0) kombinasi GA + RS SELL = GARS SELL =if(AND(GA>0.RS=-1),C,0) ________________________________ From: tsunamizawa tsunamizawa <[email protected]> To: "[email protected]" <[email protected]> Cc: "[email protected]" <[email protected]> Sent: Saturday, May 26, 2012 10:09 PM Subject: [gainhunter] TIPS sorting dgn EXCEL kombinasi GA + RS BUY = GARS BUY =IF(GA>0,RS=1,C,0) kombinasi GA + RS SELL = GARS SELL =if(GA>0.RS=-1,C,0) di EXCEL anda tinggal ganti GA RS C sesuai posisi CELL, lalu copy dari atas ke bawah dan anda tinggal lihat saja yg TRUE. dgn cara yg sama jika anda mau kombinas GA + VO + RS ( BUY ) =GAVORS BUY di EXCEL anda bisa masukkan logical TEST hingga 30 ( antara logical TEST ada koma ). silahkan dicoba pada IDXBU0525 bagi yg serius saja..
