Using Dynamic Data Exchange (DDE)
Cell Formula for cell A1
=DDE(“MT4”,“ASK”,D3)
MT4=Metatrader 4 trading platform (external program)
ASK=Currency price
D3= Currency pair (e.g., EUR/USD)
Formula above works fine…cell displays currency price, WHICH CAN CHANGE EVERY SECOND
Question…
Would like to do the following in cell B1
IF(cell A1 >= “(A Fixed Value Set by Me)” then B1 = The ONE VALUE OF A1 (Not Formula) when condition occurs, otherwise B1=0)
Possible? (or must manually use “paste only - number”)
Thanks!
Hello @JRC,
For example suppose that you put your “Fixed Value Set by Me” into cell C1, then you could set the following formula to cell B1:
=IF($A$1>=$C$1;$A$1;0)
EDIT 20170828-1 :
To get only the contents of cell A1, you could try this:
=IF($A$1>=$C$1;CELL("CONTENTS";$A$1);0)
HTH, lb
Hi…
Thanks for your response.
Good suggestion and it does work.
However, it assigns the A1 FORMULA to B1 not just the A1 VALUE. Therefore, after the condition is met B1 is [=DDE(“MT4”,“ASK”,D3)] and the B1 value changes in unison with A1.
I am hoping to assign just the A1 VALUE to B1 AND only the ONE A1 value that occurs the first time the condition is met.
Right now, I have created a “Yes/No” flag in another cell that tells me the condition is met. If so, I then manually use “paste only - number” from A1 into B1 using a simple macro.
After much google time, I’m thinking this may not be possible because A1 is a “DDE” cell.
Thanks again…
JRC
i edited my answer with a formula that gets the cell contents of A1 … hope that works,
cheers, lib
Thanks again lib. Unfortunately, cell B1 still changes in unison with values streaming into A1 when the condition is True. Thought about writing macro to “copy/paste number only” when condition is true. Tested
“macro” approach with a simple function I found that plays sound (“beep”) when condition is true. Computer was “beeping” every second because calc re-evaluates condition each time number changes in A1, so “copy/paste number” would also execute each time. Ah well. - Thanks again. JRC