Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
MaeAnthea.Diaz avatar image
16 ●1 ●1 ●2

Value and code retrieval using Eikon Python API

RICs.csv - the file containing a sample of 9000+ RICs (I need to run my code on a different file with 100,000 RICs, but for your experimentation purposes it will be easier to run the code on this file).


RDP Code to optimize - includes an RDP code that fails to work. Please note that I want to recover the data specifically with rdp.historical_pricing.summaries because there are some RICs whose data can only be retrieved with this code.

Here are the fields I want to recover:

  • bond fields: mid yield, mid price, ask price, ask yield, bid yield, bid price, ratings, transaction volume.
  • dates: 2016 Jan 1 - 2021 Dec 31
  • interval: monthly

Sample Output - Eikon.csv - includes a sample output generated through the eikon library. In other words, I want to have the code with rdp.historical_pricing.summaries that retrieves output of this type because with rdp.historical_pricing.summaries might add additional data that is not being retrieved by eikon libraries (as you can see, there are several N/As in the output).


For now I would only kindly ask you to provide a sample code for the RDP library or edit mine (with rdp.historical_pricing.summaries). I solved the issue with rd.get_data myself.

eikon-data-apirdp-apipython apirdp
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

zoya faberov avatar image   zoya faberov
Hello @MaeAnthea.Diaz ,

Were you going to attach zipped files to this question, looks like they did not go through?

What is the error that you see on request?

Have you tried partitioning (chunking) the required list into smaller lists, requesting these sub-lists and reassembling the result?

Are you using older RDP library or newer Refiniv Data (RD) library?

wasin.w avatar image   wasin.w

Hello @MaeAnthea.Diaz

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS


Jirapongse avatar image   Jirapongse

@MaeAnthea.Diaz

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvote
Accepted
zoya faberov avatar image
32.2k ●40 ●11 ●20

Hello @MaeAnthea.Diaz ,

I have found that a very similar requirement was discussed on the dev forums before, please see this previous discussion thread.

If the issue the error that the client is facing is timeout? then as discussed in more detail in the linked thread, the approach that is likely to work best is:

  1. Obtain and use the latest RD library
  2. Partition the required list into sublists, a.k.a. "chunking"
  3. Request the required content for each sub-list, iterating through them and saving the result
  4. Assemble or concatenate the obtained results

You may wish to encourage the developer you are working with to register on dev portal, and participate in dev forums directly.

Hope that this helps

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.