Discrepancies between TotalAssetsActual and TotAssets values for EA banks

MGM
MGM Newcomer
edited April 2 in Refinitiv Data Platform

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!

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

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

  • 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']]

  • 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
    Jirapongse ✭✭✭✭✭

    @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)
    
    image.png

    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
    edited April 9


    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 ?


    total assets.png


    image.png


    image.png
  • Jirapongse
    Jirapongse ✭✭✭✭✭

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

    image.png
  • Subbareddy_123
    edited April 10

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


    image.png


    image.png


    image.png


    image.png


    Some of them we have values in excels

    image.png


    image.png


    image.png


    image.png image.png


    image.png


    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
    Jirapongse ✭✭✭✭✭

    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.

  • Hi Jirapongse,

    Good day!

    below is the client reported

    image.png


    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
    Jirapongse ✭✭✭✭✭

    @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
    MGM Newcomer

    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
    Jirapongse ✭✭✭✭✭

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

    image.png

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

    image.png

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