How to retrieve a sum of fields with RDP API?

@torben1

Thank you for reaching out to us.

As I know, the fundamental_and_reference services on the desktop and RDP sessions are different.

The code that works on the desktop session may not work on the RDP session.

In stead of relying on the AVAIL function, you can do it in Python code.

For example:

currency = "EUR"

bs_fields = ["TR.CashAndSTInvestments","TR.CashandEquivalents","TR.Cash","TR.STInvestments"]


as_of_date = "2023-06-30"
freq = "FY"
period = "FY0, FY-2"
bs_result = fundamental_and_reference.Definition(
universe = ric_liste,
fields = bs_fields,
parameters = {"Scale": 6, "SDate": as_of_date, "Period": period, \
"FRQ": freq, "Curn": currency, "IncludePartial": "No"}
).get_data()


df1 = bs_result.data.df
df1["Cash and Equivalents"] = df1["Cash and Equivalents"].fillna(0)
df1["Cash"] = df1["Cash"].fillna(0)
df1["Short Term Investments"] = df1["Short Term Investments"].fillna(0)
df1["AVAIL_CASH"] = np.where(
    df1['Cash and Short Term Investments'].isnull(), 
    df1['Cash and Equivalents']+df1['Cash']+df1['Short Term Investments'],  
    df1['Cash and Short Term Investments']) 
df1

The output is: