question

Upvotes
Accepted
nancy.x.wu avatar image
1 ●0 ●0 ●1

Datastream DSWS change time zone of data

Hi,

What is the default time zone of the data that Refinitiv Datastream DSWS API returns and does it support changing the timezone of the data to local time? Suspect the default is New York Close but can this be confirmed please.

Can it be specified in ds.get_data() function when pulling data from the API or how can I manually convert the time zone from the API's default to local time zone?

I am running the function below, however need it to be local time rather than the default:

df = ds.get_data(tickers, fields, start_date, end_date, freq)

Appreciate any guidance on this please!

#technology#contentdatastream-apidsws-apitime-zone
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

Hi @nancy.x.wu ,

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

2 Answers

· Write an Answer
Upvotes
Accepted
jonathan.legrand avatar image
5.8k ●21 ●2 ●6

Hi @nancy.x.wu

The Datastream mainframe is UTC.

Content updates throughout the day at market close globally.


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
78.9k ●250 ●52 ●74

@nancy.x.wu

Thanks for reaching out to us.

According to the Getting started with Python document, the get_data method doesn't provide a parameter to specify the timezone. 

The difference between static and time series requests is that in
the latter you will use start and end date to define the period for which you need the selected data. Date can be relative (e.g. -10D, -2Y, 3M) or absolute (e.g. 2018-11-09) date format. Frequency in the request can be specified in days (D), weeks (W), months (M), quarters (Q) or years(Y).

You need to specify dates in the start and end parameters.

Regarding the default time zone of the data, please contact the Refinitiv Datastream Web Service support team directly via MyRefinitiv.

I hope that this information is of help.

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.

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.