Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Datastream /
avatar image
Question by ricardo.sanmiguel · Nov 15, 2018 at 09:04 AM · eikon-data-apidatastream-apidsws-apitime-seriesmnemonicsindices

Converting Mnemonic to RIC and getting timeseries data (RI and NR) with EIKON Data API

Dear all,

I need to download different index-data (e.g. Total Return Index (RI), Net Return Index (NR)) as timeseries. Currently I'm using the Datastream Request-Tables for this purpose. Now I want to replace them with the EIKON Data API for Python. During this transition I've came up with the following issues:

- Converting Mnemonic to RIC. The function get_symbology doesn't allow to convert Mnemonics directly to RIC. I've used the DS_Grid function in order to do this and the following issue appeared: For some indices no RIC is available at all. Therefore my question is how should I proceed in order to convert a Mnemonic to RIC and is there a possibility to request a RIC for those Mnemonics where there is no RIC available? Furthermore I would also need to download User Created Indices. Where can I set up a RIC for those?

- Currently the get_timeseries function only supports a limited amount of fields. How can I proceed if I want to download e.g. the Total Return Index (RI) for several indices?

Thanks in advance for your help. I really appreciate it.

Best regards,

Ricardo

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

7 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov.1 · Nov 15, 2018 at 04:07 PM

@ricardo.sanmiguel
What's the purpose of replacing Datastream Request-Tables with Eikon Data APIs? Is it just to be able to retrieve data programmatically using Python? If this is the case I suggest you use Datastream Web Service, which provides programmatic access to the exact same datasets you get from Datastream Request-Tables using the same symbology and metadata you use currently.
Eikon Data APIs do not provide access to Datastream datasets, hence the issues you ran into. There's some overlap between datasets available through Datastream and through Eikon, but Eikon and by extension Eikon Data APIs cannot be used to retrieve the full breadth of Datastream datasets.

Comment
Monika.Stankovic

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by ricardo.sanmiguel · Nov 16, 2018 at 03:14 AM

@Alex Putkov. Thanks for your quick reply. Your explanation regarding the difference between the Eikon Data API and the DSWS API is very useful. The purpose is exactly how you pointed out to retrieve data programmatically using Python since the solution using DS Request-Tables gets unstable when retrieving large datasets. I'll therefore have a look into Datastream Web Services (DSWS).

I hope you don't mind if I ask two further questions

- Do you know if DSWS allows me to upload & more important to download user created indices as it is possible with the Excel Add-in?

- The python DSWS package seems to be unofficial and unsupported by Thomson Reuters. Is it planned to launch an official package (like with the Eikon Data API)?

Thanks in advance for your help.

Best regards,

Ricardo

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Alex Putkov.1 ♦♦ · Nov 16, 2018 at 12:02 PM 0
Share

One thing you should be aware of is that DSWS service for desktop users limits your data consumption to 10 million datapoints per month. Since you mentioned you're retrieving large datasets, you may want to consider DSWS for Enterprise license.

avatar image
REFINITIV
Answer by Alex Putkov.1 · Nov 16, 2018 at 11:55 AM

@ricardo.sanmiguel,
The Python library for DSWS is open source, which is why it's published on GitHub. Refinitiv will support it on a best effort basis. What we do support officially is the underlying SOAP and RESTful interfaces. The Python library is pretty simple. If any deficiencies are found within the Python library, they may be reported to Refinitiv or the community (including you) may contribute a fix on GitHub.

I'm afraid I don't know the answer to your first question. For this reason I've moved this thread to the forum dedicated to DSWS.
@Monika.Stankovic, would you mind answering "does DSWS allow me to upload & more importantly to download user created indices as it is possible with the Excel Add-in?"

Comment
ricardo.sanmiguel

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Monika.Stankovic · Nov 19, 2018 at 08:20 AM

Thank you @Alex Putkov.

@ricardo.sanmiguel

To answer the question on User Create Indices (UCI), already created UCI can be pulled via DSWS however a new UCI can't be created in DSWS.

Comment
ricardo.sanmiguel

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by ricardo.sanmiguel · Dec 27, 2018 at 09:57 AM

@Alex Putkov. @Monika.Stankovic First of all my apologies for my late reply regarding this post. For my purpose it is important to know if it is also possible

with PyDSWS to pass by a the ticker in a "compounded" format such as BCWRLD$(RI)~CHF (Ticker & Field & Currency). If this should not be possible does maybe the .NET API provide such a solution?

Thanks in advance for your helpful answers.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Monika.Stankovic · Jan 02, 2019 at 08:58 AM
@ricardo.sanmiguel

This is possible to do with PyDSWS, just follow the construction of the time series request as below, where DATE in start and end can be in form of absolute dates (YYYY-MM-DD) or relative dates (e.g. -10D, -0D):

ds.get_data(tickers='BCWRLD$', fields='X(RI)~CHF', start='DATE', end='DATE', freq='D')

Comment
ricardo.sanmiguel

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by ricardo.sanmiguel · Jan 04, 2019 at 04:28 AM

@Monika.Stankovic It is therefore not possible to pass by an argument as

"BCWRLD$(RI)~CHF" without splitting it?

Furthermore we also have some timeseries which we retrieve with some additional calculation e.g. (LHMVALL(IN))~EUR+100 or REBE#(EXP#(CSUM#(LN#(E3C8(SBBPWL$(NR)~E,USEURSP,USEUR1F)))),100). I guess such calculations would need to be done within the code itself and cannot be passed by using such adapted tickers right?

Thanks for all the input you're providing. It is very much appreciated!

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.

Related Questions

how to get first release economic data

Time-series requests Datastream Web Service

How do extract symbols that fulfil regex criteria in datastream?

How to extract ESG Pillar Scores time series with TR function?

Datastream Functions in DSWS

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges