Support Board
Date/Time: Tue, 21 Jan 2025 03:24:35 +0000
Post From: Help with spreadsheet EXIT - ( close all remaining )
| [2018-05-22 13:48:49] |
| User651753 - Posts: 77 |
|
I currently have a spreadsheet system working with entry correctly it will enter 2 Contract @$300 if it starts going agents me it will check if the original requirements matches - it will open another position 2 @ $200 ( so on until it hit the max contract limit) So now I have 4 contracts with avg price of $250 so L3 and N3 are ```=if($j$9>0,1,0)``` J23 and J25 ( H3 has profit target of $20 ) ```=if(J8>0,Mroundown(j9+h3),0)``` The spreadsheet work at the avg price I have to enter ... and place a limit order now at $20 higher than my average entry at $250 however, because I am using J26 with a contract of 2 ... it will only place a limit (take profit) of 2 contracts @ $270 leaving another 2 contract open. How can I make it close all 4 contract at $270 leaving me with ZERO contract open? ( same goes for if it then buys 2 more contracts at $100 now my avg price is $200 i want to sell all 6 at $220) |