Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
carlosgk avatar image
1 ●0 ●1 ●3

Download definition of variables API python

I am downloading the company fundamentals (Balance sheet and Income statement variables) for some companies. I want to download the definition of the variables as well.

For example for "total debt", the long definition is "Represents total debt outstanding, which includes: Notes Payable/Short-Term Debt, Current Portion of Long-Term Debt/Capital Leases and Total Long-Term Debt." How can I get this?

This a simple example of my code.

df, e = ek.get_data('KAER.VI',['TR.TotalDebtOutstanding'], {'SDate': '2020-01-01', 'EDate': '2022-12-31', "Period": "FQ0", 'Frq': 'FQ'})
#technologypython apicompany
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.

aramyan.h avatar image   aramyan.h

Hi @carlosgk ,

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

raksina.samasiri avatar image   raksina.samasiri

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvote
Accepted
nick.zincone avatar image
17.4k ●82 ●39 ●63

Hi @carlosgk

For content-based questions, it is best to go through the Refinitiv Workspace Helpdesk ("Get Help & Support" (F1 - function key)). They can involve a content specialist who can advise which properties you require.

To get a list of variables, you can use the DIB (Data Item Browser) within the desktop. Taking your example, you can also list out the specific dates, i.e.

df, e = ek.get_data('KAER.VI',['TR.TotalDebtOutstanding', 'TR.TotalDebtOutstanding.date'], 
                    {'SDate': '2020-01-01', 'EDate': '2022-12-31', 
                     "Period": "FQ0", 'Frq': 'FQ'})

1680745305369.png


1680745305369.png (46.2 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.