Slightly different DDE question

[slimimi]

Hi there.

I am using the following formula in a cell to get the High Price of EUR/USD for that day (forex, quotes from MT4) :

=MT4|HIGH!EURUSD


Now - on my spreadsheet. Users are required to enter the Highest price met for the duration of their trade AND the lowest Price met for the duration of their trade.

I have 2 problems:

The HIGH price quoted (using the formula above) is not necessarily going to be the Highest Price during (users) trade. Example, that high price might have been hit well before user even enters into a trade.

So - i have figured a workaround (i think) but just need a bit of help to implement this.

I need to write this in VB code.

(1)

Once a user enters into a Trade - i will need the following formula pasted
into column active Cell row + column BP. However - this formula needs to change depending on what the user selected in Active Cell row + Column C.
Example, JPY/USD or EUR/GBP or EUR/USD, etc, etc.

(2)

Since i need to grab the Highest & Lowest point reached during that particular trade. What VB code can i use to look at the cell's Highest Value reached (since this will always be changing) and then store that data and (also) for the cell's lowest value reached and then store that?

So now we have the entry point fixed because the formula for getting the live quotes ONLY gets entered into the cell once user enters into a trade.

However, once user ends this trade (which will be on Active Cell Row + column BO) i would then like the formula in Active Cell Row + Column BP to get overwritten with the stored data.

I hope all this is possible.
Hope someone can help.

Thanks in advance.