How to pull bond data from GOVSRCH using Codebook?

oscar.guitet

Hi, I would like to pull bond data from the GOVSRCH universe.

I have used the Codebook tutorial to pull Enterprise Value data from 3 universes as below:

df = rd.get_data(universe=['LSEG.L', 'VOD.L', 'GOOGL'], fields=['TR.EV','TR.EVToSales'])

From the filters, it seems that GOVSRCH like it is a universe on it's own.

So when attempting to pull a specific bond's data, for example GOOGL, I have tried searching with the Preferred RIC:

df = rd.get_data( universe = 'GOVSRCH', fields = ['02079KAB3='], parameters = ['ISIN']

This results in the following error:

Failure sending request with <refinitiv.data.content.fundamental_and_reference.Definition object at 0x7f57140dd340 {universe='['GOVSRCH']', fields='['TR.RIC']', parameters='['Coupon']', row_headers='None'}>
Traceback (most recent call last):
  File "/opt/conda/lib/python3.8/site-packages/refinitiv/data/_fin_coder_layer/get_data.py", line 67, in get_adc_data
    response = definition.get_data()
  File "/opt/conda/lib/python3.8/site-packages/refinitiv/data/content/fundamental_and_reference/_definition.py", line 224, in get_data
    response = super().get_data(session, on_response_filter)
  File "/opt/conda/lib/python3.8/site-packages/refinitiv/data/content/_content_provider_layer.py", line 45, in get_data
    return super().get_data(session, on_response)
  File "/opt/conda/lib/python3.8/site-packages/refinitiv/data/delivery/_data/_data_provider_layer.py", line 106, in get_data
    response = self._provider.get_data(
  File "/opt/conda/lib/python3.8/site-packages/refinitiv/data/delivery/_data/_data_provider.py", line 74, in get_data
    request = self.request.create(session, *args, **kwargs)
  File "/opt/conda/lib/python3.8/site-packages/refinitiv/data/content/fundamental_and_reference/_data_provider.py", line 171, in create
    body_parameters = self.get_body_parameters(*args, **kwargs)
  File "/opt/conda/lib/python3.8/site-packages/refinitiv/data/content/fundamental_and_reference/_data_provider.py", line 194, in get_body_parameters
    kwargs = validate_correct_format_parameters(*_, **kwargs)
  File "/opt/conda/lib/python3.8/site-packages/refinitiv/data/content/fundamental_and_reference/_data_provider.py", line 113, in validate_correct_format_parameters
    raise ValueError(f"Arg parameters must be a dictionary")
ValueError: Arg parameters must be a dictionary

I also get a similar error when searching via the ISIN

How do I pull bond data using Codebook? Any assistance is greatly appreciated, thank you in advance.

aramyan.h

Hi @oscar.guitet ,

Thank you for your question. You can't use GOVSRCH as universe in your request unfortunately.

Is all the fields you are after exist in your GOVSRCH output? If so, the best way I could think of is using Export query functionality of the Workspace:

Then a new window appears and clicking on the Codebook field you will get a python query with search capabilities which will allow you returning the same values you see in GOVSRCH via an API call:

In case you want other fields not available in GOVSRCH or you want time series data, we can retrieve the rics via search query and can request the fields/series via rd.get_data/rd.get_history function. Happy to help you on that if necessary.

Hope this was helpful. Please feel free to let me know should you have any further question.

Best regards,

Haykaz