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 /
avatar image
Question by J13513 · Jun 11, 2019 at 09:43 AM · python apitimeseriesfundsetffund performance

Python Data API - retrieving time series data for FUNDS - Performance

I am attempting to pull data < 1month, preferably daily timeseries performance data for funds and etfs ie: for

LP68467397 & LP68402195. Kindly help!

timeseries.png

timeseries.png (22.5 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 Wan Po.Lee · Jun 12, 2019 at 09:46 PM

@J13513, If you need daily performance for funds (Lipper data), you need to check with your account manager on other products. Lipper do have desktop and data feeds products able to provide daily performance.

If you insist on using Eikon API, the best I can find is weekly performance up to 1 year. You can use the function under "Lipper Funds":

"TR.FundRollingPerformance(RollTimeFrame=1Y Interval=W)"
Comment
J13513

People who like this

1 Show 1 · 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
J13513 · Jun 13, 2019 at 03:56 AM 0
Share

Thank-you once again @Wan Po.Lee - this is very useful. I do indeed have access to the 'Lipper for Investment Management' - will check this out also.

avatar image
REFINITIV
Answer by marcin.bunkowski · Jun 11, 2019 at 09:52 AM

Hi @J13513

To get time series data for funds it is advised to use NAV values.

Here is the example:

df, err=ek.get_data(['LP68467397','LP68402195'],['TR.NETASSETVAL.date','TR.NETASSETVAL'], {'SDate':'-1AM', 'Edate':'0D'})
df
Comment

People who like this

0 Show 4 · 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
Wan Po.Lee · Jun 11, 2019 at 08:54 PM 0
Share

The fund prices (e.g. NAV) from Lipper is the raw price reported by fund houses, it may not reflect the total return performance of the fund. For example, the NAV is not adjusted for distributions paid out nor events like unit split / merge.

avatar image
J13513 Wan Po.Lee · Jun 12, 2019 at 05:30 AM 0
Share

Thank-you both for your input @marcin.bunkowski & @Wan Po.Lee. @Wan Po.Lee @marcin.bunkowski would you be able to suggest how I might find time-series data that matches that on Eikon for these funds - I'm looking for the same 'Cumulative Performance' via the API except, more frequently than just the discrete 1month-3month-6month. Daily would be preferable - I've attached a cumulative-fund-perf.png , data-item-browser.pngscreenshot for clarity.

Your help is much appreciated.

cumulative-fund-perf.png (63.3 KiB)
data-item-browser.png (75.6 KiB)
avatar image
REFINITIV
marcin.bunkowski J13513 · Jun 12, 2019 at 06:01 AM 0
Share

Hi @Wan Po.Lee

Currently there is no possibility to retrieve that data for a custom interval using Eikon, only predefined periods are available.

However you can calculate it using one of our other products - Lipper for Investment Management. For more details please reach out to your Account Manager.

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

Related Questions

Include current price in hourly prices time series, python API

How to get a list of fund from certain criteria?

How can I get bid and ask prices in a 1-min intervale from Python API for LCOc1 and LCOTc1?

Time series using ek.get_data

Default price for bonds - Python API

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • 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
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges