title: Continue after reuters has retrieved data
body: <p><strong>Thomson Reuters Eikon used:</strong></p>
  
  <p>I need to get data from reuters regarding fx spot prices. This is easily done with a reuters formula. However, I need to use this data in a VBA script. Part of the VBA script inserts the formula, reuters then retrieves data but this can take a while (10-20 seconds). </p>
  
  <p>How do i make the VBA script pause until reuters has retrieved the data? (in the first 10 seconds the cell of the reuters data says: 'retrieving....'</p>
  
  <pre><code>Range("B2").value = Application.Evaluate("RtGet(" &amp; IDN &amp; "," &amp; RWAL &amp; "," &amp; MIDPRICE &amp; "," &amp; TYPENUM &amp; ")")
  </code></pre>
  
  <p>This code is now used to insert the formula where RWAL is the exchange rate identifier (such as EUR=)</p>