How do I retrieve static data from a list using the Thomson Datastream API provided by Datafeed Toolbox in MATLAB 7.2 (R2006a)?

I want to retrieve static data from a list like 'LFRCAC40' using the Datafeed Toolbox. When I execute the following command:

data = fetch(datastream_connection, {'LFRCAC40'}, {'P'}, '8/01/2006')

I receive the following error message:

 ??? Error using ==> datastream.fetch

 $$"ER", E100, INVALID CODE OR EXPRESSION ENTERED, LFRCAC40(P)

I have also tried retrieving NAME field using the Datafeed Toolbox:

data = fetch(datastream_connection, {'IBM'}, {'NAME'})

I get the same error:

 ??? Error using ==> datastream.fetch at 219

 $$"ER", E100, INVALID CODE OR EXPRESSION ENTERED, IBM(NAME)

Answer 1

[MathWorks Support Team]

This change has been incorporated into the documentation in Release 2011a (R2011a). For previous releases, read below for any additional information:

To get the static data from a list, you can type :

x = fetch(datastream_connection,'LFRCAC40~REP','P')

or

x = fetch(datastream_connection,'LFRCAC40~REP~=P')

The REP is needed to denote a static report. This is a Datastream specific syntax.

NAME, SECD, and ISIN are some examples of the static fields and need to be requested

with the '~REP' flag:

data = fetch(datastream_connection,{'IBM~REP'}, {'NAME'});