For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 3

How to pass multiple RICS in get_data() ?

dax = ek.get_data("0#NBNW*.NS", fields=fields)[0]

In Single request how to pass multiple RICS.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

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

Upvotes
Accepted
11.5k 16 7 10

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:


icon clock
10 |1500

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

Upvotes
1 0 0 3

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>&nbsp;</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>&nbsp;</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> &nbsp; <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>

----------------------------

icon clock
10 |1500

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

Upvote
39.2k 75 11 27

@anbezhilasokan.frm

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.

icon clock
10 |1500

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

Click below to post an Idea Post Idea