question

Upvotes
Accepted
5 0 0 1

getting Datastream data code 553E

I am trying to get timeseries data from Datastream code 553E. I was able to get it from Excel using the the Refinitiv Datastream Excel plugin, but was unable to get the same data using the Datastream python API (using the same code 553E). What is the correct format of the ds.get_data() command to get data code 553E for ticker INTC.O?

#productdatastream-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
78.2k 246 52 72

@Quek

Thanks for reaching out to us.

I checked and found that the data type 553E represents "12M Forward Price/Book". To use the Datastream with RICs, you need to enclose a RIC with angle brackets <>.

I tried the code below and it works fine.

df = ds.get_data(tickers='<INTC.O>,<IBM.N>',
                 fields=['553E'],
                 kind=0)
df

The output is:

1678323992206.png


I hope that this information is of help.


1678323992206.png (13.8 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
5 0 0 1

How do I download the time series for 553E? The answer allows me to download only the current value of 553E. Using the Excel Datastream plugin, I am able to download the time series, for example from 2023-01-02 to 2023-03-08. However, I am unable to do the same if i were to use the Python API. Can you please 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.

Upvotes
78.2k 246 52 72

@Quek

Please try this code.

df = ds.get_data(tickers='553E(<INTC.O>)',
                 kind=1,start='-2Y',end='0D',freq='D')
df

The output is:

1678338333592.png


1678338333592.png (16.1 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.

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.