Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 06:22:26 +0000
Post From: Count number of long entries #CREF circular reference error
| [2018-03-08 06:44:46] |
| User701453 - Posts: 176 |
|
Im trying to count the number of long entries, as I do not want to have more then two trades per valid signal. Until there is a short entry taken. I am able to count the long entries using the P column and below code: =IF(AND($K$3=1,$J$8=0),($P$3 + 1), IF( OR( $M$3,$H$35 <> 0), 0 ,IF(ISBLANK($P$3),0 ,$P$3)))
However I get a #CREF circular reference error when I try to reference the $P$3 value in the K3 Buy Entry cell. =AND($J$8=0,ID38.SG1@3<>0,$P$3<2)
Any assistance is needed to get this to work correctly. |