Vision Upload Format: FundamentalA

Vision Portfolio Management Application Layer: Data Feeds

| Application Feeds |

Data Feed: FundamentalA

Category: EntityExtenderFeed

Summary:

    The FundamentalA feed is used to create and update FundamentalDataA data record instances for companies. A separate FundamentalDataA record is created for each fiscal year-end date for which data is available for a company. The data is accessed via the time series property funDataA defined for the Company class.

    This feed can include data for any number of companies for any number of dates and can be used to initialize new dates, set initial values for properties and/or change existing values.

    This class is described in the Portfolio Management Application Supplemental Classes document.

Available Fields:

FieldFundamentalDataA
Property		TypeDescription
--- Required Fields ---
entityId entity String any valid company identifier
date date Date fiscal year-end date of data
currencyId baseCurrency String id of currency for monetary data values
--- Suggested Fields ---
adjustmentDate adjustmentDate Date date through which data values are adjusted
assets _assets Number assets
assetsOther _assetsOther Number other assets
cash _cash Number cash
cogs _cogs Number cost of goods sold
commonEquity _commonEquity Number common equity
curAssets _curAssets Number current assets
curAssetsOther _curAssetsOther Number other current assets
curLiab _curLiab Number current liability
curLiabOther _curLiabOther Number other current liability
debtCurLiab _debtCurLiab Number debt in current liability
defTax _defTax Number deferred tax
deprecAmort _deprecAmort Number depreciation and amortization
income _income Number income
incomeTax _incomeTax Number income tax
intExp _intExp Number interest expense
intang _intang Number intangable assets
inventory _inventory Number inventory
investAndAdvEquity _investAndAdvEquity Number investment and advances - equity
investAndAdvOther _investAndAdvOther Number investment and advances - other
liab _liab Number liabilities
liabOther _liabOther Number other liabilities
ltDebt _ltDebt Number long term debt
minorInt _minorInt Number minority interest
minorIntBS _minorIntBS Number minority interest - balance sheet
netIncome _netIncome Number net income
nonOpIncome _nonOpIncome Number non-operating income
opIncome _opIncome Number operating income
payables _payables Number payables
ppeNet _ppeNet Number property, pland and equipment net
prefStockCV _prefStockCV Number preferred stock
pretaxIncome _pretaxIncome Number pretax income
receivables _receivables Number receivables
sales _sales Number sales
sga _sga Number selling, general and administrative
specialItems _specialItems Number special items
stockhEquity _stockhEquity Number stockholders equity
taxesPayable _taxesPayable Number taxes payable

Special Processing Rules:

  • The entityId must correspond to an existing Company instance. Any valid company alias can be used to identify the company.

  • The date must be included and indicates the fiscal year-end date of the data. It can be in any valid date format such as 9705 or 5/31/97. This date is used to update the Company time series property funDataA.

  • If the entityId and date are valid and the date does not currently exist in the Company time series property funDataA, a new FundamentalDataA instance is created and added to this time series on this date. Any items supplied by this feed are then set or refreshed. Note that you do not need to include all the items in a single feed.

  • The currencyId is used to identify the currency in which the data values are supplied. This currency can be different from the company's base currency. By default, the information is automatically converted into its company's base currency when it is accessed (in cases where the currencies are different). If the supplied currencyId does not map to an existing currency instance, the record's baseCurrency is set to the default currency.

  • The adjustmentDate is used to identify the date through which the data in the feed instance has been adjusted for splits. Normally, this date is the same as the record's date and this field need not be provided. When loading history and/or corrections, the values may be supplied unadjusted (i.e., the values that existed on the date) or adjusted (i.e., the values adjusted for any splits that have occurred since the date). If the data is unadjusted, the adjustmentDate field is not needed or can contain the same value as the date field. If the data has been adjusted to reflect splits that have occurred since the record date, this field should indicate the date through which splits have been applied.

    Note that you do not need to resend data that has changed as the result of a split adjustment. Only true data corrections need to be supplied using this feed.

Related Feeds:

Sample Upload:

The following tab-delimited feed could be used to create and refresh FundamentalDataA instances: 

     Interface ExternalFeedManager upload: "FundamentalA" using:
     "entity     date     currency     adjustmentDate     sales     cogs
      45920010   19951231 USD          19971217             71940.00  37618.00
      45920010   19961231 USD          19971217             75947.00  41732.00
      00036110   19960531 USD          19971217               504.99    404.11
      00036110   19970531 USD          19971217               589.33    468.50
      00512510   19960331 USD          19971217               269.90    219.76
      00512510   19970331 USD          19971217               402.02    322.43
     " ;