Can I retrieve User Created Time Series (UCTS) data from Datastream?

In Thomson Reuters API, Datastream offers a feature called User Created Time Series (UCTS) for end users to upload their own data. Can these data be retrieved, in MATLAB, in exactly the same way as other Datastream data?

Answer 1

[MathWorks Support Team]

Yes, you can request UCTS data that was created outside of MATLAB. Note, however, that you cannot create UCTS data from MATLAB.

Here are the steps you would follow:

1. Create a UCTS with EXCEL TSCACMOD and then request it as below.

Note: the UCTS must be created with the same Datastream id (red)

2. Do not forget to add ~# (green) before!

At the command line in MATLAB, do the following:

>> Connected = datastream('DS:XDSM16','xxxxx','Datastream','<http://dataworks.thomson.com/Dataworks/Enterprise/1.0'>)

Connected =

           user: 'DS:XDSM16'

       password: '*******'

     datasource: 'Datastream'

       endpoint: '<http://dataworks.thomson.com/Dataworks/Enterprise/1.0/webserviceclient.asmx'>

           wsdl: '<http://dataworks.thomson.com/Dataworks/Enterprise/1.0/webserviceclient.asmx?WSDL'>

>> a = fetch(Connected, 'TSCACMOD~#XDSM16')

a = 

            Source: 'Datastream'

        Instrument: 'TSCACMOD~#XDSM169'

        StatusType: 'Connected'

        StatusCode: '0'

     StatusMessage: ''

               CCY: 'E'

              DATE: {262x1 cell}

          DISPNAME: 'TSCACMOD'

         FREQUENCY: 'D'

                 P: {262x1 cell}

           SYMBOL: 'TSCACMOD'