question

Upvote
Accepted
20 0 0 3

Is there an option to receive TimeSeries data in reverse order from Datastream Web Service?

Hello,


I am trying to receive TimeSeries data from the Datastream API in Excel VBA under Windows, using the code examples shown in https://product.datastream.com/DswsClient/Docs/AboutRestSvc.aspx . The data comes back as oldest to latest, but I would like to reverse this order (from latest to oldest ).


In the Excel DSGRID function there is an option to specify "LatestFirstValue=true". Is there a corresponding option using the Datastream Web Service?

dsws-apiexcelvba
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.

1 Answer

Upvote
Accepted
55.8k 144 45 65

@IoannisG

Sorry about the issue that you are facing.

I don't think it has the option to reverse the order of response. We have contacted the product team to confirm it. However, to get a prompt response, you can contact the Datastream Webservice support team directly via MyRefinitiv.

I enabled tracing in the Refinitv Datastream Excel add-ins to verify how the request was sent using the LatestFirstValue=true option.

1666663189359.png

The first entry is still the oldest data. I think the add-ins reversed the data and display it in excel.

You can do the same thing in VBA. For example, create an array from the datastream response and then reverse the array.

I hope that this information is of help


1666663189359.png (70.4 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.