Require assistance in downloading Index Data for US based Fixed Income Indexs and Index for commodity traded in US . For commodity i cannot find the appropriate RICs for Index
.For Fixed income index Ex. (.MERB0B0) need assistance in downloading the daily Total return
15
●6 ●8 ●11
How to Find Daily Total return for US based Index.
Hi,
Thank you for your participation in the forum.
Is the reply below satisfactory in answering your question?
If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
14.2k
●30 ●5 ●10
Hi @BlackBird ,
Regarding retrieving the daily total return of the .MERB0B0, the libraries below can be used
- Refinitiv Data Library for Python, and here's its quick start guide
import refinitiv.data as rd rd.open_session() rd.get_data( universe=['.MERB0B0'], fields=['TR.DAILYTOTALRETURN.date', 'TR.DAILYTOTALRETURN'], parameters = {'SDate': '0', 'EDate': '-10', 'Frq': 'D'} )
- Eikon Data API, and here's its quick start guide
import refinitiv.data.eikon as ek ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY') df, err = ek.get_data(['.MERB0B0'], ['TR.DAILYTOTALRETURN.date', 'TR.DAILYTOTALRETURN'], parameters = {'SDate': '0', 'EDate': '-10', 'Frq': 'D'}) df
Regarding getting the appropriate RICs for commodities traded in US, as the moderators on this forum do not have deep expertise in every type of content available through Refinitiv products. Such expertise is available through Refinitiv Helpdesk, which can be reached via MyRefinitiv and you can ask them for the proper RICs to be used.
Hope this helps and please let me know in case you have any further questions
