EcoInput Import Files

Automatic translations by Google: en Español - em Portugues


Index:

  • JSON Format
  • *CA Corporate Actions
  • *FS Financial Statement
  • *FSIFNEWER Financial Statement IF Newer
  • *FSUPDATE Financial Statement Update
  • *ISIN ISIN code
  • *OBJEMP Company definition
  • *OBJCLASS Class definition
  • *OBJSERIE Serie definition
  • *NAICS sector code
  • *NAICSIF sector code
  • *NW News
  • *QT Stock prices
  • *QTIF Stock prices conditional import
  • *QTNOOVERWRITE Stock prices No Overwrite
  • *DELQT Delete Stock prices
  • *PFITEM
  • *PFITEMIFDOCISNEW
  • *PFITEMDOC
  • *PORTFOLIO
  • *SERIESTATUS Serie status
  • *SHARES
  • *SHARESUPDATE
  • *SHAREHOLDER
  • *SHAREHOLDERIFDOCISNEW
  • *SHAREHOLDERDOC
  • *SHAREHOLDERS
  • *COMREG Company registration items
  • *CLASSREG Class registration items
  • *SERIEREG Serie registration items
  • *EAAREG EAA registration items
  • *EAAREGADDITEMIFNEW EAA registration items
  • *EAAREGIFEXISTS EAA registration items
  • *COMREGREPEATDATE Repeat Company registration item on effective date
  • *CLASSREGREPEATDATE Repeat Class registration item on effective date
  • *SERIEREGREPEATDATE Repeat Serie registration item on effective date
  • *LISTCHOICE Serie registration item

  • JSON Format

    [
        {
            "type": "imovel",
            "action": "",    
            <idimovel>       
            "descricao": "", 
            "endereco": "",  
            "idcidade": 999, 
            "docs": [""]     
        }
    ]
    
    type": "imovel"
    "action":deve conter uma entre as opções ("insertorupdate" ou "insertonly" ou "updateonly")
    <idimovel> deve conter uma entre as opções ("idimovel": 999 ou "doc": "" ou "docid": "")
    "descricao": "descricao" campo obrigatorio e valido
    "endereco": "endereco" campo obrigatorio e valido
    "idcidade": 999 campo obrigatorio e valido
    "docs": ["doc1","doc2"] campo opcional


    *CA Corporate Actions

    *CA "ticker" exchange date type currency shares/percent/factor value
    *CA "ticker" exchange date type DELETE
    
    ticker
    ticker as shown in Companies/Serie/Ticker
    exchange
    numeric code of the exchange; see list of exchanges
    date
    corporate action date (ex-date) in the format yyyy-mm-dd
    type
    numeric code of the CA type, see list
    DELETE
    include the term "DELETE" to delete an existing corporate action
    currency
    numeric code of the currency, see list;
    only used if the price is relevant for this CA type, but must be present in the import file even if it is not used, list it as 0 (zero) in this case
    shares/percent/factor
    a single number that goes on either of the shares, percent or factor field in the EcoInput CA window, depending on which type is this CA; some types don't use this field (dividend, for instance) but it must be present in the import file anyway, in this case use a 0 (zero)
    price
    price of this CA, in the currency listed above; if this CA type doesn't need a price use 0 (zero) here


    *QT Stock Prices

    *QTIF Stock Prices conditional import

    *QTNOOVERWRITE Stock Prices No Overwrite

    for stocks
    *QT "ticker" exchange date open low high avg close trades shares volume
    
    for funds BRA
    *QT "ticker" exchange date captacao resgate resgate-ir source price cotistas resgate-total PL
    
    for funds ARG
    *QT "ticker" exchange date - - - mktshare price - qtd-cuotas PL
    
    for funds CHL
    *QT "ticker" exchange date cuotas-captacion cuotas-resgate - - price cuotistas cuotistas-institucionales PL
    
    for funds COL
    *QT "ticker" exchange date partic-dtf partic-tasa-fija patic-ipc partic-UVR price cotistas partic-ibr PL partic-disponible prom-dias-inc-disp partic-1-180-dias partic-180-365-dias
    
    for funds 2 COL
    *QT "ticker" exchange date partic-1-3-anos partic-3-5-anos rent-1-mes rent-6-meses rent-1-ano rent-ano-corrido rent-2-anos volatil-1-mes volatil-6-meses volatil-1-ano volatil-ano-corrido volatil-2-anos
    
    for funds MEX
    *QT "ticker" exchange date - - - - price cotistas - PL rotation duracion-modificada dias-por-vencer
    
    for funds, other countries
    *QT "ticker" exchange date - - - - price cotistas - PL
    
    for security lends BRA (open positions)
    *QT "ticker" exchange date titulos cotacao-media valor - - - - - - - - -
    
    for security lends BRA (open positions contracts in day)
    *QT "ticker" exchange date - - - titulos-balcao contratos-balcao valor-balcao tx-minima-balcao tx-maxima-balcao tx-media-balcao - - - titulos-eletd0 contratos-eletd0 valor-eletd0 tx-minima-eletd0 tx-maxima-eletd0 tx-media-eletd0 titulos-eletd1 contratos-eletd1 valor-eletd1 tx-minima-eletd1 tx-maxima-eletd1 tx-media-eletd1
    
    for bonds MEX
    *QT "ticker" exchange date interese rendimiento-(YTM) tasa-de-descuento precio-limpio precio-sucio dias-por-vencer dias-de-cupon-vigente tasa-de-mercado sobretasa-de-mercado duracion-modificada duracion-macaulay convexidad
    
    for bonds USA
    *QT "ticker" exchange date interese rendimiento-(YTM) - precio-limpio precio-sucio YTM-EXP YTM-RLL - - duracion-modificada duracion-macaulay 
    
    for bonds PER
    *QT "ticker" exchange date precio-sucio precio-limpio IC rendimiento-(YTM) duracion precio-limpio-porc tir-porc-s-opc spreads margen-libor origen dias-por-vencer dias-de-cupon-vigente
    
    for bonds ARG
    *QT "ticker" exchange date interese rendimiento-(YTM) tasa-cupon precio-limpio precio-sucio valor-tecnico paridad valor-residual tipo-de-cambio duracion-modificada duracion-macaulay convexidad
    
    for bonds CHL
    *QT ticker exchange date dias-por-vencer dias-de-cupon-vigente spread PU-Par precio-sucio numero-de-operaciones cantidad-de-titulos volumen-$ rendimiento-(YTM) origen duracion-macaulay convexidad
    
    for bonds BRA
    *QT "ticker" exchange date Taxa-Compra Taxa-Venda Intervalo-Indicativo-Minino Intervalo-Indicativo-Maximo PU PU-Par Duration Desvio-Padrao Taxa-Indicativa-(Taxa-YTM)
    
    for bonds COL
    *QT "ticker" exchange date sourcecol precio-sucio-minimo precio-sucio-maximo precio-sucio-medio precio-sucio-cierre numero-de-operaciones tasa-cierre volumen-$ tasa-minima tasa-maxima tasa-media
    
    for government bonds CHL
    *QT ticker exchange date dias-por-vencer dias-de-cupon-vigente - PU-Par precio-sucio numero-de-operaciones cantidad-de-titulos volumen-$ rendimiento-(YTM) origen duracion-macaulay convexidad
    
    for government bonds BRA
    *QT "ticker" exchange date - - - - close - - - YTM - duration
    
    for Anbima indexes BRA
    *QT "ticker" exchange date percentage portfolio-market-value buying-interest-rate selling-interest-rate close renegotiation-average-period duration -
    
    for CRI/CRA  BRA - complete layout
    *QT "ticker" exchange date open low high avg close trades shares volume refprice low-extragroup high-extragroup avg-extragroup close-extragroup trades-extragroup shares-extragroup volume-extragroup refprice-extragroup low-intragroup high-intragroup avg-intragroup close-intragroup trades-intragroup shares-intragroup volume-intragroup refprice-intragroup 
    
    for CRI/CRA  BRA - ___FixedIncome___TradeInformationFile___ layout
    *QTNOOVERWRITE "ticker" exchange date open low high avg close trades shares * * low-extragroup high-extragroup avg-extragroup close-extragroup trades-extragroup shares-extragroup * * low-intragroup high-intragroup avg-intragroup close-intragroup trades-intragroup shares-intragroup * * 
    
    for CRI/CRA  BRA - OTCTradeInformationConsolidatedFile___   layout
    *QTNOOVERWRITE "ticker" exchange date open * * * * * * volume refprice * * * * * * volume-extragroup refprice-extragroup * * * * * * volume-intragroup refprice-intragroup 
    
    conditional import
    *QTIF "ticker" exchange date condition <same price parameters as *QT>
    
    no overwrite
    *QTNOOVERWRITE <same parameters as *QT>
    
    ticker
    ticker as shown in Companies/Serie/Ticker
    exchange
    numeric code of the exchange; see list of exchanges
    date
    date of the price information in the format yyyy-mm-dd
    open, low, high, avg, close
    prices practiced in this day, use a dash "-" where no info is available
    trades
    number of trades in this day, use a dash "-" where no info is available
    shares
    number o shares traded in this day, use a dash "-" where no info is available
    volume
    total money value traded in this day, use a dash "-" where no info is available
    captacao
    inflows, only used for funds in Brazil, use a dash "-" where no info is available
    resgate
    redemption, only used for funds in Brazil, use a dash "-" where no info is available
    resgate-ir
    redemption for income tax, only used for funds in Brazil, use a dash "-" where no info is available
    price
    price of the fund, use a dash "-" where no info is available
    PL
    fund net assets, use a dash "-" where no info is available
    cotistas
    number of investors (=cuotistas), use a dash "-" where no info is available
    mktshare
    market share of this fund, only used for Argentine funds, it's a percent value but do not inclulde the "%" sign, "-" if not available
    source
    source of the information; currently defined: - or 0: ANBIMA, 1: CVM
    condition
    condition in the form #n=v or #n<>v or #n<v or #n>v; n being the number of the price field whose previous value is going to be tested, v being the value to be tested in the condition
    origen
    devese usar unicamente el valor 1 para significar "Mercado" o 2 para "SBS", o 3 para "Valorizado"
    sourcecol
    devese usar unicamente el valor 0 para "-", 1 para significar "Precio te�rico" o 2 para "Transaccional", o 3 para "OTC"
    -
    remember to put a dash "-" on these fields
    any of the value fields after "date" can be replaced by an asterisk "*" which means not to change the content of this field in the database and keep whatever was in place before importing this line

    *QTNOOVERWRITE won't overwrite the contents of the database, it will only save the data if all specified fields after "date" are currently empty ("-") in the database; specified fields means the fields which were specified as a "-" or a number, but not those marked as "*"

    *QTIF will first check if there was already a data record in the ticker/exchange/date specified, if it is the case and the condition is not met, nothing will be imported; if there was no previous data record or if the condition is met, the values are imported


    *DELQT Delete Stock Prices

    *DELQT "ticker" exchange from-date to-date
    
    ticker
    ticker as shown in Companies/Serie/Ticker
    exchange
    numeric code of the exchange; see list of exchanges
    from-date to-date
    delete all prices from "from-date" until "to-date"


    *FS Financial Statement

    *FSIFNEWER Financial Statement If Newer

    *FSUPDATE Financial Statement Update

    *FS "company-ID" country date consolidated [source] [typedoc]
    *FS companyid:"company-ID-value" country:country-value date consolidated [source] [typedoc]
    *FS cnpj:"cnpj-value" country:country-value date consolidated [source] [typedoc]
    *FS ticker:"ticker-value" exchange:exchange-value date consolidated [source] [typedoc]
    *FS isin:"isin-value" exchange:exchange-value date consolidated [source] [typedoc]
    currencydt currencydt 
    format format [do-not-override-format] 
    months months
    moncorr moncorr [do-not-override-moncorr]
    publishdt publishdt 
    currency currency 
    [fy|3m]
    @conta [fy|3m] [cpfcnpj] value
    @conta [fy|3m] [cpfcnpj] value
    @conta [fy|3m] [cpfcnpj] value
    ...
    [fy|3m]
    @conta [fy|3m] [cpfcnpj] value
    @conta [fy|3m] [cpfcnpj] value
    @conta [fy|3m] [cpfcnpj] value
    ...
    end
    
    company-ID
    as shown in Companies/Company/Company ID
    country
    numeric OR ISO-3166 alpha code of the country; see list of countries
    date
    financial statement reference date, in the format yyyy-mm-dd
    consolidated
    fs is consolidated? "O"="N"=non-consolidated, "1"="Y"=consolidated
    source
    0=Economatica 1=EOL (only for USA); if omitted, it is assumed as 0
    typedoc
    0=Balanco 1=Informe Direitos Creditorios; if omitted, it is assumed as 0
    currencydt
    currency date, yyyy-mm-dd
    format
    numeric code of fs format; see list of formats
    do-not-override-format
    ignores the whole *FS/*FSUPDATE command if the current fs format of the company is set to do-not-override-format
    months
    months in fiscal year
    moncorr
    0=CMI(only for BRA), 1=LS(BRA), 2=LS*(BRA), 3=IFRS, 4=PCGA(CHL), or it may be omitted
    do-not-override-moncorr
    ignores the whole *FS/*FSUPDATE command if there already exists a fs of this company/date/consolidated/source with the moncorr set as do-not-override-moncorr
    publishdt
    date fs was published, yyyy-mm-dd
    currency
    numeric code of the currency the fs is expressed in; see list of currencies
    fy|3m
    on a line by itself, defines the default for future @account lines, whether they refer to the fiscal year results "fy" or to the last 3 months "3m"; we do not recommend using it in this form, see below; the | means this line should contain either the "fy" or the "3m" term, not both
    account
    number of the account of the financial statement; see list of accounts; account should be defined as present in the fs format defined in the format parameter (above)
    [fy|3m]
    following an @account term, overrides the default and specifiy if this particular account refers to the fiscal year results or to the last 3 months; may be ommited and in this case the default is assumed; the default is always fy unless changed by a fy|3m on a previous line by itself; the | means this term should be specified either as "fy" or "3m", not both; see below for the recommended strategy to specify 3m or fy
    value
    value of the account, a dash "-" means the information is not available

    on fy|3m

    We strongly encourage you to avoid using fy|3m on a line by itself.
    Our recommendation is to always assume fy as default, never change the default with a fy|3m line, ommit the "fy" term on all @account lines that refer to the fiscal year, and specify "3m" on each @account line that refers to a 3-month result sheet.



    *FSIFNEWER identical to the *FS command except that you should use the term *FSIFNEWER instead of *FS. *FSIFNEWER checks if the publish date is equal or greater than the publish date recorded, if not, nothing will be imported.

    *FSUPDATE identical to the *FS command except that you should use the term *FSUPDATE instead of *FS, and it is used as an update, i.e. any value that is ommited in the command is copied from what was previously in the data base;
    if this financial statement was not previously in the database but you include enough information in the *FSUPDATE to make it a valid financial statement, it is accepted and included;


    *NW News

    *NW "company-ID" country date seq
    *NW companyid:"company-ID-value" country:country-value RefDate PublishDate inPercentage typedoc
    *NW cnpj:"cnpj-value" country:country-value RefDate PublishDate inPercentage typedoc
    *NW ticker:"ticker-value" exchange:exchange-value RefDate PublishDate inPercentage typedoc
    *NW isin:"isin-value" exchange:exchange-value RefDate PublishDate inPercentage typedoc
    
    text
    text
    ...
    END
    
    company-ID
    as shown in Companies/Company/Company ID
    country
    numeric OR ISO-3166 alpha code of the country; see list of countries
    date
    news date, yyyy-mm-dd
    seq
    sequential number in this date, if specified as a dash "-" it is added as the last piece of news for this company for this date and receives a number in sequence with what was previously the last one (if any)
    text
    news text
    END
    this word has to be in upper-case!!!


    *OBJEMP Company Definition

    *OBJEMP "company-id" country "company-name" not-used fs-currency fsfS0[-fsfS1[-...]] naics ...
       ... "complete-name" "previous-name" "web-site" "cnpj"
    

    the command should be placed all in one line, it is shown in separate lines just for clarity!

    company-ID
    as shown in Companies/Company/Company ID
    country
    numeric OR ISO-3166 alpha code of the country; see list of countries
    company-name
    short name of the company, may be ommited using a dash "-"
    not-used
    specify 0 here
    fs-currency
    numeric code of the currency financial statements for this company are published in, may be ommited using a dash "-"; see list of currencies
    fsfS0-fsfS1-...
    financial statement formats for this company, for each source; see list of formats
    fsfS0 = financial statement format used for source=0,
    fafS1 = financial statement format used for source=1, etc;
    you can specify just fsfS0, or fsfS0-fsfS1, or as many as you wish, sources not specified receive format=0
    the whole block may be ommited using a dash "-"
    naics
    naics sector code of this company, may be ommited using a dash "-"
    complete-name
    company's complete name, may be ommited using a dash "-"
    previous-name
    company's previous name, may be ommited using a dash "-"
    web-site
    company's web site, or phone number if there is no web site, may be ommited using a dash "-"
    cnpj
    employer id number, may be ommited using a dash "-"
    any ommited term (specified as a dash "-") will simply not overwrite whatever value it currently has in the data base for this field

    if the company is new (i.e. this company-ID + country is not known to the data base) you have to specify all fields, and in this case the company will be included in the data base


    *OBJCLASS Class Definition

    *OBJCLASS "company-id" country class asset-type vote
    
    company-ID
    as shown in Companies/Company/Company ID
    country
    numeric OR ISO-3166 alpha code of the country; see list of countries
    class
    either the name of the class like "PN", "Ord", "C", etc or the # sign followed by the numeric code of the class (see listing)
    asset-type
    numeric code of the asset type for this class, may be ommited using a dash "-"; see list of asset-types
    vote
    numeric code of the voting status for this class, may be ommited using a dash "-"; (0=n.a., 1=voting, 2=non-voting)
    any ommited term (specified as a dash "-") will simply not overwrite whatever value it currently has in the data base for this field

    if the class is new (i.e. this company-ID+country+class is not known to the data base) you have to specify all fields, and in this case the class will be included in the data base


    *OBJSERIE Serie Definition

    *OBJSERIE "ticker" exchange "company-id" country class inactive status "sedol" ...
       ... quotes-currency index-partic "ISIN" include-fin-statements hidden calendar disableCopy ...
       ... registration-template type-of-contract colonia-map quotes-template [hidden-marketlist]
    

    the command should be placed all in one line, it is shown in separate lines just for clarity!

    ticker
    ticker as shown in Companies/Serie/Ticker
    exchange
    numeric code of the exchange; see list of exchanges
    company-ID
    as shown in Companies/Company/Company ID, may be ommited using a dash "-";
    country
    numeric OR ISO-3166 alpha code of the country, may be ommited using a dash "-"; see list of countries
    class
    either the name of the class like "PN", "Ord", "C", etc or the # sign followed by the numeric code of the class (see listing), may be ommited using a dash "-";
    inactive
    if "Y" or "1", defines that this serie is inactive/cancelled, may be ommited using a dash "-"
    status
    new status for this serie, may be ommited using a dash "-"; see list of status codes
    sedol
    security identifier in Stock Exchange Daily Official List, may be ommited using a dash "-";
    quotes-currency
    numeric code of the currency, may be ommited using a dash "-"; see list;
    index-partic
    participation of this serie in the exchange index, may be ommited using a dash "-"
    ISIN
    ISIN code, may be ommited using a dash "-"
    include-fin-statements
    if "Y" or "1" includes financial statements even if it is a foreign company, may be ommited using a dash "-"
    hidden
    if "Y" or "1" defines that this serie is hidden in Eco, may be ommited using a dash "-"
    calendar
    numeric code of the calendar associated with this serie, may be ommited using a dash "-"
    disableCopy
    if "Y" or "1" disable copy, may be ommited using a dash "-"
    registration-template
    numeric code of the registration template, may be ommited using a dash "-"
    type-of-contract
    numeric code of the type of contract, may be ommited using a dash "-"
    colonia-map
    numeric code of the colonia map, may be ommited using a dash "-"
    quotes-template
    numeric code of the quotes template, may be ommited using a dash "-"
    hidden-marketlist
    optional, if "Y" or "1" defines that this serie is hidden in MarketList, may be ommited using a dash "-", default "N"
    any ommited term (specified as a dash "-") will simply not overwrite whatever value it currently has in the data base for this field

    if the serie is new (i.e. this ticker+exchange is not known to the data base) you have to specify all fields, and in this case the serie will be included in the data base


    *NAICS sector code

    *NAICSIF sector code

    *NAICS "company-id" country naics
    *NAICS companyid:"company-ID-value" country:country-value naics
    *NAICS cnpj:"cnpj-value" country:country-value naics
    *NAICS ticker:"ticker-value" exchange:exchange-value naics
    *NAICS isin:"isin-value" exchange:exchange-value naics
    
    *NAICSIF "company-id" country naics
    *NAICSIF companyid:"company-ID-value" country:country-value naics
    *NAICSIF cnpj:"cnpj-value" country:country-value naics
    *NAICSIF ticker:"ticker-value" exchange:exchange-value naics
    *NAICSIF isin:"isin-value" exchange:exchange-value naics
    
    company-ID
    as shown in Companies/Company/Company ID
    country
    numeric OR ISO-3166 alpha code of the country; see list of countries
    naics
    new naics sector code of this company
    *NAICSIF checks if NAICS code recorded for the company is child of this new one. In this case nothing will be imported.
    To force update use *NAICS or *OBJEMP.


    *SERIESTATUS Serie Status

    *SERIESTATUS "ticker" exchange new-status
    
    ticker
    ticker as shown in Companies/Serie/Ticker
    exchange
    numeric code of the exchange; see list of exchanges
    new-status
    new status for this serie; see list of status codes


    *ISIN ISIN code

    *ISIN "ticker" exchange new-ISIN-code
    
    ticker
    ticker as shown in Companies/Serie/Ticker
    exchange
    numeric code of the exchange; see list of exchanges
    new-ISIN-code
    new ISIN code


    *SHARES information on number of shares
    *SHARES información acerca de numero de acciones

    *SHARES "company-id" country reference-date source [ class {"total" total | treasury outstanding} ] ... 
    *SHARES companyid:"company-ID-value" country:country-value reference-date source [ class {"total" total | treasury outstanding} ] ... 
    *SHARES cnpj:"cnpj-value" country:country-value reference-date source [ class {"total" total | treasury outstanding} ] ... 
    *SHARES ticker:"ticker-value" exchange:exchange-value reference-date source [ class {"total" total | treasury outstanding} ] ... 
    *SHARES isin:"isin-value" exchange:exchange-value reference-date source [ class {"total" total | treasury outstanding} ] ... 
    
    source
    as in *FS
     
    source
    fuente de datos, como en *FS
    class
    either the name of the class like "PN", "Ord", "C", etc or the # sign followed by the numeric code of the class (see listing)
     
    class
    puede ser o el nombre de la clase como "PN", "Ord", "C", etc o el signo # seguido por el numero de la clase (vea la lista de clases)
    total
    when "total" is specified after the class id, the next parameter is understood as the total number of shares of this class, "-" means the figure is unavailable
     
    total
    cuando hay "total" especificado despues de la identificacion de la clase, el parametro siguiente es entendido com el numero total de acciones de esta clase, "-" significa que el numero no esta disponible
    treasury outstanding
    when "total" is not specified, the first parameter after the class id is the number of shares of this class in treasury and the next is the number of outstanding shares of this class, "-" on any of them indicates an unavailable figure
     
    treasury outstanding
    cuando la palabra "total" no es especificada, el primer parametro despues de la identificacion de la clase es el numero de acciones en tesoreria, y a seguir el numero de acciones outstanding de esta clase, "-" en cualquier un e los parametros indica que el numero no esta disponible

    The triplet of parameters starting with the class identification can be repeated in the same line as many times as needed   Estos tres parametros que empezan con la idenficiacion de la clase pueden ser repetidos en la misma linea cuantas veces sea necesario

    Notice that this *SHARES command should only be used after we migrate from collecting # of shares date in the accounts of the financial statement, to the new method to collect it in the specific Num of Shares window. When we migrate, the # of shares should not be sent in the financial statements accounts any more (of the *FS command) and should only be sent to the Num of Shares window (*SHARES command).   Este comando *SHARES solo deve ser usado despues que hacemos el cambio de colectar el numero de acciones en cuentas del estado financiero (*FS) para el nuevo metodo de tenerlas en la ventana especifica Num of Shares. Despues del cambio, el numero de acciones no deve mas ser puesto en el estado financiero (comando *FS), y deve ser puesto solo en la ventana Num of Shares (comando *SHARES).

    Table showing, for each country and each num of shares account of the financial statement, where the number should be sent to in the *SHARES command. After the table there's one example of how to split a *FS into a *FS and a *SHARES command   La tabla abajo muestra para cada pais y cada cuenta de numero de acciones del estado financiero, para que clase y total/outstanding/treasury el numero deve ser enviado. Desupes de la tabla hay un ejemplo de como un *FS deve ser dividido en comandos *FS y *SHARES

    BRASIL
    FS account*SHARES classtotal/treasury/outstanding
    39#1574 "total"Total
    1168#1574 "total"Treasury
    526#1574 "total"Outstanding
    37#1585 "ordinarias"Total
    831#1585 "ordinarias"Treasury
    555#1585 "ordinarias"Outstanding
    38#1584 "preferenciais"Total
    1323#1584 "preferenciais"Treasury
    1324#1584 "preferenciais"Outstanding
    USA
    FS account*SHARES classtotal/treasury/outstanding
    39#1582 "total"Total
    1168#1582 "total"Treasury
    526#1582 "total"Outstanding
    1269#1634 "Com type"Outstanding
    38#1235 "Pref"Total
    1323#1235 "Pref"Treasury
    1324#1235 "Pref"Outstanding
    ARGENTINA
    FS account*SHARES classtotal/treasury/outstanding
    39#1575 "total"Total
    1168#1575 "total"Treasury
    526#1575 "total"Outstanding
    37#860 "Ord"Total
    831#860 "Ord"Treasury
    555#860 "Ord"Outstanding
    38#545 "Pref"Total
    1323#545 "Pref"Treasury
    1324#545 "Pref"Outstanding
    1089#243 "C"Total
    2980#205 "1"Total
    MEXICO
    FS account*SHARES classtotal/treasury/outstanding
    39#554 "total"Total
    1168#554 "total"Treasury
    526#554 "total"Outstanding
    37#1588 "Ord"Total
    831#1588 "Ord"Treasury
    555#1588 "Ord"Outstanding
    38#1604 "P"Total
    1323#1604 "P"Treasury
    1324#1604 "P"Outstanding
    1087#1626 "A tipo"Total
    1088#1628 "B tipo"Total
    1089#1629 "C tipo"Total
    1170#48 "D"Total
    1090#192 "L"Total
    1169#1625 "otros tipos"Total
    2980#1299 "1"Total
    2981#1 "2"Total
    CHILE
    FS account*SHARES classtotal/treasury/outstanding
    39#1576 "total"Total
    1168#1576 "total"Treasury
    526#1576 "total"Outstanding
    37#1406 "Ord"Total
    831#1406 "Ord"Treasury
    555#1406 "Ord"Outstanding
    38#207 "P"Total
    1323#207 "P"Treasury
    1324#207 "P"Outstanding
    1087#244 "A"Total
    1088#359 "B"Total
    1089#50 "C"Total
    1170#468 "D"Total
    1169#1624 "otros tipos"Total
    2980#8 "1"Total
    VENEZUELA
    FS account*SHARES classtotal/treasury/outstanding
    39#1583 "total"Total
    1168#1583 "total"Treasury
    526#1583 "total"Outstanding
    37#1601 "Ord"Total
    831#1601 "Ord"Treasury
    555#1601 "Ord"Outstanding
    38#1600 "Pref"Total
    1323#1600 "Pref"Treasury
    1324#1600 "Pref"Outstanding
    1087#360 "A"Total
    1088#47 "B"Total
    1089#1633 "C"Total
    1170#162 "D"Total
    1169#1632 "otros tipos"Total
    2980#1378 "1"Total
    2981#94 "2"Total
    COLOMBIA
    FS account*SHARES classtotal/treasury/outstanding
    39#1577 "total"Total
    1168#1577 "total"Treasury
    526#1577 "total"Outstanding
    37#843 "Ord"Total
    831#843 "Ord"Treasury
    555#843 "Ord"Outstanding
    38#608 "Pref"Total
    1323#608 "Pref"Treasury
    1324#608 "Pref"Outstanding
    PERU
    FS account*SHARES classtotal/treasury/outstanding
    39#1580 "total"Total
    1168#1580 "total"Treasury
    526#1580 "total"Outstanding
    676#1630 "comunes"Total
    831#1630 "comunes"Treasury
    555#1630 "comunes"Outstanding
    675#1631 "inversion"Total
    1323#1631 "inversion"Treasury
    1324#1631 "inversion"Outstanding
    1089#1587 "C"Total
    OTHER
    FS account*SHARES classtotal/treasury/outstanding
    1087#1641 "A"Total

    Example of how to convert an old *FS command with number of shares accounts to a new *SHARES command   Ejemplo de como convertir un antiguo comando *FS com cuentas con numero de acciones para un nuevo comando *SHARES.

    *FS "empresa" 11 2006-12-31 N 0
    ...
    @39 35000
    @1168 5000
    @526 30000
    @676 22000
    @831 2000
    @555 20000
    @675 13000
    @1323 3000
    @1324 10000
    ...
    END
    

    Should become / Deve tornarse

    *FS "empresa" 11 2006-12-31 N 0
    ...
    (without the @ lines with num of shares accounts)
    (sin las lineas @ con cuentas de cantidades de acciones)
    ...
    END
    
    *SHARES "empresa" 11 2006-12-31 0 #1580 total 35000 #1580 5000 30000 #1630 total 22000 #1630 2000 20000 #1631 total 13000 #1631 3000 10000
    


    *SHARESUPDATE update on information on number of shares

    same as *SHARES except that previous information is not lost, whatever information is included in the *SHARESUPDATE command will overwrite previous number of shares info but classes not included won't be deleted


    *SHAREHOLDER / *SHAREHOLDERIFDOCISNEW register or update a shareholder

    *SHAREHOLDER "name" country "document" [is-main-name, doc-cleaning]
    *SHAREHOLDERIFDOCISNEW "name" country "document" [is-main-name, doc-cleaning]
    
    document
    is the number/letters that identifies this person/company in it's country, usually the tax payer identification number
    is-main-name
    if "Y" or "1", defines that this will be the name that will be displayed in Eco for this person/company
    doc-cleaning
    if "N" or "0", this defines not to clean "document" to associate the item. The default when omitted is "Y" to clear the document.

    Regarding the document id, please note that it will store whatever you specify but when matching a document id such as in the commands *SHAREHOLDERDOC or *SHAREHOLDERS or in *SHAREHOLDER itself (to decide whether this is a new or an existing shareholder), it will disregard any punctuation, spaces and lower/upper case, so if you store a document "12.345.678-ARG" it will be matched when you search for "12345678ARG" or "1.2.3.4.5.6.7.8.a.r.g"

    The difference between *SHAREHOLDER and *SHAREHOLDERIFDOCISNEW is that both will register a new shareholder (i.e. one with a document that was not previously in the database) but only the first one will update an existing shareholder.

    Please note that the list of PFITEM is shared with the list of SHAREHOLDER, the doc must be unique in this combined list. If a company is both an item in a portfolio, and a shareholder, it will be listed only once in the list.

     
    This command also uses three command line parameters that may optionally be specified when starting EcoInput:
    /SHLIMITTOTAL=xxx
    /SHLIMITADD=yyy
    /SHLIMITMOD=zzz
    the use is to generate an error at the end of the check phase of the import file if there are more then yyy adds of new stockholders, or more than zzz modifications to existing stockholders, or if the total of additions and modifications is more than xxx. If you need to review what happened, all the information will be detailed in the file ecoinput.log.

    Please note that the addition of a new name to an existing shareholder (see above) is considered a modification in this context and counts toward the /SHLIMITMOD=zzz limit

    These command line parameters do not apply when doing a "remote import"!!! In this case it will disregard limits and accept whatever is sent on the import file.


    *SHAREHOLDERDOC updates the document of a shareholder

    *SHAREHOLDERDOC "old-doc" country "new-doc" ["name"]
    
    old-doc and country
    used to identify and locate the stockholder
    new-doc
    new document id of this stockholder
    name
    optional, if specified also updates the name of this stockholder


    *SHAREHOLDERS ownership breakdown of a company

    *SHAREHOLDERS "company-ID" country RefDate PublishDate
    *SHAREHOLDERS companyid:"company-ID-value" country:country-value RefDate PublishDate inPercentage typedoc
    *SHAREHOLDERS cnpj:"cnpj-value" country:country-value RefDate PublishDate inPercentage typedoc
    *SHAREHOLDERS ticker:"ticker-value" exchange:exchange-value RefDate PublishDate inPercentage typedoc
    *SHAREHOLDERS isin:"isin-value" exchange:exchange-value RefDate PublishDate inPercentage typedoc
    
    doc country voting non-voting total
    nottocleandoc:doc country voting non-voting total
    idshareholdernopais:idshnp country voting non-voting total
    idshareholder:idsh voting non-voting total
    ...
    (repeat any or all of these lines above as many times as necessary)
    ...
    FREE-FLOAT FREE-FLOAT voting non-voting total
    TOTAL TOTAL voting non-voting total
    end
    
    doc
    document of the shareholder (see *SHAREHOLDER)
    nottocleandoc:
    is a text prefix to define not to clear this document
    idshnp
    is an internal Economatica id of the shareholder in the country specified, it must be preceded by the text "idshareholdernopais:"
    idsh
    is an internal Economatica id of the shareholder, global for all countries, it must be preceded by the text "idshareholder:" and must NOT be followed by a country
    country
    country of the shareholder, it must follow the doc or idshareholdernopais:idsnp fields, but is not present when the idshareholder:idsh form is used
    voting
    number of voting shares, may be ommited by specifying it as "-"
    non-voting
    number of non-voting shares, may be ommited by specifying it as "-"
    total
    total shares, may be ommited by specifying it as "-"

    The line "FREE-FLOAT FREE-FLOAT" is optional



    *PFITEM / *PFITEMIFDOCISNEW register or update a portfolio item

    *PFITEM "name" country "document" [is-main-name, doc-cleaning]
    *PFITEMIFDOCISNEW "name" country "document" [is-main-name, doc-cleaning]
    
    document
    is the number/letters that uniquely identifies this company/asset in it's country, usually the tax payer identification number, ISIN, whatever
    is-main-name
    if "Y" or "1", defines that this will be the name that will be displayed in Eco for this company/asset
    doc-cleaning
    if "N" or "0", this defines "document" not to clear to associate the item. The default when omitted is "Y" to clear the document.

    Regarding the document id, please note that it will store whatever you specify but when matching a document id such as in the commands *PFITEMDOC or *PORTFOLIO or in *PFITEM itself (to decide whether this is a new or an existing item), it will disregard any punctuation, spaces and lower/upper case, so if you store a document "12.345.678-ARG" it will be matched when you search for "12345678ARG" or "1.2.3.4.5.6.7.8.a.r.g"

    The difference between *PFITEM and *PFITEMIFDOCISNEW is that both will register a new item (i.e. one with a document that was not previously in the database) but only the first one will update an existing item.

    The list of *PFITEM is shared with the list of *SHAREHOLDER, the doc must be unique in this combined list. If a company is both an item in a portfolio, and a shareholder, it will be listed only once in the list.

     
    This command also uses three command line parameters that may optionally be specified when starting EcoInput:
    /SHLIMITTOTAL=xxx
    /SHLIMITADD=yyy
    /SHLIMITMOD=zzz
    the use is to generate an error at the end of the check phase of the import file if there are more then yyy adds of new shareholders/portfolio items, or more than zzz modifications to existing shareholders/pfitems, or if the total of additions and modifications is more than xxx. If you need to review what happened, all the information will be detailed in the file ecoinput.log.

    The addition of a new name to an existing pf item (see above) is considered a modification in this context and counts toward the /SHLIMITMOD=zzz limit

    These command line parameters do not apply when doing a "remote import"!!! In this case it will disregard limits and accept whatever is sent on the import file.


    *PFITEMDOC updates the document of a portfolio item

    *PFITEMDOC "old-doc" country "new-doc" ["name"]
    
    old-doc and country
    used to identify and locate the porfolio item
    new-doc
    new document id of this item
    name
    optional, if specified also updates the name of this portfolio item


    *PORTFOLIO held by a fund

    *PORTFOLIO "company-ID" country RefDate PublishDate inPercentage typedoc DateBySource:"DateBySource-value"
    doc country investmenttype [value] [participation%]
    nottocleandoc:doc country investmenttype [value] [participation%]
    idpfitmnopais:idpfinp country investmenttype [value] [participation%]
    idpfitem:idpfi investmenttype [value] [participation%]
    ...
    (repeat any or all of these lines above as many times as necessary)
    ...
    BASE BASE base-value
    TOTAL TOTAL total-value
    end
    
    inPercentage
    are the values in percentage? '-' = 0 = N = values are not in percentage, 1 = Y = values are in percentage
    typedoc
    Type of Document 0,1,3
    DateBySource
    Date informed by source is an optional named parameter used as: DateBySource:"2021-02-01"
    doc
    document of the portfolio item (see *PFITEM)
    nottocleandoc:
    is a text prefix to define not to clear this document
    idpfinp
    is an internal Economatica id of the portfolio item in the country specified, it must be preceded by the text "idpfitemnopais:"
    idpfi
    is an internal Economatica id of the portfolio item, global for all countries, it must be preceded by the text "idpfitem:" and must NOT be followed by a country
    country
    country of the portfolio item, it must follow the doc or idpfitemnopais:idpfinp fields, but is not present when the idpfitem:idpfi form is used
    investmenttype
    number defining the investment type, "tipo de aplicação", currently it has to match this list
    value
    value of this item in the portfolio
    participation%
    % participation of this item in the portfolio, must have a "%" sign at the end
    TOTAL TOTAL
    optional line stating the total of all items in the portfolio; if present, the total must match the sum of all other items
    BASE BASE
    optional line stating the base value of the portfolio; it is like the TOTAL line except that this base value may not match the sum of the other items


    *COMREG Company registration item

    *CLASSREG Class registration item

    *SERIEREG Serie registration item

    *EAAREG EAA registration item

    *EAAREGADDITEMIFNEW EAA registration items

    *EAAREGIFEXISTS EAA registration items

    *COMREG "company-ID" country reg-item value [effective-date]
    *COMREG companyid:"company-ID-value" country:country-value reg-item value [effective-date]
    *COMREG cnpj:"cnpj-value" country:country-value reg-item value [effective-date]
    *COMREG ticker:"ticker-value" exchange:exchange-value reg-item value [effective-date]
    *COMREG isin:"isin-value" exchange:exchange-value reg-item value [effective-date]
    
    *CLASSREG "company-ID" country "class" reg-item value [effective-date]
    *CLASSREG companyid:"company-ID-value" country:country-value "class" reg-item value [effective-date]
    *CLASSREG cnpj:"cnpj-value" country:country-value "class" reg-item value [effective-date]
    *CLASSREG ticker:"ticker-value" exchange:exchange-value - reg-item value [effective-date]
    *CLASSREG isin:"isin-value" exchange:exchange-value - reg-item value [effective-date]
    
    *SERIEREG "ticker" exchange reg-item value [effective-date]
    
    *EAAREG "ticker" exchange reg-item value [effective-date]
    
    *EAAREGADDITEMIFNEW "ticker" exchange reg-item value [effective-date]
    
    *EAAREGIFEXISTS "ticker" exchange reg-item value [effective-date]
    

    The command *EAAREG raises WARNING in case ticker+exchange not exists

    The command *EAAREGIFEXISTS raises EXCEPTION in case ticker+exchange not exists

    The command *EAAREGADDITEMIFNEW raises WARNING in case ticker+exchange not exists

    reg-item
    an "Id:" number from this list
    value
    value of this item, "-" if not available; in case of a reg-item that is a choice to be made from a list, this could be either the exact text of the choice made inside "quotes", or #xx where xx is the item number (not the sequential number when the choices are offered on the screen) or "doc-id:docid" where docid is the document id of the choice such as defined in *LISTCHOICE
    effective-date
    date of the effective start of the "value" parameter for timeline reg-item; empty for non historical values


    *COMREGREPEATDATE Repeat Company registration item on effective date

    *CLASSREGREPEATDATE Repeat Class registration item on effective date

    *SERIEREGREPEATDATE Repeat Serie registration item on effective date

    *COMREGREPEATDATE "company-ID" country reg-item effectivated-date-to-repeat effective-date
    
    *CLASSREGREPEATDATE "company-ID" country "class" reg-item effectivated-date-to-repeat effective-date
    
    *SERIEREGREPEATDATE "ticker" exchange reg-item effectivated-date-to-repeat effective-date
    
    reg-item
    an "Id:" number from this list
    effectivated-date-to-repeat
    date of the effectivated "value" to repeat on new effective-date parameter
    effective-date
    date of the effective start of the "value" for timeline reg-item

  • The value that will be imported is value that is in the database at moment it receives the command and value is not linked to the other one (changing one value DOES NOT change the other value)
  • With no value in date-to-repeat will generate import error

  • *LISTCHOICE Serie registration item

    *LISTCHOICE formatocampo id "text"
    
    *LISTCHOICE formatocampo id "text in Portuguese" "text in English" "text in Spanish"
    
    formatocampo
    an integer number describing the field format whose list of choices will be updated
    id
    either of
  • "NEW" indicating a new choice to be registered
  • an integer number with the id number of the choice being set
  • "doc-id:docid" where docid is the document id of the choice

  •