How to extract field COMM_LAST (default returned from refinitiv.data.get_history) from datascope REST API?
I can pull COMM_LAST from the refinitiv.data.get_history, but the same ric is returned as not found in datascope InstrumentListValidateIdentifiers.
def validate_instrument(token, ins_list): url = "https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/InstrumentListValidateIdentifiers" request_data = { "InputsForValidation": [ { "Identifier": ins, "IdentifierType": "Ric" } for ins in ins_list ], "KeepDuplicates": True } headers = {'Prefer': 'respond-async', 'Content-Type': 'application/json; odata.metadata=minimal', 'Accept-Charset': 'UTF-8', 'Authorization': 'Token%s' % token} resp = post(url, data=None, json=request_data, headers=headers) if resp.status_code == 200: return resp.json() else: raise ValueError('request failed')
{'Severity': 'Info', 'Message': 'RIC, TCP-USTOT-DP (not found)'},
For example. for RIC TCP-USTOT-DP
import refinitiv.data as rd tickers = ["TCP-USTOT-DP"] with rd.open_session() as session: df = rd.get_history( universe = tickers, start="2000-01-01" )
TCP-USTOT-DP COMM_LAST
Date
2022-10-31 1167906
2022-11-30 1202304
2022-12-31 1209012
2023-01-31 1205337
2023-02-28 1100262
2023-03-31 1231918
2023-04-30 1169980
2023-05-31 1203666
2023-06-30 1170317
2023-07-31 1155782
2023-08-31 1156500
2023-09-30 1149658
2023-10-31 1194253
2023-11-30 1158556
2023-12-31 1197740
2024-01-31 1200917
2024-02-29 1139985
2024-03-31 1223777
2024-04-30 1188261
2024-05-31 1212718
And I can not pull any values