Discrepancies between TotalAssetsActual and TotAssets values for EA banks

Hi Jirapongse,

Client has raised the same above with our helpdesk team, I have checked with our relevant content team(fundamentals), that data /values are indeed correct, and there's no issues on data side. Also, I have checked with the product specialist team they suggested to check with your team to. The issue might me with the codes used here. Hence could you please check the codes and assist client accordingly

Please find the code used by client

Python code:

import eikon as ek
import warnings

warnings.filterwarnings('ignore')

# Set API Key
ek.set_app_key(ek_api_key)

# query data for TotalAssetsActual
variables_data_TA_actual = [f"TR.TotalAssetsActual(Period=FQ0)", f"TR.TotalAssetsActual(Period=FQ0).periodenddate"]
data_TA_actual, err = ek.get_data(instruments=["MDBI.MI", "BKT.MC", "BCP.LS", "LBK.MC^H21", "CRGI.MI^I22"],
                        fields=variables_data_TA_actual, parameters={'SDate': "2014-12-31",
                                                            'EDate': "2025-03-31"})
data_TA_actual.columns = data_TA_actual.columns.str.lower()
data_TA_actual = data_TA_actual.rename(columns={'period end date': 'reported_period'})
data_TA_actual_clean = data_TA_actual.drop_duplicates()

# query data for TotAssets
variables_data_TA = [f"TR.F.TotAssets(Period=FQ0)", f"TR.F.TotAssets(Period=FQ0).periodenddate"]
data_TA, err2 = ek.get_data(instruments=["MDBI.MI", "BKT.MC", "BCP.LS", "LBK.MC^H21", "CRGI.MI^I22"],
                        fields=variables_data_TA, parameters={'SDate': "2014-12-31",
                                                           'EDate': "2025-03-31"})
data_TA.columns = data_TA.columns.str.lower()
data_TA = data_TA.rename(columns={'period end date': 'reported_period'})
data_TA_clean = data_TA.drop_duplicates()

# left join between data_TA_actual_clean and data_TA_clean
data_merged = data_TA_actual_clean.merge(data_TA_clean, on=['reported_period', 'instrument'], how='left')

data_merged = data_merged[['reported_period', 'instrument', 'total assets - actual', 'total assets']]

@Subbareddy_123

The ek.get_data method can retrieve the same data as =@RDP.Data function in Excel.

Therefore, you can use the Excel to verify the data.

For example, I compared the following formulas in Excel.

=@RDP.Data("DBKGn.DE","TR.TotalAssetsActual(Period=FQ0);TR.TotalAssetsActual(Period=FQ0).periodenddate","Frq=q SDate=2014-12-31 EDate=2025-03-31 CH=Fd RH=IN",B2)

=@RDP.Data("DBKGn.DE","TR.F.TotAssets(Period=FQ0);TR.F.TotAssets(Period=FQ0).periodenddate;TR.F.TotAssets(Period=FQ0).date","Frq=q SDate=2014-12-31 EDate=2025-03-31 CH=Fd RH=IN",G2)

The data is different. Therefore, I think it looks like to be a content question.

You can verify the data for DBKGn.DE, MDBI.MI, and KBC.BR as mentioned in the question.

I am not if it requires the 'Frq':'Q' parameter in the code.

variables_data_TA = [f"TR.F.TotAssets(Period=FQ0)", f"TR.F.TotAssets(Period=FQ0).periodenddate"]
data_TA, err2 = ek.get_data(instruments=["MDBI.MI"],
                        fields=variables_data_TA, 
                        parameters={
                            'Frq':'Q',                                                    
                            'SDate': "2014-12-31",
                            'EDate': "2025-03-31"})
data_TA

The client may need to add the Frq parameter in the request.

Could you please summary which data is missing in the API and which data is in Excel?

I checked and found that the client reported the follow values:

BOPr.AT 2018-12-31 TR.F.TotAssets(Period=FQ0)
BCP.LS 2024-09-30 TR.F.TotAssets(Period=FQ0)
BKT.MC 2020-09-30 TR.F.TotAssets(Period=FQ0)
BKT.MC 2024-09-30 TR.F.TotAssets(Period=FQ0)
NBGr.AT 2018-12-31 TR.F.TotAssets(Period=FQ0)
NBGr.AT 2019-12-31 TR.F.TotAssets(Period=FQ0)

If these values are not available, please inform the client.

@Subbareddy_123

Please confirm the code that the client is using. I found the 'Frq' parameter must be 'FQ', not 'Q'.

For example:

variables_data_TA = [f"TR.F.TotAssets(Period=FQ0)", f"TR.F.TotAssets(Period=FQ0).periodenddate"]
data_TA, err2 = ek.get_data(instruments=["NBGr.AT"],
                        fields=variables_data_TA, 
                        parameters={
                            'Frq':'FQ',                                                    
                            'SDate': "2014-12-31",
                            'EDate': "2025-03-31"})
data_TA

I assume that you can access CodeBook. You can run the code on CodeBook to verify the data.

@MGM

Typically, when requesting timeseries data, you need to specify the Frq parameter.

You can use the Data Item Browser tool to check its values. The TR.F.TotAssets field supports the following values.

FQ is 'Fiscal Quarter'. Q is 'Quarterly' which is supported by other fields, such as TR.PriceClose.

To understand the logic and reason behind this, please contact the helpdesk team directly via MyAccount.