Obtaining Years alongside retrieval of Fundamental Data Asynchronously

vishal.nanwani

Hi everyone,

I have a question regarding the Date column not coming with get_data_async function calls. When I am making calls like so:

    roa_datapoints = await content.fundamental_and_reference.Definition(universe=[f'{ric}'],fields=["TR.F.IncBefDiscOpsExordItems","TR.F.TotCurrAssets","TR.CommonName"],parameters={"SDate": f"{start_year}-01-01", "EDate": f"{today_date_obj.date()}", "Frq" : "Y"}).get_data_async(closure=f'')

The Year Column doesn't come alongside the data. This is shown in the screenshot attached.

As you can see, there isn't a Year Column with the data. This is the same with Balance Sheet datapoints, such as Cash and Cash Equivalents, Total Current Assets, Total Assets, etc. and this is the same for any Revenue historical values that I pull. I need to have a 'Year' column, in order to know which Year each row is from. Any idea how I can be able to get the Year Column alongside my data (pulled with get_data_async)? When I use get_data(), I am able to get it, but I don't want to use synchronous functions for my use case, and I want to stay away from that. When trying to check the code itself for get_data_async(), I didn't see anything that pointed to this issue. I would appreciate if I can have some guidance on this issue.

Thanks!

aramyan.h

Hi @vishal.nanwani ,

You can call .date on the fields you are looking the dates for, for example, you can add "TR.F.TotCurrAssets.date" and will show the date for the field.

Additionally, you can check other output parameters for the fields from Data Item Browser:

So the output for your first query will look like:

roa_datapoints = await fundamental_and_reference.Definition(universe=[f'AAPL.O'],fields=["TR.F.IncBefDiscOpsExordItems","TR.F.TotCurrAssets","TR.F.TotCurrAssets.date", "TR.CommonName"],parameters={"SDate": "2020-01-01", "EDate": "2022-02-01", "Frq" : "Y"}).get_data_async(closure=f'')
roa_datapoints.data.df

Hope this helps.

Best regards,

Haykaz

vishal.nanwani

The other places where this happens are:

test_response = await content.fundamental_and_reference.Definition(universe=f'AAPL.O',fields=["TR.F.CashCashEquivTot","TR.F.TotCurrAssets","TR.F.PPENetTot","TR.F.TotAssets","TR.F.DebtLTTot",'TR.F.TotLiab','TR.CurrentLiabilitiesActValue'], parameters={"SDate": f"{five_years_ago.date()}", "EDate": f"{one_year_from_now.date()}", "Frq" : "Y"}).get_data_async(closure='Apple')

The same is to do with Revenue ,if I retrieve it for different periods, I cannot get the Year column along with it, or any kind of Date, which makes it very hard to tell when each datapoint is for.