question

Upvotes
Accepted
1 0 0 0

User Expressions in DSWS

Datastream has a length limit for expressions.

In Datastream for Excel, it's possible to create longer "User Expressions" that are assigned a code, which can then be used in requests to get around this limit

I am wondering if the same is possible for DSWS, or if there is any other solution for getting around the expression length limit?

datastream-apidsws-api
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
38.1k 71 35 53

@emmanuel.wildiers

I couldn't find the expression length limit mentioned in the DSWS documents. It only mentions DSWS USER STATS AND LIMITS.

You can share the expression, and then I can try it on Python DatastreamDSWS.


icon clock
10 |1500

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

@jirapongse.phuriphanvichai

When using the request

ds.get_data(tickers='VOD', fields =['(X(F1FD12)~EB/X(P)~EB)/MAV#(X(F1FD12)~EB/X(P)~EB,3Y)'], kind=0)

the following error is returned:

'Invalid DataType. A datatype should contain between 1 and 45 characters'

There is no error message, however, when using a non-static request (kind=1).

Click below to post an Idea Post Idea