Quote from armchairtrader:
Ok good!
I had the worksheet figure O-L and H-L
Then compare each and put the longest in LD and shortest in SD
Which gave me this:
SD
0.002
0.0024
0.0004
0.0016
0.0022
0.0019
0.0024
0.0002
0.0002
0
0.0026
0.0021
0.0062
0.0029
0.0031
0.0004
0.0012
0.0017
0.0012
0.0046
0.001
LD
0.0038
0.0078
0.0143
0.0071
0.0091
0.0035
0.0029
0.0096
0.0006
0.0009
0.0038
0.0077
0.0222
0.0042
0.0042
0.004
0.0034
0.0047
0.004
0.0052
0.0185
Now from what you have told me I need to take any number in the SD that is greater than the lowest in the LD AND transfer that number to the LD column (I hope I got this right)
Lowest in LD is 0.004 so anything greater than that in SD goes into the LD column?
If so here is what I have for a tally of LD and SD:
SD
0.002
0.0002
0.0002
0
0.001
LD
0.0038
0.0078
0.0143
0.0071
0.0091
0.0035
0.0029
0.0096
0.0006
0.0009
0.0038
0.0077
0.0222
0.0042
0.0042
0.004 lowest in LD
0.0034
0.0047
0.004
0.0052
0.0185
0.0026
0.0021
0.0062
0.0029
0.0031
0.0004
0.0012
0.0017
0.0012
0.0046
0.0024
0.0004
0.0016
0.0022
0.0019
0.0024
Is this correct?