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

Prantik_Biswas · 2025-05-15T11:25:08+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

#technology

Accepted answers

Jirapongse

@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')

All comments

Jirapongse

@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

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)?

EXPLORE OUR SITES