-
Retrieving Data using Datastream Codes
Hi, I am trying to retrieve data using datastream codes from Excel Add-in (workspace). But, whenever I give LSEG instructions to download the data, even if it is for one company, it shows "Retrieving" forever. What can I do to download data? Please help!
-
'NoneType' object has no attribute 'get' error for API data
Hello all, I am trying to download a list of index constituents using the eikon data API, however, i am getting a 'NoneType' object has no attribute 'get' error for this code : import eikon as ek import pandas as pd from tqdm import tqdm # Import tqdm for progress tracking Your Datastream API keyapi_key = 'kEY ' Initialize…
-
Would appreciate an explanation for it?
I am trying to pass a request for a ticker symbol, that is valid. Still it always throws an error with message of Investor Full Name. Any idea what is about? I can relate it to having investor names empty and so on.
-
Generic Contract RIC
Is there concept of a generic contract RIC? For example in Bloomberg, CL1 refers to the current active WTI Crude contract. This points to CLX4 now, and rolls over to CLZ4 next month. CL2 points to the first deferred contract etc. If so, what is the naming convention for generic contracts for Refinitiv? I am trying to get…
-
Instrument Pricing Analytics - Pricing THB IRS gives only errors
I used to be able to price an IRS like this: def get_thb_legs(fixed_rate_pct:float=None, floating_spread_bps:float=None, receive_fixed:bool=True, notional_amount:float=100): fixed_dir, float_dir = ('Received', 'Paid') if receive_fixed else ('Paid', 'Received') fixed_leg = { 'legTag':'Fixed', 'direction':fixed_dir,…
-
DSWS API returns invalid data
Hi, When I execute the following via the DSWS API I receive the following data: ds.get_data(tickers = '8857RL', fields = ['DSCD','ENAME','ISIN','RIC','T1C','LEI',] ,kind = 0) When I use the same DSCD in the web portal, the ISIN is correct. When I try to search the web portal for the ISIN returned by the API, I receive no…
-
How to extract both NBBO and normal bid/ask/bid size/ask size
Context: We want to understand the extraction of NBBO data from Real-Time Direct. We can get data from Real-Time Direct using its SDK. Our Real-Time Direct username is AM2_MFMA_US07318. We raise a ticket Case 14176873, the support team requests us to post the question in this forum instead. Main body: Usually, for…
-
Failed to get exchange time from Market depth
Hi, the exchange time of market depth always return NaN while it works for tick history.
-
Multiple Periods in Codebook
Client has a list of companies and one of which is 2382.HK. He wants to get the quarterly data but this specific RIC has no quarterly data. Now, client wants to know how he can write it to get the quarterly and semi annual data in 1 request? Product is API/Codebook. Thank you!
-
Failed to extract market depth
Hi, I can successfully download tick history with following code while for market depth, for depth it always returns empty df. Could you shad some light on why it doesn't work? Thank you!
-
Failed to extract market depth
Hi, I can successfully download tick history with following code while for market depth, for depth it always returns empty df. Could you shad some light on why it doesn't work? Thank you!
-
From HKEX on <.SCCEA>
The client HKEX is using RKD API to fetch data for external redistribution (a large display wall at public place). Below is question from them on behavior of <.SCCEA>. Posting the questions below: We would like to request your help to clarify the field behavior of TRDPRC_1(FID 6) and CF_LAST, as well as NETCHNG_1 and…
-
Arival price for matured futures and options
HI, I am trying to obtain arival price for mature options and futures using RIC code. Can you please point me the the correct API and give me and example of the code that would retrive that data.
-
What RICS to use when using get_history to get data for expired spreads ie LGOX4-Z4
I am using the following call for refintiv data platform via python : rd.get_history('LGOX4-Z4', ['OPEN_PRC', 'HIGH_1', 'LOW_1', 'SETTLE'], 'weekly') The above returns a "universe not found error". When changed to a non expired spread (i.e LGOF5-G5) it works fine. I already attempted using '0#LGOX4-Z4' and 'DLGOX4-Z4' per…
-
How to automate Download for prospectus for Green and Sustainability bonds
I am trying to automatize the download of prospectus for Green and Sustainability bonds. Is it possible to use the python API or the Codebook App to program a code that download these pdf?