Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |