Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
zmr325
 
Posts: n/a
Default What is the best way to Write this Formula

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to write the formula using INDEX? gipsassignment Excel Discussion (Misc queries) 2 October 2nd 05 12:30 PM
Can you help me write this formula? blazon Excel Discussion (Misc queries) 6 September 20th 05 07:07 PM
How do I write formula to compare two values and pull the resulta. Renee Excel Worksheet Functions 1 February 11th 05 01:31 AM
how do i write a formula and keep in in formula form, so it DOESN. norcalchick2207 Excel Discussion (Misc queries) 2 February 4th 05 08:38 PM
How do I write my formula to automatically regenerate a RAND () i. Regi Excel Worksheet Functions 1 December 8th 04 10:06 PM


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"