:
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Current »

The user series must be created by an import file with extension ".txt" in ANSI format.

The data series should consist of data from Monday through Friday and should exclude non-business days. The decimal mark is the decimal point. The date format should be yyyy-mm-dd.

The import file in txt to create or to update a series must contain all the fields below. Multiple series could be inserted into the same file provided they each follow the correct format.

Dados do arquivo de importação

Ticker: code with maximum 12 chars used to idenfity the security.

Company: security name.

Country: 2 or 3 letter country code according to ISO.

Currency: 2 or 3 letter currency code according to ISO.

Type:  code for the asset class, the first column in the asset class table.

Shared: Yes or No (if "yes" the series can be viewed by all of the users under the same serial number, if "No" only the creator of the series can view it).

Password: 4 to 10 character alpha-numeric password. The password is mandatory.

Fields:  field-name1     field-name2     field-name3     field-name4... (fields to be completed (see codes of importation in the table); to determine the fields to be completed according to the asset class, see an example in Economatica in the "Quotes" window).

yyyy-mm-dd    field-value1      field-value2     field-value3      field-value4...

yyyy-mm-dd    field-value1      field-value2     field-value3      field-value4...

yyyy-mm-dd    field-value1      field-value2     field-value3      field-value4...  (data series and values in the order designated in Fields).

END: mandatory item, end of series marker.

 

See also:

Examples of import files

How to import user series

Columns and codes accepted

Asset classes accepted

  • No labels