CompanyReports
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 |
Questor
Data from financial statements of publicly traded companies in Iceland. The data is updated on the day of release and goes back several years. The data is organized using keys (111000, 200000 (Assets), 300000 (Equity) 910100 (Total Income) etc.), company symbols (HAGA, ICEAIR, VOICE etc.) and financial period names (3M, 6M, 9M, Y, Q1, Q2, Q3, Q4).
Description of functions and queries
| Looking up by Key ID - Functions | ||
|---|---|---|
Name | Return Type | Description |
| QuestorKeyLookup | Double | Look-up by key, period and symbol |
Using this function, you can look up an amount from the financial statements based on the following parameters: Symbol (examples: HAGA, SJOVA, MARL) Financial Year (example: 2012) Financial Period (options: Q1, Q2, Q3, Q4, 3M, 6M, 9M, Y) Key ID (examples: 110000, 200000, 300000) To know what Key parameter to use, you should look up the QuestorCompanyKeys or for example the QuestorKeysRetail datasets. | ||
| QuestorKeyLookupD | Double | Key look up given a symbol, date and key. Returns value for the given key on or before the date given. |
| QuestorKeyLookupTTMD | Double | Trailing twelve month key lookup before or equal to a given date. There needs to be four quarters available. If the quarters are not consecutive, the outcome might be incorrect. |
| QuestorKeyLookupTTMReleaseD | Double | Returns trailing twelve month value based on a given symbol and key id as well on or before a given date. This function uses release date of reports rather than the end of period date. |
| QuestorKeyPath | String | Returns the placement in the key tree for a given Key ID or when a formula key, returns the formula for the key. |
| QuestorKeyParentID | Double | Fetch the parent key id for a given key id |
| QuestorKeyLevel | Integer | Returns the tree position (level) for a given key ID |
| QuestorKeyNameIS | String | Name of the given key in Icelandic |
With QuestorKeyNameIS you can look up the name of a key using the following parameters: Symbol (example: TM, N1) Key ID (examples: 200000 will give you "Eignir") | ||
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 |