Hi everyone, I am having the following question: I have a user account for refinitiv workspace, which includes usage of the excel add-in. Some data found in the excel add-in is not found in refinitiv work-space. For example, in excel I can build a formula using the datastream formula builder to obtain the field "YA" for…
Hi Community Im use VBA macros to open many files with DSgrid formula in them, I need them to update their values when they a re opened by the macro. As I'm looping through many files I do not want a manual step that involves stopping the VBA. Is this possible? Below is a screen shot of my formula. many thanks Hugo
Hi, I'm trying to bulk download balance sheet data for all equities available in Datastream Web Services. For this purpose, I'm using Python. My plan is as follows: I will loop through the list of all countries I want to include and retrieve the tickers of all equities available for each country. Then, I will loop through…
hI, I can no longer find an article that was available couple of years back. I had saved the URL in case i want to return to it which I've provided below, but it seems to be gone. Can somebody find it for me please? If not, can you assist in how to run a multi-thread Python code in DSWS API to enhance the speed/performance…
Client is getting attached error when trying to retrieve data using DSWS R API i can see the token expiry date is 31 march 2025 I checked previous Q&A cases here but they seem to be relate to RDP and not DSWS Please advise how to fix this. thank you
We are getting an error message advising that we're having issues requesting the access token from the DSWS API. Grateful for any ideas….
Hi all, I am trying to pull Credit Ratings for a list of Companies. I want the yearly issuer level credit rating from the years 2015 to 2023. What is the best way to go about this in Excel?
I need functionality where I can input a CUSIP into Excel and automatically retrieve the full monthly historical data for that CUSIP. The output should look exactly like the monthly historical view available in Workspace under "Trade Check" (see attached screenshot for reference). Please let me know how I can achieve this…
Hi, Can you please let me know how to change the date to trading date in Excel? I have searched everywhere now and would really appreciate the direct help. The formula below gives me 262 days.…
hi i'm looking to retrieve the Market cap for companies. From the data i received i see that the market cap is calculated different than in workspace. How could we retrieve through the API the market cap according to CLOSE PRICE*OUTSTANDING SHARES? example: RIC SES: market cap is calculated at the moment through issued…
It looks like you're new here. Sign in or register to get started.
