Macro1.PNG Hi Team, one of our client is facing issue with Macro not working when try to save PDF
I need to get swaption volatility surfaces for a time lenght of at least 10 years. It is for my master thesis. I looked up at the Q&A and I tried to insert them with RHistory function: =RHistory("USD3MFSR";"BID.TIMESTAMP;BID.CLOSE";"NBROWS:1500 INTERVAL:1D";"CH:IN;Fd STREPEAT:N";B3) Unfortunately it's not working. It says…
When I use get_timeseries to get Future's close price, I choose to use t FOR loop to get a list of contracts' data, but sometimes the get_timeseries returns TIMEOUT. Even if I set a 1 second time.sleep for each loop. How can I make sure that the get_timeseries can work well? My code is like this: for i in…
I would like to clarify a few points. It seems the API we are requesting is not a real-time data API from exchanges. The first one is the Filings API from the following thread: https://community.developers.refinitiv.com/questions/100586/retrieving-annual-reports-using-eikon-api.html. Below is the screenshot of the response…
I have a combination of RIC and a timestamps called let's say 'time' from 2024-05-27 to 2024-06-07. The combination represent trades for which I want to pulled data. I tried using the get_history() function from the RD library and find historic BID and ASK prices at 1 minutes interval. Since I have close to 10K unique RIC…
Hi, If I search for a given ric (GE), and go to Ownership tab. We get data like Top Investors, Investor Type, Breakdown, and Holding Concentration. I want to extract these for a company over time through a codebook in Python. How can I do that? Thank you for the help.
location=rd.get_data( universe=["GE"], fields=['TR.InstrStatLocationId.date', 'TR.InstrStatLocationId', 'TR.InstrStatLocation', 'TR.CategoryInvestorCount', 'TR.CategoryOwnershipPct', 'TR.InstrStatCatSharesHeld', 'TR.InstrStatCatShrsHldVal(Scale=6)'], parameters={'StatType': 3, 'SDate': "2024-05-01", 'EDate': "2024-07-01"}…
Already provided import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['HSBA.L'], fields = [ 'TR.RelatedOrgId', 'TR.RelatedOrgName', 'TR.RelatedOrgType' ] ) display(df) However its only for single companies, not really sure how to do this on Codebook then, appreciate your help in advance.
Hi, I have a list of RIC. I want to fetch the frequency or interval of each. Some of them are daily, some weekly, quarterly and so on. I don't want to check one by one. What is the fastest way to have this info? is there a field to specify this. I am using eikon python API. I also use the Excel Eikon plugin.
Hello, I want to get news data from the 2000s. It seems that I need to use ek.get_news_headlines instead of rd.news.get_headlines. However, I can't figure out how to include dates in my code. It gives an error every time. For example ek.get_news_headlines(query='Topic:LSEG and Language:LEN', count=10,…
It looks like you're new here. Sign in or register to get started.
