Hi, we have some fields to retreive data with python, this fields are for balanceSheet, IncomeSheet and CashFlow Data.
p = {
'Period': 'FY0'
, 'reportingState':'Orig'
, 'curn': currency
, 'Scale':'6'
, 'SORTA':'LISeq'
, 'CH':'Fd'
, 'IncludeOldYE' :'No'
, 'ReportType':'Latest'
, 'Edate' : '-10FY'
, 'FRQ':'FY'
, 'transpose':'y'
, 'Sdate' : '0FY'
, 'FXRate' : 'PeriodEnd'
, 'NULL' : 'blank'
}
df, err = ek.get_data(['BAP.LM'], ['TR.F.BalanceSheet.fieldName','TR.F.BalanceSheet.fielddescription', 'TR.F.BalanceSheet.date','TR.F.BalanceSheet'], parameters = p )
We handle the translate for the all fields, so we obtain the name of the field in english to build this json Example:
{
"key": "TR.F.AssetParticipFactorIssue ",t
"lang": {
"es": "Factor de participación de activos: tema específico ",
"en": "Asset Participation Factor - Issue Specific"
}
}
but for the followings fields ge got The formula must contain at least one field or function vía excel.
TR.F.PPEExclROUTangCapLeaseNet
TR.F.PPEExclROUTangCapLeaseGross
TR.F.PPEExclROUTangCapLeaseAccumDepr
TR.F.TotOpLeaseLiab
TR.F.FinOpLeaseLiabTot
TR.F.DebtInclFinOpLeaseLiab
TR.F.InterestEarnLiabAvg
I wondering if there is a way to obtain at least the name of the fields even if the field does not have data.
Thanks