New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
1 2 5 5

How to get timeseries OHLC price for forex using datastreamDSWS python api?

datastream-apidsws-api
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.

Upvotes
Accepted
87.8k 294 53 79

@filip.shu

I don't think that Datastream WS supports hourly data. According to the Reference for DSService.svc - Enumerations page, the frequency supports the following values.

You may directly contact the Refinitiv Datastream Web Service team via MyRefinitiv for confirmation.


1614219343954.png (23.5 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.

Upvotes
87.8k 294 53 79

@filip.shu

I have used the Datastream Navigator to search for OHLC fields under the Exchange Rates. However, I am unable to find those fields. The available fields are:

Please directly contact the Refinitiv Datastream Web Service team via MyRefinitiv to verify if OHLC price for forex is available in the Datastream.


1614142776124.png (31.0 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.

Thank you for your reply. For OHLC price, I mean the hourly open/high/low/close price for specific forex symbol such as USD to CAD, can you show me the code to do it with datastreamDSWS python library? I was able to access the data using eikon python library, but I would like to know how it can be done by datastreamDSWS.


Sample codes and result using eikon python library:

1614144369875.png (20.8 KiB)

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.