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
Hi @kdayri ,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
@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.
I cant get adjusted and unadjusted prices in the funds API? how odd.
@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).
