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
the.swiss avatar image
3 ●0 ●1 ●4

getting data from my stored portfolios - veeeery slow - what am i missing?

Hi there

I am calling up the content of the portfolios i created/maintain in PAL (WORKSPACE).

api call : rd.content.fundamental_and_reference.Definition(universe[thisPortfolioCall],fields = refinitivFieldsToGetLoc).get_data()

where:

thisPortfolioCall is a single portfolio like 'Portfolio(SMIconstituents)'

refinitivFieldsToGetLoc is data i need like

['TR.CompanyReportCurrency', 'TR.PriceClose.Currency', 'TR.PortfolioShares', 'TR.PriceClose(SDate=2023-09-18)', 'TR.PriceClose(SDate=2023-09-18, CURN=USD)', 'TR.PortfolioWeight', 'TR.CompanyMarketCap']

It works but it is veeeery slow, like 2 min for 28 portfolios with a total of about 350 assets in them all.

Normal?

Better way?

Cheers for pointers

Alfred

#technologyrdp-apipython api
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.

3 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
80k ●257 ●52 ●75

@the.swiss

Thank you for reaching out to us.

Does it mean that the application called the get_data method 28 times (one for each portfolio)?

If yes, it takes around 5 seconds for each request.

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.

Upvotes
the.swiss avatar image
3 ●0 ●1 ●4

Hi Jirapongse

Yes it does. All else ended up in 400 type errors before as I remember. This one still is temperamental and gets stuck at times for longer.

No comparison to how speedy time_series download.

Is there a better way to obtain portfolio content?

Btw. Is there a way to query all stored portfolios and watchlist under my user?

i.e. when I add one of them need to add the codes manually to my query.

Cheers

Alfred


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.

Upvotes
Jirapongse avatar image
80k ●257 ●52 ●75

@the.swiss

Spilting the query is a proper way to avoid the 400 type error (Error code 400 | Backend error. 400 Bad Request).

As I know, I don't think we can use the RD libary to create or update portfolios.


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.