question

Upvotes
Accepted
166 13 18 21

Eikon API: Retrieving filing date for annual reports

Question on behalf of a client. Is it possible to retrieve the filing date of quarterly/annual reports?

Maybe the same logic can be used as the 'calcdate' or 'periodenddate'. Is there a field for 'filing date' and/or 'receipt date'?

Thank you so much in advance for your help!

df, err = eikon.get_data('AAPL.O', ['TR.TotalAssetsReported', 'TR.TotalAssetsReported.calcdate', 'TR.TotalAssetsReported.periodenddate'] )

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apidata
filing.jpg (72.6 KiB)
filings2.jpg (9.4 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.

Upvote
Accepted
166 13 18 21

With help of the Eikon Helpdesk:

Excel formula:

=TR("AAPL.O","TR.ISSourceDate;TR.ISSource","Period=FI0
Frq=FI SDate=0 EDate=-6 CH=Fd RH=IN",)

Using these fields in Python:


filings3.png (13.6 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.

Upvotes
1 0 0 0

Hi! Where can I fine TR financials function that I can export throught workspace lite in excel?



I would like to know which other data and ratios it may be possible to extract

Data itemsWorkspace functionNet MarginTR.IncomeAftTaxMarginpctAsset TurnoverTR.AssetTurnoverPretax ROATR.PretaxROAPctROETR.ReturnonAvgTotEqtyPctNetIncomeBeforeExtraItemsGross profit marginTR.GrossProfitMarginIndustrialAndUtilityPctCurrent RatioTR.CurrRatioTimes Interest Earned (interest coverage)TR.TimesInterestEarnedDebt/EquityTR.HistTotDebtCommEqtyPctTotal AssetsTR.TotalAssetsReportedTotal RevenueTR.TotalRevenueZscore, Manufacturing WeightsTR.ZScoreManufacturingWeightsZscore, NonManufacturing WeightsTR.ZScoreNonManufacturingWeights
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.