Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

avatar image
Question by lena.demaison · Feb 16 at 04:34 PM · excelindexconstituentsformula-buildertimeseries

Excel formula builder: only 1 data point retrieved

Hi,

I am attempting to retrieve pricing data between 2016-2021 for all constituents of the Euro STOXX 600 index using Formula Builder in Excel. The formula appears to work but only returns one result.

I have also tried retrieving pricing data for the same time period using one individual stock with the same issue occurring.

This is my first time using Refinitiv in Excel so I'm not sure whether it's a simple error.

Thanks in advance :)

screenshot-2022-02-16-at-173247.png

screenshot-2022-02-16-at-173247.png (244.8 KiB)

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by raksina.samasiri · Feb 17 at 12:15 PM

Hi @lena.demaison ,

To get the constituent list, you can use the formula below

=@RDP.Data(".STOXX","TR.IndexConstituentName;TR.IndexConstituentRIC","CH=Fd RH=IN",B2)

1645099697670.png

Then from the RIC list retrieved, you can get their TR.PriceClose

=@RDP.Data($D$3:$D$602,"TR.PriceClose;TR.PriceClose.date","Curn=EUR SDate=2016-06-01 EDate=2017-06-01 Frq=W CH=Fd RH=IN",G2)

1645099800240.png

However,

  • the length of the time period provided is too long (rows exceed the limit), so I put the date until the year 2017 instead, you may put the shorter time range and call it multiple times instead
  • this is to retrieve historical TR.PriceClose of the current Constituents of '.STOXX' only

Lastly, This forum is dedicated to software developers using Refinitiv APIs.

The moderators on this forum do not have deep expertise in every bit of content available through Refinitiv products, which is required to answer content questions such as this one.

The best resource for content questions is the Refinitiv Helpdesk, which can be reached by either calling the Helpdesk number in your country or submitting a new ticket to the support team via MyRefinitiv.

The Helpdesk will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

Hope this could help


1645099697670.png (36.2 KiB)
1645099800240.png (107.2 KiB)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by jason.ramchandani01 · Feb 17 at 11:29 AM

@lena.demaison Please remove the two TR.IndexJL fields and add TR.CommonName field try the call again. I hope this can help.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
13 People are following this question.

Related Questions

Eikon Data API - Error requesting TR.IndexConstituentWeightPercent

Refinitiv add-in excel (Mac) creates formula but does not give any result

TR formula to get Market Classification by Market.

ETF constituent changes

Using API to pull the historical index constituents during a period of time

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • FX Venues
    • FX Trading – RFQ Maker
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • Yield Book Analytics
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges