dax = ek.get_data("0#NBNW*.NS", fields=fields)[0]
In Single request how to pass multiple RICS.
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
1
●2 ●6 ●8
How to pass multiple RICS in get_data() ?
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate 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 has been marked as such.
Thanks,
AHS
24.7k
●54 ●17 ●14
Hello @anbezhilasokan.frm
You can pass multiples RICs to the get_data function as a list like the following example:
df, err = ek.get_data(['GOOG.O','MSFT.O', 'FB.O'], [ 'TR.Revenue','TR.GrossProfit'])
Please see more detail in the following resources:
1
●2 ●6 ●8
2021-04-02 17:17:52,390 P[18196] [MainThread 27652] Failed to decode response to json: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><html><head><title>Sign In</title><meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7"/><meta http-equiv="content-type" content="text/html; charset=utf-8"/><META page=login><link rel="icon" type="image/vnd.microsoft.icon" href="/favicon.ico"/><link rel="shortcut icon" href="/favicon.ico"/><link rel="stylesheet" type="text/css" href="/auth/css/charcoal_commonstyles_spr.css?v=_3.43.3501.01"/><link rel="stylesheet" type="text/css" href="/auth/css/refinitiv_charcoal_loginstyles_spr.css?v=patchRFCharcoal12-12-20_3.43.3501.01"/><script type="text/javascript" src="/auth/js/signin_spr.js?v=_3.43.3501.01"></script><script type="text/javascript" src="/js/as.js?v=_3.43.3501.01"></script><script src="/auth/js/jquery-1.10.1.min.js"></script><script src="/auth/js/jquery-as.js?v=_3.43.3501.01"></script><script type='text/javascript'>function openHelpLink(){var link="https://my.refinitiv.com/content/mytr/en/productsupport.html";window.open(link)}function initial(){elementFocus("AAA-AS-SI1-SE003");$("#AAA-AS-SI1-SE008_Value").val("FALSE");$("#AAA-AS-SI1-SE008_CheckBox_TRUE").checkbox({"checkedValue":"TRUE"});$("#AAA-AS-SI1-SE009").click(asUtils.forwardClick("#AAA-AS-SI1-SE008_CheckBox_TRUE"))};</script></head><body onload="initial()" style="overflow:hidden;"><div class='main'><div class="space_top"></div><div class="content_center"><div class="header"><div class='header_bar_right'><div class='close_btn'><a class="close_icon" id="AAA-AS-SI-SE023" href="javascript:closeWindow();" tabindex="-1"></a></div><div class="language_bar"><div class="language_box" onclick="onClickLanguageBox('AAA-AS-SI-C005');" onkeydown="return onPressLanguageBox(event, 'AAA-AS-SI-C005');"><div class="language_select" onmouseover='changeHover(this,"language_select",true)' onmouseout='changeHover(this,"language_select",false)' onfocus='changeHover(this,"language_select",true)' onblur='changeHover(this,"language_select",false)' tabIndex="8"><div class="language_text" id='AAA-AS-SI-SE020'>English
</div></div><div id="AAA-AS-SI-C005" class="language_list_box"><a id="en-US" class="language_item" onclick="onSelectLanguage('en-US', '/auth/UI/Login?MinorVersion=0&RequestID=85DFE5BBC00FFB377446ED69B51611093346AEB6E191D2EDB745612B51795E35&theme=charcoal&ProviderID=https%3A%2F%2Fapac1.proxy.cp.thomsonreuters.com%3A443%2Famagent&IssueInstant=2021-04-02T11%3A47%3A50Z&MajorVersion=1&goto=%2Fauth%2Fcdcservlet%3FTARGET%3Dhttps%253A%252F%252Fapac1.apps.cp.thomsonreuters.com%252FApps%252FUDF%252FMSF%253Fampostpreserve%253Da3df3546-ed4e-ea43-b916-32871d778aa8%2526srv%253DSTCP-ERPCPRP04%26MinorVersion%3D0%26RequestID%3D85DFE5BBC00FFB377446ED69B51611093346AEB6E191D2EDB745612B51795E35%26theme%3Dcharcoal%26ProviderID%3Dhttps%253A%252F%252Fapac1.proxy.cp.thomsonreuters.com%253A443%252Famagent%26IssueInstant%3D2021-04-02T11%253A47%253A50Z%26MajorVersion%3D1%26locale%3Den-US&locale=en-US' ,'AAA-AS-SI-C005', 'AAA-AS-SI-C004', 'AAA-AS-SI-SE020')" href="#" tabIndex='-1'> English </a><a id="ja-JP" class="language_item" onclick="onSelectLanguage('ja-JP', '/auth/UI/Login?MinorVersion=0&RequestID=85DFE5BBC00FFB377446ED69B51611093346AEB6E191D2EDB745612B51795E35&theme=charcoal&ProviderID=https%3A%2F%2Fapac1.proxy.cp.thomsonreuters.com%3A443%2Famagent&IssueInstant=2021-04-02T11%3A47%3A50Z&MajorVersion=1&goto=%2Fauth%2Fcdcservlet%3FTARGET%3Dhttps%253A%252F%252Fapac1.apps.cp.thomsonreuters.com%252FApps%252FUDF%252FMSF%253Fampostpreserve%253Da3df3546-ed4e-ea43-b916-32871d778aa8%2526srv%253DSTCP-ERPCPRP04%26MinorVersion%3D0%26RequestID%3D85DFE5BBC00FFB377446ED69B51611093346AEB6E191D2EDB745612B51795E35%26theme%3Dcharcoal%26ProviderID%3Dhttps%253A%252F%252Fapac1.proxy.cp.thomsonreuters.com%253A443%252Famagent%26IssueInstant%3D2021-04-02T11%253A47%253A50Z%26MajorVersion%3D1%26locale%3Dja-JP&locale=ja-JP' ,'AAA-AS-SI-C005', 'AAA-AS-SI-C004', 'AAA-AS-SI-SE020')" href="#" tabIndex='-1'> 日本語 </a><a id="zh-CN" class="language_item" onclick="onSelectLanguage('zh-CN', '/auth/UI/Login?MinorVersion=0&RequestID=85DFE5BBC00FFB377446ED69B51611093346AEB6E191D2EDB745612B51795E35&theme=charcoal&ProviderID=https%3A%2F%2Fapac1.proxy.cp.thomsonreuters.com%3A443%2Famagent&IssueInstant=2021-04-02T11%3A47%3A50Z&MajorVersion=1&goto=%2Fauth%2Fcdcservlet%3FTARGET%3Dhttps%253A%252F%252Fapac1.apps.cp.thomsonreuters.com%252FApps%252FUDF%252FMSF%253Fampostpreserve%253Da3df3546-ed4e-ea43-b916-32871d778aa8%2526srv%253DSTCP-ERPCPRP04%26MinorVersion%3D0%26RequestID%3D85DFE5BBC00FFB377446ED69B51611093346AEB6E191D2EDB745612B51795E35%26theme%3Dcharcoal%26ProviderID%3Dhttps%253A%252F%252Fapac1.proxy.cp.thomsonreuters.com%253A443%252Famagent%26IssueInstant%3D2021-04-02T11%253A47%253A50Z%26MajorVersion%3D1%26locale%3Dzh-CN&locale=zh-CN' ,'AAA-AS-SI-C005', 'AAA-AS-SI-C004', 'AAA-AS-SI-SE020')" href="#" tabIndex='-1'> 中文简体 </a></div><input class='hiddensubmit' type="hidden" id="AAA-AS-SI-C004" name="AAA-AS-SI-C004" value="en-US"/></div></div></div></div><div class="body_main"><div class="signin_body_content"><div class="body_brand"><div id="AAA-AS-SI-SE006" class="product_brand_image"></div></div><div class="body_input"><form name="frmSignIn" action="blank" onSubmit="return defaultSubmit('AAA-AS-SI1-SE014')" method="post"><table width='100%' cellspacing="1" cellpadding="0" border="0"><tr class='signin_input_row'><td width='76px'><label class='topic_txt' id="AAA-AS-SI1-SE002" for='IDToken1'> User ID: </label></td><td><div class="textbox_img textbox_img_big2"><input type="text" id="AAA-AS-SI1-SE003" name="IDToken1" value="" autocomplete="off" tabIndex='1'/></div></td></tr><tr class='signin_userid_hint'><td> </td><td><label class="small_font " id="AAA-AS-SI1-SE004">Hint: This is usually your work email address</label></td></tr><tr class='signin_input_row'><td><label class='topic_txt' id="AAA-AS-SI1-SE005" for="IDToken2"> Password: </label></td><td><div class="textbox_img textbox_img_normal"><input type="password" id="AAA-AS-SI1-SE006" tabIndex="2" name="IDToken2" value="" autocomplete="off"/></div></td></tr><tr><td> </td><td><a id="AAA-AS-SI1-SE007" href="javascript:requestForgottenPassword(document.frmRequestFP,document.getElementById('AAA-AS-SI1-SE003').value,'en-US','charcoal','refinitiv','null');" tabIndex="5"> Forgotten your password? </a></td></tr></table><div class='signin_autoarea'><div id="AAA-AS-SI1-SE008"><a id="AAA-AS-SI1-SE008_CheckBox_TRUE" class="checkbox" href="javascript:void(0)" tabIndex="3" data-value="#AAA-AS-SI1-SE008_Value"></a> <a id="AAA-AS-SI1-SE009" class='checkbox_label' href="javascript:void(0)" tabIndex="-1"> Sign me in automatically </a><input type="hidden" class='hiddensubmit' id="AAA-AS-SI1-SE008_Value" name="IDToken3" value="FALSE"/></div><div class="small_font signin_autohint " id="AAA-AS-SI1-SE010"> Do not use if device is shared. </div><input id="Submit1" type="submit" class="hiddensubmit" hideFocus="true" tabIndex='-1'/></div><div class='buttonarea' id="buttonarea_AAA-AS-SI1"><script type='text/javascript'>createImageButton("AAA-AS-SI1-SE014","Sign In","defaultSubmit(\\'AAA-AS-SI1-SE014\\')",4,"button_75",true);createImageButton("AAA-AS-SI1-SE015","Cancel","closeWindow()",7,"button_75");</script></div><div class="signin_errormsg" id="AAA-AS-SI1-SE012"></div></form></div></div></div><div class="footer"><div id="AAA-AS-SI-SE009" class="footer_sep"></div><div class="footer_content"><a id="AAA-AS-SI-SE015" href="https://my.refinitiv.com/content/mytr/en/signin.html" target="_blank" tabIndex="9"> MyRefinitiv </a><span class="footer_content_sep"></span><a id="AAA-AS-SI-SE016" href="https://www.refinitiv.com/en/policies/privacy-statement" target="_blank" tabIndex="10"> Privacy Statement </a><span class="footer_content_sep"></span><a id="AAA-AS-SI-SE017" href="https://www.refinitiv.com/en/about-us" target="_blank" tabIndex="11"> About Us </a><span class="footer_content_sep"></span><a id="AAA-AS-SI-SE012" href="https://my.refinitiv.com/content/mytr/en/productsupport.html" target="_blank" tabIndex="12"> Help </a></div></div></div></div><form name="frmRequestFP" action="" method="post"><input type="hidden" name="userId" value=""/><input type="hidden" name="locale" value=""/></form><form name="Login" action="/auth/UI/Login" method="post"><input type="hidden" name="goto" value="L2F1dGgvY2Rjc2VydmxldD9UQVJHRVQ9aHR0cHMlM0ElMkYlMkZhcGFjMS5hcHBzLmNwLnRob21zb25yZXV0ZXJzLmNvbSUyRkFwcHMlMkZVREYlMkZNU0YlM0ZhbXBvc3RwcmVzZXJ2ZSUzRGEzZGYzNTQ2LWVkNGUtZWE0My1iOTE2LTMyODcxZDc3OGFhOCUyNnNydiUzRFNUQ1AtRVJQQ1BSUDA0Jk1pbm9yVmVyc2lvbj0wJlJlcXVlc3RJRD04NURGRTVCQkMwMEZGQjM3NzQ0NkVENjlCNTE2MTEwOTMzNDZBRUI2RTE5MUQyRURCNzQ1NjEyQjUxNzk1RTM1JnRoZW1lPWNoYXJjb2FsJlByb3ZpZGVySUQ9aHR0cHMlM0ElMkYlMkZhcGFjMS5wcm94eS5jcC50aG9tc29ucmV1dGVycy5jb20lM0E0NDMlMkZhbWFnZW50Jklzc3VlSW5zdGFudD0yMDIxLTA0LTAyVDExJTNBNDclM0E1MFomTWFqb3JWZXJzaW9uPTE="/><input type="hidden" name="encoded" value="true"/><input type="hidden" name="locale" value="en-US"/><input type="hidden" name="product" value=""/><input type="hidden" name="eso" value=""/><input type="hidden" name="username" value=""/><input type="hidden" name="IDButton" value=''/><input type="hidden" name="fs" value=""/><input type="hidden" name="epaid" value=""/><input type="hidden" name="realm" value=""/><input type='hidden' name='IDToken1'/><input type='hidden' name='IDToken2'/><input type='hidden' name='IDToken3'/><input type='hidden' name='IDToken4'/><input type="hidden" name="gx_charset" value="UTF-8"/></form></body></html>
----------------------------
39.4k
●77 ●11 ●27
This HTML response looks like a login page, which indicates that your Eikon or Refinitiv Workspace application is not signed in (or have been signed off). One reason may be an exclusive sign-on event, which occurs for example when your account credentials are used to sign in to Eikon or Refinitiv Workspace from another machine. Try restarting Eikon or Refinitiv Workspace and then executing your code again.
I should add to the response from @wasin.waeosri that while it's perfectly possible to use a list of RICs in get_data method, using a list of chain RICs as input is not supported. You can only retrieve one chain at a time.
