Norgate Data Norgate Data
 

AmiBroker Database Layout and Content

Data Fields
AmiBroker Symbols Window
Sectors
AmiBroker Information Window
AmiBroker Charts Window

Data Fields

AmiBroker has fields for Ticker, Date, Open , High, Low, Close, Volume, Open Interest, Aux1 and Aux2.


Notes:

  1. Open Interest - this field is only applicable for futures and derivatives data.
  2. AUX1 (for Stocks) - shows Turnover, which is the dollar amount of the stock traded on the day.
  3. AUX1 (for Continuous Futures) - identifies the current contract month in the series by year and month.
  4. AUX2 and Dividends - dividends are shown in the AUX2 field depending on whether or not they have already been accounted for in the data by the "Price Adjustment" method.
    • If the data is adjusted for capital reconstructions only, then both special and ordinary dividends are shown.
    • If the data is adjusted for capital reconstructions and special dividends, then only ordinary dividends are shown.
    • If the data is adjusted for capital reconstructions, special dividends and ordinary dividends, then no information is shown.

Dividend/Distribution information is shown as of the day before the ex-date - i.e. if you are holding the security at the close, you will be entitled to the dividend/distribution

AmiBroker Symbols Window

The illustrations below show the AmiBroker Markets and Groups that may be populated by the Norgate Data plugin:

Some Group Definitions

Sectors

AmiBroker Sectors are populated by the Norgate Data plugin with information from The Refinitiv Business Classification scheme (TRBC).

The Sectors field has two levels - Group and Industry.

Group corresponds to TRBC level 1 (Economic Sector).

Industry corresponds to TRBC level 4 (Industry)

AmiBroker Information Window

The AmiBroker Information Window allows the display of "metadata" and "fundamentals". The Norgate Data plugin populates many of the available fields but not all of them. Fundamental data is provided for most stocks but not all. Also, some stocks do not have broker estimates for forward EPS, target price etc., so these fields may be empty. The tables below identify the fields that are generally populated along with definitions.

All of these fields are accessible in the AFL via the GetFnData function.

"Fundamental" related fields are only included with stock market subscriptions at the Gold, Platinum or Diamond levels.

Statistics
NameGetFnData FieldDefinitionCalculation
Shares Out.SharesOutNumber of shares outstanding 
Shares FloatSharesFloatNumber of shares outstanding that are freely available for trading ("Free Float") 
% Held by InsidersInsiderHoldPercentData not available for this field 
% Held by InstitutionsInstitutionHoldPercentData not available for this field 
Shares ShortSharesShortData not available for this field 
Shares Short Prior MonthSharesShortPrevMonthData not available for this field 
BetaBetaA measure of a stock's price volatility relative to the market. The slope of the 60 month regression line of the percentage price change of the stock relative to the percentage price change of the benchmark index. Beta values are not calculated if less than 40 months of pricing is available.


Financials
NameGetFnData FieldDefinitionCalculation
EPSEPSEPS excluding extraordinary items - trailing 12 monthThe Adjusted Income Available to Common Stockholders for the trailing twelve months divided by the trailing twelve month Diluted Weighted Average Shares Outstanding.
EPS Est. Current YearEPSEstCurrentYearCurrent Consensus for EPSAs reported to Refinitiv
EPS Est. Next YearEPSEstNextYearData not available for this field 
EPS Est. Next QuarterEPSEstNextQuarterData not available for this field 
Forward EPSForwardEPSData not available for this field 
Book Value (p.s)BookValuePerShareBook value per share - most recent quarterThe Shareholder's Equity divided by the Shares Outstanding at the end of the most recent interim period.
PEG RatioPEGRatioData not available for this field 
Profit MarginProfitMarginNet Profit Margin % - trailing 12 monthThe Income After Taxes for the trailing twelve months divided by Total Revenue for the same period and expressed as a percentage. NOTE: Most Banks and Finance companies do not report revenues when they announce their preliminary quarterly financial results in the press. When this happens, the trailing twelve month value will not be available.
Operating MarginOperatingMarginOperating margin - trailing 12 monthThe trailing 12 months Operating Income divided by the trailing 12 months Total Revenue, multiplied by 100. Operating Income is defined as Total Revenue minus Total Operating Expenses.
1yr target priceOneYearTargetPriceCurrent Consensus Target PriceAs reported to Refinitiv
Return on Assets (ttm)ReturnOnAssetsReturn on average assets - trailing 12 monthThe Income After Taxes for the trailing twelve months divided by the Average Total Assets, expressed as a percentage. Average Total Assets is calculated by adding the Total Assets for the 5 most recent quarters and dividing by 5.
Return on Equity (ttm)ReturnOnEquityReturn on average equity - trailing 12 monthThe Income Available to Common Stockholders for the trailing twelve months divided by the Average Common Equity expressed as a percentage. Average Common Equity is calculated by adding the Common Equity for the 5 most recent quarters and dividing by 5.
Qtrly Rev. GrowthQtrlyRevenueGrowthRevenue Change % - most recent quarter 1 year agoThe most recent interim period Sales minus the Sales for the same interim period 1 year ago divided by the Sales for the same interim period one year ago, multiplied by 100.
Gross Profit (p.s)GrossProfitPerShareData not available for this field 
Sales Per ShareSalesPerShareRevenue per share - trailing 12 monthThe trailing twelve month Total Revenue divided by the Average Diluted Shares Outstanding for the trailing twelve months. NOTE: Most Banks and Insurance companies do not report revenues when they announce their preliminary quarterly financial results in the press. When this happens, the trailing twelve month values will not be available.
EBITDA (p.s)EBITDAPerShareEBITD per share - trailing 12 monthThe trailing twelve month EBITD divided by the Average Shares Outstanding for the same period. EBITD is EBIT plus Depreciation and Amortization expenses (from the Statement of Cash Flows). NOTE: This item is not available for Banks and Insurance companies.
Qtrly Earnings GrowthQtrlyEarningsGrowthEPS Change % - most recent quarter vs corresponding 1 year agoThe most recent interim period EPS minus the EPS for the same interim period 1 year ago divided by the EPS for the same interim period one year ago, multiplied by 100. NOTE: EPS must be positive for both periods. If either EPS value is negative, the result in not meaningful.
Operating Cash FlowOperatingCashFlowData not available for this field 
Leveraged Free Cash FlowLeveredFreeCashFlowData not available for this field 


Dividends & Splits
NameGetFnData FieldDefinitionCalculation
DividendDividendPerShareTrailing 12 month sum of all split-adjusted ordinary dividendsThe sum of the Cash Dividends per share paid to common stockholders during the last trailing twelve month period.
Dividend Pay DateDividendPayDatePayment date for the current dividend 
Ex-Dividend DateExDividendDateEx-dividend date for the current dividend 
Forward DividendForwardDividendPerShareCurrent Consensus for Dividend Per ShareAs reported to Refinitiv
Last Split DateLastSplitDateThe ex-date of the last share split or reverse split (consolidation) 
Last Split RatioLastSplitRatioThe ratio of new shares to old in the last split 
Delisting DateDelistingDateThe last day that the security was available for trading before delisting 

AmiBroker Charts Window

The AmiBroker Charts window has a section for Norgate Data that includes various indicators that can be displayed on a chart. Right-click on an indicator to select "Overlay" or "Insert".

Information about Indicators/Functions available for use in AmiBroker can be seen on our AmiBroker Usage page.