Hi! I have been trying to pull data on economic indicators directly via the Excel Formula Builder wi

modav001
modav001
in Eikon Data APIs

I was able to pull data of monthly German bond yields using the Formula Builder in Excel via the RIC DE10YT=RR and selecting "Data Items: Time Series". When trying to do the same with e.g. unemployment rate of Germany (aDECUNPQ/A), the "Category" and "Fields" boxes remain empty and, as a consequence, I do not receive any output.

I was able to pull the data manually from the Refinitiv Workspace but I need to be able to do it via Excel (automatically).

I would be very grateful for any advice on this matter.

Tagged:

Best Answer

  • zoya faberov
    zoya faberov
    Answer ✓

    Hello @modav001,

    I have tried to see if I could help, based on what you have done:

    1. Select instrument
    2. Select Time Series
    3. Select interval (Quarterly)
    4. Two fields available for economic indicators - Value and Timestamp, selected both
    5. Selected Parameters and specified border dates of Jan 1st through May 11th, to try to ma -ke sure I get a couple of Quarterly results in the interval
    6. Selected Add on both
    7. Inserted on the formula

    image

    This has resulted in a couple of data points pulled for the instrument.

    For in-depth guidance on Formula Builder usage as well as Eikon content, as a customer, please contact Refinitiv Helpdesk Online -> Content -> Eikon

    Hope this helps

Categories