get_data
This method sends a request to the Refinitiv Data Platform to retrieve the data described in the fundamental_and_reference.Definition object.
Module
refinitiv.data.content.fundamental_and_reference
Syntax
get_data(session, on_response)
Parameters
Value | Description | Data type | Optional | Default value |
---|---|---|---|---|
session | Session object. If it's not passed the default session will be used. | Session object | Yes | None |
on_response | User-defined callback function to process received response. | Callable | Yes | None |
Return value
Usage
The following example demonstrates how to retrieve the revenue and gross profit for IBM.N and TRI.N:
response = fundamental_and_reference.Definition(
universe=["TRI.N", "IBM.N"],
fields=["TR.Revenue", "TR.GrossProfit"]
).get_data()
print(response.data.df)
Response
Instrument | Revenue | Gross Profit | |
---|---|---|---|
0 | TRI.N | 6348000000 | 6022000000 |
1 | IBM.N | 57350000000 | 31485000000 |
The following example demonstrates how to retrieve the revenue and gross profit for all constituents of the chain:
response = fundamental_and_reference.Definition(
universe=["0#.DJI"],
fields=["TR.Revenue", "TR.GrossProfit"]
).get_data()
print(response.data.df)
Response
Instrument | Revenue | Gross Profit | |
---|---|---|---|
0 | GS.N | 64989000000.0 | 54629000000.0 |
1 | NKE.N | 44538000000.0 | 19997000000.0 |
2 | CSCO.OQ | 49818000000.0 | 31894000000.0 |
3 | JPM.N | N/A | N/A |
4 | DIS.N | 67418000000.0 | 22287000000.0 |
5 | INTC.OQ | 79024000000.0 | 43815000000.0 |
6 | DOW.N | 54968000000.0 | 10777000000.0 |
7 | MRK.N | 48704000000.0 | 35463000000.0 |
8 | CVX.N | 155606000000.0 | 66234000000.0 |
9 | AXP.N | 42838000000.0 | 29380000000.0 |
10 | VZ.N | 133613000000.0 | 77312000000.0 |
11 | HD.N | 151157000000.0 | 50832000000.0 |
12 | WBA.OQ | 132509000000.0 | 28067000000.0 |
13 | MCD.N | 23222900000.0 | 12580200000.0 |
14 | UNH.N | N/A | N/A |
15 | KO.N | 38655000000.0 | 23298000000.0 |
16 | JNJ.N | 93775000000.0 | 63920000000.0 |
17 | MSFT.OQ | 168088000000.0 | 115856000000.0 |
18 | HON.OQ | 34392000000.0 | 10998000000.0 |
19 | CRM.N | 26492000000.0 | 19466000000.0 |
20 | PG.N | 76118000000.0 | 39144000000.0 |
21 | IBM.N | 57350000000.0 | 31485000000.0 |
22 | MMM.N | 35355000000.0 | 16579000000.0 |
23 | AAPL.OQ | 365817000000.0 | 152836000000.0 |
24 | WMT.N | 572754000000.0 | 143754000000.0 |
25 | CAT.N | 50971000000.0 | 15517000000.0 |
26 | AMGN.OQ | 25979000000.0 | 19525000000.0 |
27 | V.N | 24105000000.0 | 19135000000.0 |
28 | TRV.N | N/A | N/A |
29 | BA.N | 62286000000.0 | 3017000000.0 |
The following example demonstrates how to retrieve the revenue and gross profit for GOOG.O and APPL.O with applied global parameters:
response = fundamental_and_reference.Definition(
universe=["GOOG.O", "AAPL.O"],
fields=["TR.Revenue", "TR.GrossProfit"],
parameters={"SDate": "0CY", "Curn": "CAD"}
).get_data()
print(response.data.df)
Response
Instrument | Revenue | Gross Profit | |
---|---|---|---|
0 | GOOG.O | 232356871000 | 124493035000 |
1 | AAPL.O | 462831668400 | 193368107200 |
The following example demonstrates how to retrieve the revenue and gross profit for TRI.N and IBM.N with full names in the headers:
response = fundamental_and_reference.Definition(
universe=["TRI.N", "IBM.N"],
fields=["TR.Revenue", "TR.GrossProfit"],
use_field_names_in_headers=True
).get_data()
print(response.data.df)
Response
Instrument | TR.REVENUE | TR.GROSSPROFIT | |
---|---|---|---|
0 | TRI.N | 6348000000 | 6022000000 |
1 | IBM.N | 57350000000 | 31485000000 |
The following example demonstrates how to retrieve the revenue and gross profit for TRI.N and IBM.N using date as the row header:
response = fundamental_and_reference.Definition(
universe=["TRI.N", "IBM.N"],
fields=["TR.Revenue", "TR.GrossProfit"],
row_headers="date"
).get_data()
print(response.data.df)
Response
TRI.N | IBM.N | |||
---|---|---|---|---|
Revenue | Gross Profit | Revenue | Gross Profit | |
Date 2021-12-31 |
6348000000 | 6022000000 | 57350000000 | 31485000000 |
Related links
None