:
Skip to end of metadata
Go to start of metadata

TABLE 2 - FIELD CODES

Field Code

Translation Portuguese

Translation English

Translation Spanish

Close

Fechamento/Preço/PU

Close/Price/PU

Cierre/Precio/PU

Open

Abertura

Open

Apertura

Low

Mínimo

Low

Mínimo

High

Máximo

High

Máximo

Average

Médio

Average

Promedio

NumTrades

Q Negócios

#Trades

Num Operaciones

NumSharesStk

Q Títulos

#Shares

Cantidad Titulos

Volume

Volume em $

Volume $

Volumen $

Inflows

Captação

Inflows

Captación

Redemption

Resgate

Redemption

Rescate

RedIncTx

Resgate IR

Redemption Income Tax

Rescate IR

TotInvest

Qtd Cotistas

Tot Investors

Cant Inversionistas

NetAssets

Patrimônio

Net Assets

Patrimonio

NetInflows

Capt Líquida

Net Inflows

Capt Neta

MktShare

Market Share

Market Share

Market Share

ShsInflow

Quotas captadas

Shares of inflow

Cuotas captadas

ShsRedeem

Quotas resgatadas

Shares redeeemed

Cuotas rescatadas

InstitInvestors

Quotistas institucionais

Institutional investors

Inversionistas institucionales

Purchases

Compras

Purchases

Compras

Sales

Vendas

Sales

Vendas

NetPurch

Compra Líquida

Net Buy

Compra Neta

NumSharesFnd

Qtde Cotas

# Shares

Cant Cuotas

TotalRed

Resgate Total

Total Redemption

Rescate Total

CleanPrice

Preço limpo

Clean price

Precio limpio

Ytm

Taxa (YTM)

Yield to Maturity (YTM)

Rendimiento (YTM)

Interest

Juros

Interest

Intereses

DiscountRate

Taxa de desconto

Discount rate

Tasa de descuento

DaysToMatur

Dias até vencimento

Days to maturity

Dias por vencer

DaysLastCoup

Dias desde último cupom

Days since last coupon

Dias de cupón vigente

IC

IC

IC

IC

Duration

Duration

Duration

Duración

CleanPricePerc

Preço limpo (%)

Clean price (%)

Precio limpio (%)

TirPercSOpc

TIR % S/Opc

TIR % S/Opc

TIR % S/Opc

Spreads

Spreads

Spreads

Spreads

LiborMargin

Margem Libor

Libor margin

Margen Libor

TotalAsset

Ativo Total

Total Asset

Activo Total

MarketRate

Taxa de mercado

Market rate

Tasa de mercado

YieldSpread

Yield spread

Yield spread

Sobretasa de mercado

ModifiedDuration

Duration modificada

Modified duration

Duracion modificada

MacaulayDuration

Duration de Macaulay

Macaulay duration

Duracion Macaulay

Convexity

Convexidade

Convexity

Convexidad

BuyingRate

Taxa de compra

Buying rate

Tasa de compra

SellingRate

Taxa de venda

Selling rate

Tasa de venta

StandardDeviation

Desvio padrão

Standard deviation

Desviación standard

MinIndRange

Intervalo indicativo mín

Min indicative range

Rango indicativo min

MaxIndRange

Intervalo indicativo máx

Max indicative range

Rango indicativo max

PercPuPar

% PU Par

% PU Par

% PU Par

DurationBD

Duration (DU)

Duration (BD)

Duración (DU)

Percentage

Peso

Percentage

Porcentaje

PortMktValue

Carteira a mercado

Portfolio at market value

Cartera a valor de mercado

RapCD

PMR (dc)

RAP (cd)

PPR (dc)

ByIntRateD1Pa

Taxa juros compra D-1 (aa)

Buying interest rate D-1 (pa)

Tasa interes compra D-1 (aa)

SellIntRateD0Pa

Taxa juros venda D-0 (aa)

Selling interest rate D-0 (pa)

Tasa interes venta D-0 (aa)

See also:

How to import and update user series

What's the file format for importation?

Examples of import files

Asset classes accepted

  • No labels