# Slightly different DDE question

#### slimimi

##### Well-known Member
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.

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Replies
1
Views
595
Replies
2
Views
234
Replies
5
Views
465
Replies
3
Views
488
Replies
0
Views
1K

1,191,125
Messages
5,984,786
Members
439,911
Latest member
dk73

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back