Sure gonna send it now - its actually a template so its blank.
I have highlighted the cells in yellow:
Sorry about this loooooonggg explanation - just wanted to try and make things clearer if i could:
C4 is where the user will select the currency pair
BP4 is where i wanted to paste a MAX formula which will take its value from YOUR formula that you are helping me with
BQ4 is where i wanted to paste a MIN formula which will take its value from YOUR formula that you are helping me with
K4 should be what triggers YOUR formula to kick off AND also triggers off and enters formulas into BP4 and BQ4
BO4 should be what STOPS your formula and returns fixed values into BP4 and BQ4 based on current figure in those cells
The only problem is that you will need to have MT4 (metatrader) on your machine i think for you to be able to see the =MT4|BID!EURUSDm formula work (i could be wrong though).
(to make matters worse)
i also wanted to include in the formula another IF scenario whereby it looks at column E to see if user is entering into a Buy or Sell. I will try to explain further.
I was planning to use the MAX formula,
assuming user is entering into a BUY, to create the HIGH value in Cell BP4 and the MIN formula to create the LOW value in Cell BQ4.
However, if user is entering into a SELL, then i need to reverse those and use the MAX formula to create the LOW in cell BQ4 and then the MIN formula to create the HIGH in cell BP4. I hope that this makes sense...
Do you think its better if i try to do all this in VB instead?
You see - to make matters EVEN worse
)))))
Once user enters Open Price into K4, for example, thats when i really wanted the BP4 and BQ4 cells to get filled. Something like - user hits returns after entering price in K4 and then userform comes up telling them that prices will be collected live.
Once user enters CLOSE price into BO4, then i wanted BP4 and BQ4 to now be filled with FIXED values (based on the last figures) and the MAX and MIN formulas to stop.
wooooooooaaahhhh.
Sorry about all this.
Just thought by explaining the whole thing - it might make more sense.
Ok gonna send the file now - its a .rar.
cheers a million for this...