Discrepancies between TotalAssetsActual and TotAssets values for EA banks

MGM · April 1

Hello,

We regularly query banks data from Refinitiv Workspace for TotalAssetsActual. We noticed several discrepancies between the values of this variable and those of TotAssets, though in principle they should align. Specifically:

for some banks and periods, e.g. RIC DBKGn.DE - quarters between 2023 Q1 and 2024 Q3, there are missing data for TotAssetsActual, while the data is there for TotAssets;
in very few cases, the are missing data for TotAssets while the data is present for TotalAssetsActual, e.g. MDBI.MI in 2024 Q3 and 2024 Q4;
there are cases (excluding those where either TotalAssetsActual or TotAssets are missing) where the values of the 2 variables for the same instrument and financial period differ - the delta between the two varies a lot; e.g. RIC KBC.BR in 2019 Q4 and 2022 Q4.

More generally, we noticed that TotalAssetsActual has several missing data especially at FQ frequency.

Could you please clarify the reasons for these discrepancies?

Thanks a lot for your assistance!

Jirapongse · April 2

@MGM

Thank you for reaching out to us.

As this forum is more for programming type queries, rather than content queries - I would recommend you raise a 'I need help understanding content within the product' ticket with our helpdesk. That way a Content specialist can work closely with you and verify the assumption.

Subbareddy_123 · April 8

https://community.developers.refinitiv.com/discussion/comment/124975#Comment_124975

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 · April 8

https://community.developers.refinitiv.com/discussion/comment/124975#Comment_124975

I am unable to attach the client screenshot, client is getting N/A values for the TR.TotAssets:

client is interested in comparing TR.F.TotAssets with TR.TotalAssetsActual (see the script below).

Please do check and let us know if the codes is right or we are missing something in the formulas or data.

Jirapongse · April 9

https://community.developers.refinitiv.com/discussion/comment/125117#Comment_125117

@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

Subbareddy_123 · April 9

https://community.developers.refinitiv.com/discussion/comment/125122#Comment_125122

Hi Jirapongse,
Thank you for the answer.

Let us check client recent follow up questions.

Follow Up:

Unfortunately, we are still encountering the same issue mentioned before, i.e. that there are few cases where the I/B/E/S value (TR.TotalAssetsActual) is present, while the value for the variable TR.TotAssets is missing.

The cases are the following:

As already reported, RIC MDBI.MI for periods 2024-09-30 and 2024-12-31;
RIC BKT.MC for 2024-09-30;
RIC BCP.LS for 2024-09-30;
RIC LBK.MC^H21 for 2021-03-31;
RIC CRGI.MI^I22 for 2018-12-31.

For the above mentioned rics only for BKT.MC and BCP.LS and their periods we does not have values. remaining we have data

also client provided screenshot where for the ric "MDBI.MI" client is getting NA values from 2020/12/31 to 2024/12/31 for the total assets. out of all this only q2 results are getting for this ric for client(screenshot)

I have used the same formula you have provided, and I am to get the data for all the period( see excel screenshot)

If the formula and client using method is same, then client also should get the data
Can you check further on this ?

14625560.xlsx

Jirapongse · April 9

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

Subbareddy_123 · April 10

https://community.developers.refinitiv.com/discussion/comment/125136#Comment_125136

Hi Jirapongse,
Thank you for the answer.

Still client is getting some null values

Please see below follow up from client

we still encountered few cases where the TR.TotalAssetsActual is present, while TR.TotAssets is missing.

Please see the screenshots below (clearly ignore the rows where both the values are missing).

Some of them we have values in excels

with the fromula provided by you, proving same period twice and missing the actual period ?
only the Null values in excel is the correct null values and not available in our database. remanning we have values but client is getting NA values using the code and in I am getting the duplicate of periods.

this formula gives the correct values

=@RDP.Data("NBGR.AT","TR.F.TotAssets","Period=FQ0 Frq=FQ SDate=0 EDate=-30 RH=periodenddate")

could you please check and assist the client ?

Jirapongse · April 11

https://community.developers.refinitiv.com/discussion/comment/125175#Comment_125175

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 · April 16

Hi Jirapongse,

Good day!

below is the client reported

I have checked and formula and cross verified with the content teams, they confirmed that we have values in database. for null content teams are checking for reason.

Now the question is, even though we have values getting in excel, for the below, why client is getting the NA values using python code

BOPr.AT 2018-12-31 TR.F.TotAssets(Period=FQ0)

BKT.MC 2020-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)

NLBR.LJ 2018-12-31 TR.F.TotAssetets (period=FQ0)

Please check and advise on this

Jirapongse · April 17

@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 · April 22

https://community.developers.refinitiv.com/discussion/comment/125259#Comment_125259

Hello @Jirapongse,

thanks a lot for all the help, indeed the last query you provided, including the 'Frq' parameter set to 'FQ', works in retrieving all the data for the variable 'TR.F. TotAssets'.

Could you provide us an insight on why this is the case and how this is different from not including any specific 'Frq' parameter or setting it to 'Q' only? We ask this to better understand the logic and reason behind this and eventually change our codes accordingly.

Thank you for your help and patience.

Jirapongse · April 24

@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.

Discrepancies between TotalAssetsActual and TotAssets values for EA banks

Answers

Categories

EXPLORE OUR SITES

Discrepancies between TotalAssetsActual and TotAssets values for EA banks

Answers

Categories