question

Upvotes
Accepted
Gil.ashkenazi avatar image
1 ●0 ●0 ●1

Moving from Excel to Python

I have an xlsx file of which data I can refresh using the Datastream add-in.

I’m searching the documentation in https://developers.refinitiv.com in order to find a way to pull the same data using Python, but I seem to be a bit lost.

Can you help me understand how I can find ticker names and fields in the spreadsheet and what library to query them with? The file is attached.

datastream-apidsws-api
datastream-question.zip (31.4 KiB)
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
Alan Tam123 avatar image
84 ●3 ●0 ●6

Hi @Gil.ashkenazi,

  • For ticker search, use this page.
  • For datatype search, use this page.
  • Getting Started with Python documentation is here.

Hope this helps.

Alan

icon clock
10 |1500

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

Gil.ashkenazi avatar image Gil.ashkenazi

Thank you for your answer, I was able to find my data in the first page ("For ticker search"). Now I don't have access to DSWS API, but I do have access to Eikon. How do I find the same data using Eikon? The ticker is "@:USSP500"

Alan Tam123 avatar image Alan Tam123 Gil.ashkenazi

@Gil.ashkenazi If you are already using DFO (Datastream for office), please speak with your Refinitiv account manager to enable the DSWS API desktop version.

Click below to post an Idea Post Idea