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 bogdan.pop · Sep 17, 2018 at 12:24 PM · eikoneikon-data-apiworkspacepythonworkspace-data-apirefinitiv-dataplatform-eikonapieikon-com-apipricingexcel

Can I retrieve the P/E and Auditor datapoint of a Fund (Unit Trust) in Excel using the API?

@bogdan.pop

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.

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov.1 · Sep 18, 2018 at 10:57 AM

It is possible to retrieve data shown in the Aggregates report straight into Excel. For an example in the Aggregates Report app click the dropdown next to Excel icon in the top right corner of the app window and select Export All as Formulas.

Alternatively use "Aggregates with TRAggregate" template spreadsheet you can find by clicking the Templates button in Thomson Reuters ribbon in Eikon Excel. Also check out the Help for TRAggregate function in Eikon Excel.
I don't believe it's possible to retrieve fund auditor name available in Fund Screener app into Excel using a worksheet function. However you may want to verify this with Thomson Reuters Helpdesk.


aggregates.png (85.5 KiB)
Comment
bogdan.pop

People who like this

1 Show 2 · 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
bogdan.pop · Sep 19, 2018 at 09:59 AM 0
Share

Once you export, in the control tab you have something like the below:

SCREEN(U(IN(I(148967794))))

the ID in the last bracket corresponds to the ID of the Fund you're looking to get data for. As I want to adapt the excel to get the data for multiple funds at once, I need this specific fund ID for each.

Thus, is there a way to get the ID in bracket above, with the API in excel looking by Eikon RIC or fund ISIN?

Thanks

Bogdan

avatar image
REFINITIV
Alex Putkov.1 ♦♦ bogdan.pop · Sep 19, 2018 at 03:01 PM 0
Share

This question like others related to using Eikon Excel worksheet functions and GUI (as opposed to programmatic data retrieval through APIs) is best directed to Thomson Reuters Helpdesk. I opened case #06934297 on your behalf with the Helpdesk. You will be contacted by the Helpdesk agent who will take the ownership of the case.

avatar image
REFINITIV
Answer by Alex Putkov.1 · Sep 17, 2018 at 03:49 PM

If you know that this data exists in Eikon, then could you please provide a screenshot of where you see it. If you don't know whether this data is available in Eikon, then the best resource for generic content questions such as this one is Thomson Reuters Helpdesk, which you can reach by calling the Helpdesk number in your country or by using Contact Us capability in your Eikon application.

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
Answer by bogdan.pop · Sep 18, 2018 at 05:09 AM

The Auditor name can be pull up using the "FSCREEN" app in Eikon.


1. In the Eikon Global Search box, type in "FSCREEN" and hit enter.
2. Click 'List" and then click the drop-down arrow and click Create New List
3. In the List Editor, click the drop-down arrow and select "Symbol". Now you can type symbols in the field and then click search.
4. Tick the box of the corresponding fund and click "Add" and then click OK.
5. Click "generate report" and click add column. In the Column Manager, type Auditor in the filter. Tick the box for Auditor Name and then click Add and OK.

what I'd like to know is if there is a way to get this info in Excel directly using the API.

and on a different note, I'd like to know if there is a way to get the P/E ratio of the fund (which you can see in the Aggregates Report app in Eikon) in Excel, using the API.

ideally, I'd want to have columns for all Trailing Valuation, Forward Valuation and Fundamental Ratios date, one after the other in excel, using the API.

Thanks

Bogdan

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 >
7 People are following this question.

Related Questions

Excel continuous retrieval of data

RHistory in Python

Field parameters in PYTHON EIKON API

Excel Add In - How do I add the date as a column to a time series

RHistory Excel - Receive multiple Instruments without redundant TIMESTAMP

  • 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
  • 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
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges