question

Upvote
Accepted
63 10 17 19

DSWS equivalent for excel query

I was looking for the DSWS equivalent to of this excel addin formula:

=@DSGRD("IN:REL","WC09302","-1d","","D","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")


Appreciate your help.

datastream-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
83.1k 281 53 77

@rajanraju

Thanks for reaching out to us.

You can use the DatastreamPy library to retrieve the same data as that excel addin formula.

The code looks like this:

import DatastreamPy as DSWS
ds = DSWS.Datastream(username = "username", password = "password")
ds.get_data(tickers="IN:REL",fields=["WC09302"],start="-1D",freq="D")

The output is:

1663638230777.png

Please feel free to reach out if you have any further questions.


1663638230777.png (12.9 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.