Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
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") |