question

Upvotes
Accepted
jens.verbrugge avatar image
1 ●1 ●0 ●0

How to create a list using DSWS

Hi,

I am trying to create a list of constituents, using dsws in Matlab. How can this be done? I checked all documentation I could find, but I didn't find any explanation or examples...

I was told that the Matlab dsws uses the same underlying api as the excel add-ins, so it should be possible. Because in excel, this can easily be done using a request-table. But we are trying to work in Matlab, and are looking to avoid having to move to excel, get those add-ins loaded, perform the request-table, and transfer the results back to Matlab. Which causes delays, and trouble with N/A values etc.

Any help is appreciated!

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.

3 Answers

Upvotes
Accepted
jonathan.legrand avatar image
1.4k ●6 ●2 ●2

Hi @jens.verbrugge,


I'm afraid that we can’t create lists via the Matlab API at the moment. This needs to be done within DFO (Datastream For Office) and then can just be retrieved via the DSWS in Matlab. We are actually creating a native interface, to pull directly from the API this year to include all user created items, such as lists, expressions, time series etc.


This happens to have been outlined in this Q&A: 'you cannot create UCTS data from MATLAB '.


Note that there is a function in the R library that does just that, but this reverts back to DFO to perform the upload...

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.

Upvotes
Gurpreet avatar image
13k ●32 ●12 ●18

Hello @jens.verbrugge,

The DSWS in Matlab is provided via Datafeed Toolbox adapter, which is developed and supported by Matlab. It is best, if you post your question on the Matlab forums.

It also seems like your issue is related to Matlab functionality, vs DSWS capability. See this answer for how to create a list in Matlab.

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.

jens.verbrugge avatar image jens.verbrugge

The question is not how to create a list in Matlab; That is pretty straightforward.

The question is how to store a list, created via Matlab, on my datastream account.

So I want to do something similar as explained in step 3 in the documentation here:

Microsoft Word - Equally Weighted Index.doc (refinitiv.com)

But via Matlab, instead of via Excel.

Upvotes
Gurpreet avatar image
13k ●32 ●12 ●18

I found more documentation links, which you might have already seen -

DSWS and Matlab webinar

Getting started with Matlab

Similar question which shows how to create Matlab list, but using Eikon Data 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.

jens.verbrugge avatar image jens.verbrugge

I have been through these already, but also that doesn't provide an answer to my question.

Click below to post an Idea Post Idea