question

Upvotes
Accepted
mb3291 avatar image
1 ●0 ●0 ●1

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



#contentdatastream
issue-refinitiv-datastream.png (89.4 KiB)
screenshot-2023-08-10-at-184138.png (246.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raksina.samasiri avatar image   raksina.samasiri
<AHS>

raising the ticket via MyRefinitiv on behalf of the user.

wasin.w avatar image   wasin.w

<AHS>

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.
wasin.w avatar image   wasin.w

Hi @mb3291

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS


wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS

1 Answer

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
14.2k ●30 ●5 ●10

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

wasin.w avatar image wasin.w

Case 12809048 is closed with the following resolution

                   
    
                    
  1. 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.
    2. 
                    
  2.  
    3. 
                    
  3. Please find enclosed spreadsheet with sample download of data as requested for Daily, Monthly and Annual frequency.
    4.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.