Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to write the formula using INDEX? | Excel Discussion (Misc queries) | |||
Can you help me write this formula? | Excel Discussion (Misc queries) | |||
How do I write formula to compare two values and pull the resulta. | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
How do I write my formula to automatically regenerate a RAND () i. | Excel Worksheet Functions |