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 vicissitude · Feb 05, 2019 at 03:17 PM · apieikonexceldatastream

Retrieve Datastream data when we only subscribe to Eikon

I previously used Datastream to retrieve contract-level stock index option historical daily data. Since there are a lot of options (both active and expired ones), I used the python package PyDatastream to retrieve the data.

However, recently, our institution has switched to Eikon, so I cannot directly use PyDatastream any more (no username or passwords). I tried to use Eikon API, but it seems that the identifier in Eikon is RIC, which is different from the identifier in Datastream (Symbol).

Thanks to @Joris.Hoendervangers's answer here, it is feasible to retrieve the corresponding RICs for Datastream items using Datastream Excel Add-ins (integrated in Eikon). However, it seems that not all Datastream items have an RIC. For example, the continuous option series "S&P/ASX 200 INDEX 100% Moneyness" in Datastream does not have an RIC. More IMPORTANTLY, some data series, e.g. expired options, are in Datastream, but not in Eikon. In this case, even if we have the RICs for these options, Eikon API cannot get their data.

My question is: is there a way to retrieve data using VBA, Python, or any other languages, with Datastream identifiers (Symbol or Mnemonic), instead of RIC, if we only subscribe to Eikon? I understand that Eikon API cannot be used to get data from Datastream (See the answer here). And COM API (e.g. RHistory API) seems to recognize only RIC, not Datastream identifiers (Symbol or Mnemonic). Also I cannot use DSWS without a Datastream username and password.

Is there anything I can do? VBA may be a solution since at least the Datastream Excel Add-in, integrated in Eikon, is able to retrieve Datastream data using Symbol (e.g. the DSGrid function), but can I use VBA to call the DSGrid function?

Thank you very much.

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.

4 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by paul.bacon · Feb 06, 2019 at 04:19 AM

Hi

To get access to DSWS you will need to speak to your account manager to order the service, there are two versions of access and after you have discussed your intended use they will be able to activate it for you.

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 Alex Putkov. · Feb 05, 2019 at 03:34 PM

@flcong
Higher tier Eikon variants include access to Datastream data. If you can use Datastream Excel Add-in with your Eikon account, you should be able to use DSWS. You just need to obtain DSWS user name (aka Datastream Child ID) and password associated with your Eikon account. You can get this information from your Refinitiv account manager or by contacting Refinitiv Helpdesk. Refinitiv Helpdesk can be reached by either calling the Helpdesk number in your country or by using Contact Us capability in your Eikon application.

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
vicissitude · Feb 05, 2019 at 06:13 PM 0
Share

Thank you very much for your quick response. I have contacted the helpdesk and confirmed that we don't have subscription to DSWS, despite the fact that we have access to Eikon and Datastream data from the Excel add-ins.

avatar image
REFINITIV
Answer by Alex Putkov. · Feb 06, 2019 at 08:24 AM

Thank you @paul.bacon. I stand corrected. Do I understand correctly that @flcong should be able to order access to DSWS service without additional charge provided the service will be utilized for individual user's use only?

Comment

People who like this

0 Show 2 · 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
vicissitude · Feb 06, 2019 at 04:09 PM 0
Share

Well, I don't think so... The Customer Support said that extra charges are needed to activate DSWS. Still, it seems weird to me that Datastream API and Datastream Excel Add-ins (integrated in Eikon) are priced separately...

avatar image
REFINITIV
paul.bacon vicissitude · Feb 07, 2019 at 04:38 AM 0
Share

Hi @flcong

I strong suggest you contact your account manager, they can help identify which version of the Datastream API is most suitable to you. There are two variants of the service and dependent on how you use the product they may be additional charges. Details on the two version can be found on the dedicated DSWS page on this dev community site.

avatar image
Answer by vicissitude · Feb 06, 2019 at 04:40 PM

I figure out that the best I can do is to use the "New Request Table" tag in the Datastream Excel Add-in to download many series at one time and save in a opened Excel sheet, but it is still laborious. In my case, I will download tens of thousands of option contracts.


I'm not sure if VBA is able to do that. I tried to looked at the VBA code in the "New Request Table" template to see how it downloads data from Datastream (I'm not an expert in VBA). Specifically, the "Process Table" button calls the Sub "btnProcessTable_Click()", which further calls the Sub "ProcessRequestTable", which finally calls the Sub "gRTCOMInterface.ProcessRequestTable", whose code is invisible. It may be feasible to use VBA and the Request Table to automate the downloading process, according to the question here.

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 >
8 People are following this question.

Related Questions

Is there a VBA macro to refresh DataStream DSGRID() functions?

What is the time when Datastream updates closing price data??

I can access DSWS via Excel but not via DatastreamDSWS2R

Unable to download equity indices data using Datastream

DSWS API - What is the pricing for this method of accessing the data?

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • 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
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges