Support Board
Date/Time: Thu, 16 Jan 2025 13:51:05 +0000
Post From: If loss, then ONLY enter in Opposite direction
| [2017-10-31 12:43:35] |
| User29926 - Posts: 92 |
|
This is a quick code block. I did not test it, so your mileage may vary. You may/will need to modify it to fit your spreadsheet. **In an H cell place this code relating to a SEll: **ASSUMING THAT ITS THE $H$4 CELL =IF(AND($J$44< 0,$J$7< 0),1, IF(J$8 > 0,0,IF(ISBLANK($H$4),0,$H$4))) **In an H cell place this code relating to a BUY: **ASSUMING THAT ITS THE $H$5 CELL =IF(AND($J$44< 0,$J$7> 0),1, IF(J$8 < 0,0,IF(ISBLANK($H$5),0,$H$5))) **IN $M$3 SELL ENTRY ADD TO YOUR ENTRY CODE: $H$4=0 **IN $K$3 BUY ENTRY CELL ADD TO YOUR ENTRY CODE: $H$5=0 |