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
df_SGA,err = ek.get_data(['6902.T'],
['TR.F.SGAASR','TR.F.SGAASR.name','TR.F.SGAASR.fperiod','TR.CompanyName'],
{'Curn':'JPY','Scale': 6 ,'Period':'FY0','Frq':'FY','SDate':'0','EDate':'-30'})
df_SGA
returns total selling, general and admin expenses but also break down of the item,
how can I get the name of alll the fields?
tried TR.F.SGAASR.name, TR.F.SGAASR.fieldname, TR.F.SGAASR.name.*** but nothing works...
Thank you for the exaplanation.
The field could be TR.F.SGAASR.LIName.
df_SGA, err = ek.get_data(['6902.T'],
['TR.F.SGAASR','TR.F.SGAASR.LIName','TR.F.SGAASR.fperiod','TR.CompanyName'],
{'Curn':'JPY','Scale': 6 ,'Period':'FY0','Frq':'FY','SDate':'0','EDate':'-30'})
df_SGA
Thank you. It saved my day!
Is thay a way to find the related data field?I tried "Search Tools"->"Data Items" in my refinitiv workspace,
But cannot even find TR.F.SGAASR
I couldn't find it too.
I tried other output fields from the TR.JPOtherSGAExpense field and it works.
Do you mean a display name of a field?
If yes, the fields' display names are populated in the data frame's column names.
You can set the raw_output to True to get the raw JSON data.
The query returns multiple value for patricular fiscal year (eg. FY2021)
Apparently 42,577, and 87,309 showed in your snapshot is break down of overall SG&A, but they all have the same name "TR.F.SGAASR"
I wonder if I can retrieve item name such as "Packing Expense, xxx,xx" and "Provision for product warranties" directly.
