Frequency selection Refinitiv Datastream Excel

Hello,

I am using Refinitiv Datastream add-in on excel to obtain monthly data (for example: ROA) for a group of companies however when I select frequency as monthly, the data I obtain is the yearly data duplicated for each month. I am pretty sure that Refinitiv has the monthly data however I do not seem to be able to obtain it.

Thank you for your help

issue-refinitiv-datastream.png

Screenshot 2023-08-10 at 18.41.38.png



Best Answer

  • raksina.samasiri
    Answer ✓

    Hi @mb3291 ,

    Thank you for posting the question in
    this forum. However, this forum is dedicated to an API usage question hence,
    the moderators on this forum do not have deep expertise in every type of
    content available through Refinitiv products. Such expertise is available
    through Refinitiv Helpdesk, which can be reached via MyRefinitiv. To be of help, ticket number 12809048 was raised on your
    behalf and the support team is going to contact you directly to assist with
    this.

    Hope this helps and please let me
    know in case you have any further questions.

Answers

  • Case 12809048 is closed with the following resolution

    Upon checking, Worldscope Datatype WC08326 only updates Annually. Even if we select monthly as a frequency, the data would only be padded as this Datatype only updates once, annually. Please find enclosed spreadsheet with sample download of data as requested for Daily, Monthly and Annual frequency.