{"id":27992,"date":"2024-06-09T11:27:34","date_gmt":"2024-06-09T09:27:34","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/i-can-not-figure-out-how-to-use-refinitiv-with-python\/"},"modified":"2024-06-09T11:27:34","modified_gmt":"2024-06-09T09:27:34","slug":"i-can-not-figure-out-how-to-use-refinitiv-with-python","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/i-can-not-figure-out-how-to-use-refinitiv-with-python\/","title":{"rendered":"I Can Not Figure Out How To Use Refinitiv With Python"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>I have a really heavy excel file 400K rows, and I need, using cusip or ticker and date of shareholder meeting (variables for each row) to download data such as revenues, total asset, market cap, etc. for my thesis. I tried excel =TR(&#8230;) formula, but does not recognise cusip or ticker, while datastream recognise the ticker or <a href=\"https:\/\/www.reddit.com\/u\/ticker\">u\/ticker<\/a> but when I run the formula for all rows my file stop to work, and excel crash. Therefore I tried using chatgpt trying to use python but it seems there is not a way to use datastream through python or at least I don&#8217;t have accademic API key. I have eikon and refinitiv API key. I tried using eikon but even through python can&#8217;t find the data, showing N\/A or ticker not found, even if looking for the ticker within desktop app, the company can be found. If a value is found is different than the one downloaded in the few rows where datastream in excel worked. I don&#8217;t know how to populate my heavy database without crash.<br \/> Python provide several errors or no data (N\/A)<br \/> What do you suggest?<br \/> First example<br \/> <a href=\"https:\/\/ibb.co\/R47Cp56\">https:\/\/ibb.co\/R47Cp56<\/a><\/p>\n<p><a href=\"https:\/\/ibb.co\/QfXckzT\">https:\/\/ibb.co\/QfXckzT<\/a><\/p>\n<p><a href=\"https:\/\/ibb.co\/vH7F5ZM\">https:\/\/ibb.co\/vH7F5ZM<\/a><\/p>\n<p><a href=\"https:\/\/ibb.co\/S5rKyqn\">https:\/\/ibb.co\/S5rKyqn<\/a><\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/Low_Seat419\"> \/u\/Low_Seat419 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1dbp6pd\/i_can_not_figure_out_how_to_use_refinitiv_with\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1dbp6pd\/i_can_not_figure_out_how_to_use_refinitiv_with\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-27992 jlk' href='javascript:void(0)' data-task='like' data-post_id='27992' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-27992 lc'>0<\/span><\/a><\/div><\/div> <div class='status-27992 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>I have a really heavy excel file 400K rows, and I need, using cusip or ticker and&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-27992","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/27992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=27992"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/27992\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=27992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=27992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=27992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}