Navigation: Importing Bar Data >

The Symbol Information File

 

 

 

Because some data sources provide either no information at all or only the company name, RealTest provides a way to include other per-symbol information when importing data.

This is done using a special-purpose CSV file (or multiple such files).

The first row of the file must contain column names from the first column of the following list:

Column

Content Type

Script Formula Access

Symbol

string

?Symbol

Name

string

?Name

Exchange

string

?Exchange

Currency

string

?Currency

Domicile

string

?Domicile

Sector

string

?Sector

Industry

string

?Industry

InduIndex

string

?CII

TRBC

numeric

InfoTRBC

GICS

numeric

InfoGICS

Shares

numeric

InfoShares

Float

numeric

InfoFloat

The symbol in each row should match a symbol from the import. All other columns are optional and can be in any order. Rows can also be in any order.

The set of supported symbol information columns corresponds to the metadata that is automatically included when Norgate is the data source. There is therefore never a reason to use a SymInfoFile with Norgate import.

For other data sources, you are welcome to use any of the above columns for any kind of information you want to have available. Just use the corresponding formula element to access it as needed in your scripts.

See also import_spx.rts, spx_syminfo.csv, djia_make_syminfo.rts, djia_use_syminfo.rts, djia_info.csv in the Examples folder.

 

 

 

Copyright © 2020-2021 Systematic Solutions, LLC