title: Quickest Way to synchronously refresh TR-Formulas in VBA
body: <p>Thanks to the help in this forum, I got my SQL-conncection and inserts working now.</p>
  <p>The following TR-formula is used to retrieve the data from Excel Eikon:</p>
  <pre><code>@TR($C3,&quot;TR.CLOSEPRICE (adjusted=0);
    TR.CompanySharesOutstanding;
    TR.Volume;
    TR.TURNOVER&quot;,&quot; NULL=Null CODE=MULTI Frq=D SDate=&quot;&amp;$A3&amp;&quot; EDate=&quot;&amp;$A3)
  </code></pre>
  <p>For 100k RICs the formulas usually need between 30s and 120s to refresh. That would still be acceptable.</p>
  <p>The problem is to get the same refresh-speed in a VBA-loop. <code>Application.Run &quot;EikonRefreshWorksheet&quot;</code> is currently used for a synchronous refresh as recommended in this post.</p>
  <p><a href="https://community.developers.refinitiv.com/questions/20247/can-you-please-send-me-the-excel-vba-code-which-ex.html" rel="nofollow noreferrer">https://community.developers.refinitiv.com/questions/20247/can-you-please-send-me-the-excel-vba-code-which-ex.html</a></p>
  <p>The syntax of the code is correct and working for 100 RICS. But already for 1k the fetching gets very slow and will freeze completely for like 50k. Even with a timeout interval of 5min.</p>
  <p>I isolated the refresh-part. There is nothing else slowing it down. So is this maybe just not the right method for fetching larger data sets? Does anyone know a better alternative?</p>