question

Upvotes
Accepted
filip.shu avatar image
1 ●1 ●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.

moragodkrit.chumsri_1 avatar image   moragodkrit.chumsri_1

@filip.shu

Thank you for your participation in the forum.


Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply that best answers your question.

This will guide all community members who have a similar question. Otherwise please post again offering further insight into your 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


2 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
79.2k ●251 ●52 ●74

@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
Jirapongse avatar image
79.2k ●251 ●52 ●74

@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.

filip.shu avatar image filip.shu

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.