Can I download data fetched by @DSGRID excel formula using the DswsClient API?

Prantik_Biswas · May 15

I want to download data fetched by @DSGRID excel formula (for example : =@DSGRID("EWA#(USIIBUL,0.02), EWA#(USAAIIP-USAAIIN,0.02)"," ","2023-01-01","","D","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","") but without using excel.

I have many formulas like the above which needs to be downloaded quite regugarly and hence I want to automate the process. This exploration led me to the DswsClient API (Datastream Web Service - Test REST Service). Is it possible to download data given by @DSGRID formulas using the above API?

Jirapongse · May 16

@Prantik_Biswas

Thank you for reaching out to us.

I am using the DatastreamPy. The Python code looks like this:

ds.get_data(tickers='EWA#(USIIBUL,0.02), EWA#(USAAIIP-USAAIIN,0.02)', start='2023-01-01', freq='D')

Prantik_Biswas · May 16

https://community.developers.refinitiv.com/discussion/comment/125787#Comment_125787

Thank you for your answer! With this example as a guide, I was able to execute the request and the data appeared in JSON format in a separate page. However, how can I download this data from the page (for example using python)?

Jirapongse · May 19

@Prantik_Biswas

Please refer to the Getting started with Python document.

You can use the Python DatastreamPy library to get this data. The code looks like this:

import DatastreamPy as DSWS
ds = DSWS.DataClient(None, username = 'username', password = 'password')
ds.get_data(tickers='EWA#(USIIBUL,0.02), EWA#(USAAIIP-USAAIIN,0.02)', start='2023-01-01', freq='D')

Can I download data fetched by @DSGRID excel formula using the DswsClient API?

Best Answer

Answers

Categories

EXPLORE OUR SITES

Can I download data fetched by @DSGRID excel formula using the DswsClient API?

Best Answer

Answers

Categories