A NEW VERSION OF COMPANY REPORTS IS CALLED QUESTOR
Data from financial statements of public companies in Iceland. The data is updated on the day of release and goes back several years. The data is organized using accounting keys (10201, 13101, EBITDA, Equity etc.), company symbols (HAGA, ICEAIR, VOICE etc.) and financial period names (3M, 6M, 9M, Y, Q1, Q2, Q3, Q4, 1H, 2H).
Description of functions and queries
| Looking up by Key ID - Functions | ||
|---|---|---|
Name | Return Type | Description |
| KeyLookup | Double | Accounting Key Lookup |
Using this function, you can look up an amount from the financial statements based on the following parameters: Symbol (examples: HAGA, SJOVA, OSSRu) Financial Year (example: 2012) Financial Period (options: Q1, Q2, Q3, Q4, 3M, 6M, 9M, Y, 1H, 2H) Key ID (examples: 1, 10, 102, 10201, EBITDA, CashEnd, TotalLiabilities) To know what Key parameter to use, you should look up the KeysCompanySpecific or the KeysGeneral datasets. | ||
| KeyLookupD | Double | Accounting Key Lookup with date |
| KeyName | String | Key Name for a specific accounting key for a specific company |
With KeyName you can look up the name of a key using the following parameters: Symbol (example: TM, N1) Key ID (examples: 10201, CashEnd, 51, 115) | ||
| Reports - Data Sets | ||
Name | Type | Description |
| IncomeStatement | DataSet | Company Income Statement by Period |
| BalanceSheet | DataSet | Balance Sheet by Period |
| CashFlow | DataSet | Statement of Cash Flows |
| FullReport | DataSet | Income Statement, Balance Sheet and Cash Flow in One Report |
| Key Figures - Functions | ||
|---|---|---|
These functions take the following parameters: Symbol, Financial Year, Financial Period | ||
Name | Type | Description |
| Revenues | Double | Revenues by period |
| RevenuesTrailingTwelveMonths | Double | TTM Revenues by symbol |
| GrossProfit | Double | Gross Profit by period |
| EBITDA | Double | EBITDA by period |
| EBITDATrailingTwelveMonths | Double | TTM EBITDA by symbol |
| EBIT | Double | EBIT by period |
| EBT | Double | EBT by period |
| Earnings | Double | Earnings by period |
| EarningsTrailingTwelveMonths | Double | TTM Earnings by symbol |
| NonCurrentAssets | Double | Non-Current Assets by period |
| CurrentAssets | Double | Current Assets by Period |
| TotalAssets | Double | Total Assets by period |
| NonCurrentLiabilities | Double | Non-Current Liabilities by period |
| CurrentLiabilities | Double | Current Liabilities by Period |
| TotalLiabilities | Double | Total Liabilities by period |
| Equity | Double | Equity by period |
| EquityAndLiabilities | Double | Equity and Liabilities by period |
| WCOperations | Double | Working Capital from Operating Activities |
| NetCashFromOA | Double | Net Cash from Operating Activities |
| NetCashFromFA | Double | Net Cash from Financing Activities |
| NetCashFromIA | Double | Net Cash from Investing Activities |
| ChangeInCash | Double | Change in Cash and Cash Equivalents |
| CashEnd | Double | Cash at the End of the Period |
| Information - Data Sets and a Function | ||
Name | Type | Description |
|---|---|---|
| KeysCompanySpecific | DataSet | Company Accounting Keys for Specific Symbol |
This is the Accounting Key Tree Data Set. The only parameter it needs is the Symbol. There is one Key Tree for each company. | ||
| KeysGeneral | DataSet | General keys that can be used in the KeyLookup function for all companies. |
| Here you can find the General Keys. These Keys mean the same thing for all companies. | ||
| FinancialsCurrency | String | The Company Financials Currency |
| CompanyFinancialDetails | DataSet | Company Financial Statement Details |
| ReleaseDateD | DateTime | Latest report date before a given date for a given symbol |
Example sheets |
|---|
HAGA updated |
REGINN new |
Compare all the public Icelandic companies |
Comparison of SIMINN and VOICE |
SIMINN over time |
VOICE over time |
ICEAIR over time |
Basic example |
Basic example 2 |
Compare companies |
Basica example 3 |
Query example |
Show in chart example |