Time-series requests Datastream Web Service

Question

Question by FRZH · Jul 18, 2019 at 11:26 AM · python datastream web service time-series column headers

Time-series requests Datastream Web Service

Good evening

When downloading time-series data for multiple instruments using Datastream Web Serive in Python I get column names which contain the ticker (in this case ISIN) and field name (in this case P).

Whould it be possible to define similar to the the Datastream Add-in in Excel what the column header should be?

Thanks for your help.

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2019-08-21T06:03:14Z

REFINITIV

Best Answer

Answer by James.Bright1 · Aug 21, 2019 at 06:03 AM

ISIN is not a time series datatype. If you perform this within a snapshot request you can use the datatype ISIN

Please feel free to email directly james.bright@refinitiv if you would like to set up a call to discuss this in more detail.

Best regards

James

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 2 · 2019-07-30T04:24:02Z

REFINITIV

Answer by James.Bright1 · Jul 30, 2019 at 04:24 AM

Hi,

You can apply headers within Python. There are some examples here

https://developers.refinitiv.com/eikon-apis/datastream-web-service/downloads

Best regards

James

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 3 · 2019-08-06T03:54:13Z

Answer by FRZH · Aug 06, 2019 at 03:54 AM

Hi James,

Please find attached the output of the following request:

ds.get_data(tickers=['@AAPL','@FB'], fields=['DY'], start='-1Y', end='-0D', freq='D')

As you can see the header contains the ticker and the field name (

time-series-request.jpg). Is there any possiblity to specify what kind of header type I want (e.g., just the ISIN)?

Best regards,

Florian

time-series-request.jpg (19.8 KiB)

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

FRZH · Aug 21, 2019 at 05:56 AM 0

Share

@James.Bright1 Do you have any feedback for me?

Answer 4 · 2019-08-21T06:06:06Z

REFINITIV

Answer by James.Bright1 · Aug 21, 2019 at 06:06 AM

You can use the ISIN within your request to have this within the title.

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Time-series requests Datastream Web Service

4 Replies

Watch this question

Related Questions