Obtaining Years alongside retrieval of Fundamental Data Asynchronously

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!
Best Answer
-
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.dfHope this helps.
Best regards,
Haykaz
0
Answers
-
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.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 249 ETA
- 554 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 643 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 192 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛