What is the best way to Write this Formula
Same questions as before.
And can you stop repeating teh question, and sending more questions targeted
at individuals. Post the question and await a response, this is a voluntary
forum.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"zmr325" wrote in message
...
THank you to all that have helped and to who will help, i greatly
appreciate
it. Here is my question. I have four columns of data:b is OPEN, C is
HIGH,
D is LOW and D is CLOSE. I then wrote an =if(and)) statement with about
six
logical steps to come up with the words "BUY" and "SELL" in columns f and
g
respectfully. Then in column H I wrote a buy stop formula which is
=if(f2="BUY",e2-6.00,""). Worked great got my new number now what I need
to
write is and this is the hard part IF at any time that the LOW(column d)
from
that period on until the period where you get a "SELL" signal goes below
or
equal to that number you need to get out of that position. I thank you
for
your help. I hope this isn't to confusing.
NOel
|