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
3 0 0 1

For ticker (RIC) EFIV.N , I want to pull DERIVED HOLDINGS (Full Holdings). How can I pull that using Eikon API ?

For ticker (RIC) EFIV.N , I want to pull DERIVED HOLDINGS (Full Holdings). How can I pull that using Eikon API ? Below is the screenshot from Eikon.


eikon-data-apirefinitiv-dataplatform-eikon#technology#content
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.

1 Answer

· Write an Answer
Upvotes
Accepted
1.6k 3 2 3

anonymous user ,

Below is the Python code I tried to get the holdings for that ETF via Eikon API (my app key is removed) from the Codebook:

import refinitiv.dataplatform.eikon as ek
# import eikon as ek
import pandas as pd

ek.set_app_key('xxxxxxxxxxxxxxxxxxxxxxxxxxxx')

fund_holdings = ek.get_data('EFIV.N', ['TR.FundHoldingRIC','TR.FundHoldingName',
    'TR.FundPercentageOfFundAssets',
    'TR.FundNumberOfShares',
    'TR.FundNumberOfSharesChanged'],
    {'Endnum':'5000'})

print(fund_holdings)

I got the results below.

(    Instrument Holding RIC                   Holding Name  \
0       EFIV.N     AAPL.OQ                  APPLE INC ORD   
1       EFIV.N     MSFT.OQ             MICROSOFT CORP ORD   
2       EFIV.N     AMZN.OQ             AMAZON.COM INC ORD   
3       EFIV.N     NVDA.OQ                NVIDIA CORP ORD   
4       EFIV.N    GOOGL.OQ       ALPHABET INC CLASS A ORD   
..         ...         ...                            ...   
320     EFIV.N       LNC.N      LINCOLN NATIONAL CORP ORD   
321     EFIV.N      NWL.OQ          NEWELL BRANDS INC ORD   
322     EFIV.N      NWS.OQ                  NEWS CORP ORD   
323     EFIV.N                                   USD CASH   
324     EFIV.N              OTHER ASSETS LESS LIABILITIES   

     Percentage of Fund Assets  Number of Shares  Number of Shares Changed  
0                       9.7322          505385.0                   39760.0  
1                       8.5397          254189.0                   20020.0  
2                       4.3167          305148.0                   24717.0  
3                       4.2761           84525.0                    6650.0  
4                       2.8356          203155.0                   15960.0  
..                         ...               ...                       ...  
320                     0.0139            5298.0                     420.0  
321                     0.0139           12840.0                     980.0  
322                     0.0092            4075.0                     350.0  
323                     0.0033          32454.75                   23945.6  
324                    -0.0093              <NA>                      <NA>  

[325 rows x 6 columns], None)
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.