Spreadsheet: 33165d1229452415-circular-reference-question-ptps-almost-finished
Sheet: PTPS

PARABOLIC TIME/ PRICE SYSTEM
 |  |  |  |  | SHORT | LONG | LONG | SHORT |  |  |  | ENTRY | ENTRY
DATE | OPEN | HIGH | LOW | CLOSE | SAR | SAR | EP | EP | EP +- SAR | AF | AF X DIFF | POSITION | AMOUNT | EXIT | P/L | ACCUM
4 |  | 52.35 | 51.5 |  |  | 50 | 52.35 |  | 2.350000000000001 | 0.02 | 0.04700000000000003 | LONG | 52.2 |  |  |  |  | THIS WORKS FINE IN COLUMN F
5 |  | 52.1 | 51 |  |  | 50.047 | 52.35 |  | 2.303000000000004 | 0.02 | 0.04606000000000009 | LONG | 52.2
6 |  | 51.8 | 50.5 |  |  | 50.09305999999999 | 52.35 |  | 2.256940000000007 | 0.02 | 0.04513880000000015 | LONG | 52.2 |  |  |  |  | IF(AND(M5<>M4,M5="SHORT"),MAX(INDEX(C$3:C4,MATCH(2,INDEX(1/(M$3:M4<>"long"),0))+1):C4),IF(M4="SHORT",F4-L4," "))
7 |  | 52.1 | 51.25 |  |  | 50.1381988 | 52.35 |  | 2.211801200000004 | 0.02 | 0.04423602400000008 | LONG | 52.2
8 |  | 52.5 | 51.7 |  |  | 50.182434824 | 52.5 |  | 2.317565176000002 | 0.04 | 0.09270260704000009 | LONG | 52.2 |  |  |  |  | THIS DOESN'T WORK IN COLUMN G
9 |  | 52.8 | 51.85 |  |  | 50.27513743104 | 52.8 |  | 2.524862568959996 | 0.06 | 0.1514917541375998 | LONG | 52.2
10 |  | 52.5 | 51.5 |  |  | 50.4266291851776 | 52.8 |  | 2.373370814822394 | 0.06 | 0.1424022488893436 | LONG | 52.2 |  |  |  |  | IF(AND(M5<>M4,M5="LONG"),MIN(INDEX(D$3:D4,MATCH(2,INDEX(1/(M$3:E4<>"short"),0))+1):D4),IF(M4="LONG",G4+L4," "))
11 |  | 53.5 | 52.3 |  |  | 50.56903143406695 | 53.5 |  | 2.93096856593305 | 0.08 | 0.234477485274644 | LONG | 52.2
12 |  | 53.5 | 52.5 |  |  | 50.8035089193416 | 53.5 |  | 2.696491080658404 | 0.08 | 0.2157192864526724 | LONG | 52.2 |  |  |  |  | I CANT FIGURE OUT WHY I'M GETTING A CIRCULAR REFERENCE IN G AND NOT COLUMN F.
13 |  | 53.8 | 53 |  |  | 51.01922820579427 | 53.8 |  | 2.780771794205727 | 0.1 | 0.2780771794205727 | LONG | 52.2
14 |  | 54.2 | 53.5 |  |  | 51.29730538521484 | 54.2 |  | 2.902694614785162 | 0.12 | 0.3483233537742194 | LONG | 52.2
15 |  | 53.4 | 52.5 |  |  | 51.64562873898906 | 54.2 |  | 2.554371261010942 | 0.12 | 0.3065245513213131 | LONG | 52.2
16 |  | 53.5 | 52.1 |  |  | 51.95215329031037 | 54.2 |  | 2.247846709689632 | 0.12 | 0.2697416051627559 | LONG | 52.2
17 |  | 54.4 | 53 |  |  | 52.22189489547313 | 54.4 |  | 2.178105104526871 | 0.14 | 0.304934714633762 | LONG | 52.2
18 |  | 55.2 | 54 |  |  | 52.52682961010689 | 55.2 |  | 2.673170389893116 | 0.16 | 0.4277072623828985 | LONG | 52.2
19 |  | 55.7 | 55 |  |  | 52.95453687248978 | 55.7 |  | 2.74546312751022 | 0.18 | 0.4941833629518396 | LONG | 52.2
20 |  | 57 | 56 |  |  | 53.44872023544162 | 57 |  | 3.55127976455838 | 0.2 | 0.710255952911676 | LONG | 52.2
21 |  | 57.5 | 56.5 |  |  | 54.15897618835329 | 57.5 |  | 3.341023811646707 | 0.2 | 0.6682047623293415 | LONG | 52.2
22 |  | 58 | 57 |  |  | 54.82718095068263 | 58 |  | 3.172819049317368 | 0.2 | 0.6345638098634737 | LONG | 52.2
23 |  | 57.7 | 56.5 |  |  | 55.4617447605461 | 58 |  | 2.538255239453896 | 0.2 | 0.5076510478907793 | LONG | 52.2
24 |  | 58 | 57.3 |  |  | 55.96939580843689 | 58 |  | 2.030604191563114 | 0.2 | 0.4061208383126229 | LONG | 52.2
25 |  | 57.5 | 56.7 |  |  | 56.37551664674951 | 58 |  | 1.62448335325049 | 0.2 | 0.324896670650098 | LONG | 52.2
26 |  | 57 | 56.3 |  | 58 | 56.70041331739961 |  | 56.3 | 1.700000000000003 | 0.02 | 0.03400000000000006 | SHORT | 56.70041331739961 | 56.70041331739961 | 4.500413317399605
27 |  | 56.7 | 56.2 |  | 57.966 |  |  | 56.2 | 1.765999999999998 | 0.04 | 0.07063999999999993 | SHORT | 56.70041331739961 | 56.70041331739961
28 |  | 57.5 | 56 |  | 57.89536 |  |  | 56 | 1.895360000000004 | 0.06 | 0.1137216000000002 | SHORT | 56.70041331739961 | 56.70041331739961
29 |  | 56.7 | 55.5 |  | 57.78163840000001 |  |  | 55.5 | 2.281638400000006 | 0.08 | 0.1825310720000005 | SHORT | 56.70041331739961 | 56.70041331739961
30 |  | 56 | 55 |  | 57.599107328 |  |  | 55 | 2.599107328000002 | 0.1 | 0.2599107328000003 | SHORT | 56.70041331739961 | 56.70041331739961
31 |  | 56.2 | 54.9 |  | 57.3391965952 |  |  | 54.9 | 2.439196595200002 | 0.12 | 0.2927035914240003 | SHORT | 56.70041331739961 | 56.70041331739961
32 |  | 54.8 | 54 |  | 57.046493003776 |  |  | 54 | 3.046493003776 | 0.14 | 0.42650902052864 | SHORT | 56.70041331739961 | 56.70041331739961
33 |  | 55.5 | 54.5 |  | 56.61998398324736 |  |  | 54 | 2.619983983247359 | 0.14 | 0.3667977576546302 | SHORT | 56.70041331739961 | 56.70041331739961
34 |  | 54.7 | 53.8 |  | 56.25318622559273 |  |  | 53.8 | 2.453186225592731 | 0.16 | 0.3925097960948369 | SHORT | 56.70041331739961 | 56.70041331739961
35 |  | 54 | 53 |  | 55.86067642949789 |  |  | 53 | 2.860676429497893 | 0.18 | 0.5149217573096208 | SHORT | 56.70041331739961 | 56.70041331739961
36 |  | 52.5 | 51.5 |  | 55.34575467218827 |  |  | 51.5 | 3.845754672188271 | 0.2 | 0.769150934437654 | SHORT | 56.70041331739961 | 56.70041331739961
37 |  | 51 | 50 |  | 54.57660373775062 |  |  | 50 | 4.576603737750617 | 0.2 | 0.9153207475501234 | SHORT | 56.70041331739961 | 56.70041331739961
38 |  | 51.5 | 50.5 |  | 53.66128299020049 |  |  | 50 | 3.66128299020049 | 0.2 | 0.7322565980400981 | SHORT | 56.70041331739961 | 56.70041331739961
39 |  | 51.7 | 50.2 |  | 52.9290263921604 | 50 | 51.7 |  | 1.700000000000003 | 0.02 | 0.03400000000000006 | LONG | 52.9290263921604 | 52.9290263921604 | 3.771386925239213
40 |  | 53 | 51.5 |  |  | 50.034