question

Upvotes
Accepted
23 0 0 3

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).

https://api.refinitiv.com/data/funds/v1/assets?properties=prices[start:2023-01-09%3Bend:2023-01-10]&symbols=SPY.N,QQQ.N,FCNTX

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


#contentfundsetfpricing-history
icon clock
10 |1500

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

Upvotes
Accepted
1.6k 3 2 3

@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.

icon clock
10 |1500

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

Hello @bob.lee

Could you please help with the follow up question below?

Upvotes
23 0 0 3

I cant get adjusted and unadjusted prices in the funds API? how odd.

icon clock
10 |1500

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

@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).

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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