EOD close price for ETFs
using the funds API, I want to get the EOD close adjusted price for ETFs.
I am using this (it has 2 ETFs and one mutual fund).
for the ETFs (SPY.N and QQQ.N) I get MID and NAV and for the mutual fund FCNTX I get NAV and OFFER.
I believe MID is the midpoint before the close? How do I get the auction price? and how do I get the data adjusted for splits, dividends, cap gains distributions etc....
Thanks
Best Answer
-
@kdayri , MID price is the "market close price" for Lipper's contents. The code for that is a bit strange due to historical reason. You should check some sample values to make sure it matches your definition of "EOD adjusted price". In case you have doubts, please raise a content query to Lipper's contents team or via the client support team.
0
Answers
-
I cant get adjusted and unadjusted prices in the funds API? how odd.
0 -
@kdayri and @wasin.w , Lipper’s database only store official prices (NAV, Bid , Offer) published by fund companies. The MID price is a special case that it is market close price from Exchange for funds traded in Exchange or it is the index value if it is an index. If you are asking for prices that adjusted for dividend payment and other corporate events (unit split/merge), so that you can use the adjusted price to indicate the funds’ total return history, then currently the API do not offer that directly.
You can try to derive that based on dividend information or more the fund’s total return performance data: rolling performances data set. If your “adjusted / unadjusted” price means something else, please clarify the definitions.
For funds’ total return history, it is typically showing the % growth or some indexed value rather than using the adjusted price (which just a form of the index).
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛