Hér má finna upplýsingar um allar þjónustur í KODIAK Excel sem viðkemur skráðum félögum.
Questor
Með Questor er hægt að sækja upplýsingar úr árs- og árshlutareikningum fyrirtækja á markaði innan við klukkutíma eftir að uppgjör eru birt. Almennt fall, QuestorKeyLookup(), sækir gögn eftir auðkenni, fjárhagsári, tímabili (Q1,Q2,Q4,3M,6M,9M,Y) og bókhaldslykli.
Föll/Runur | Lýsing |
|---|---|
QuestorCompanies | Returns a list of the companies available. |
QuestorCompanyKeys | Keys used by given company |
QuestorCompanyNameS | Returns the company name for a given ticker symbol |
QuestorEarnings | Returns total earnings |
QuestorEBIT | Returns EBIT |
QuestorEBITDA | Returns the EBITDA for a given fiscal year and period |
QuestorEBITDAEVSD | Returns the EBITDA/EV ratio for a given symbol on a given date. EBITDA/EV is calculated as (EBITDA trailing twelve months)/(Market capital + Interest bearing debt - Cash) |
QuestorEBT | Returns EBT |
QuestorEnterpriseValueSD | Returns the enterprise value in the reported currency for a given symbol and trading date. Calculated as market capital on the given date + interest bearing liabilities (key: 920500) - cash (key: 224000). |
QuestorEVEBITDAAveSDD | Returns the average EV/EBITDA ratio for a given symbol and a given period |
QuestorEVEBITDASD | Returns the EV/EBITDA ratio for a given symbol on a given date. EV/EBITDA calculated as (Market Capital + Interest Bearing Debt - Cash) / EBITDA trailing twelve months. |
QuestorEVEBITSD | Returns the EV/EBIT ratio for a given symbol and trading date |
QuestorFullReport | Full report given the symbol, year and period |
QuestorFullReportEN | Returns the full report for a given symbol, financial year and period. Here the key names are in English |
QuestorGrossProfit | Returns gross profit |
QuestorIndustryS | Returns the industry in which a company operates for a given ticker symbol |
QuestorInsuranceKeys | Returns keys used by SJOVA, VIS and TM |
QuestorKeyFiguresDailySDD | Returns a data set with daily numbers for key figures such as EV/EBITDA, P/E etc for a given symbol and a given date range (inclusive) |
QuestorKeyLevel | Returns the tree position (level) for a given key ID |
QuestorKeyLookup | Returns value for a given key ID |
QuestorKeyLookupD | Key look up given a symbol, date and key. Returns value for the given key on or before the date given. |
QuestorKeyLookupReleaseD | Key look up given a symbol, date and key. Returns value for the given key on or before the date given. Reference date is the release date of the report, not the end of the most recent period. |
QuestorKeyLookupTTMD | 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 | 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. |
QuestorKeyNameEN | Returns the name of a key in English |
QuestorKeyNameIS | Name of the given key in Icelandic |
QuestorKeyParentID | Fetch the parent key id for a given key id |
QuestorKeyPath | Returns the placement in the key tree for a given Key ID or when a formula key, returns the formula for the key. |
QuestorKeys | All the public keys |
QuestorKeysBanks | Returns all the keys use by the banks ARION, ISB, LBANK and KVIKA |
QuestorKeysRetail | Returns the keys for HAGA, N1 and SKEL |
QuestorKeysTelecom | Returns the keys for SIMINN and VOICE |
QuestorLatestQuarterlyRe... | Returns the quarter name for the latest quarterly report for a given company. |
QuestorLatestQuarterlyRe... | Returns the quarter name for the latest quarterly report for a given company before or on a given date. |
QuestorLatestQuarterlyRe... | Returns the fiscal year for the latest quarterly report for a given company. |
QuestorLatestQuarterlyRe... | Returns the fiscal year for the latest quarterly report for a given company on or before a given date |
QuestorLatestReportD | Returns the period end date for the latest report on or before the given date. |
QuestorLatestYearlyRepor... | Returns the fiscal year for the latest yearly report for a given company on or before a given date |
QuestorMarketCapFXD | Returns the market capital for a given symbol on or latest before a given date in the latest reporting currency of the given company. Uses the latest average FX rate for the reporting currency on the given date. |
QuestorNetInterestBearin... | Returns net interest bearing liabilities / EBITDA TTM for a given symbol and a given date. Calculated as interest bearing liabilities (key: 920500) - Cash (key: 224000) and divided by EBITDA TTM. |
QuestorNetInterestBearin... | Returns net interest bearing liabilities for a given symbol and a given date. Calculated as interest bearing liabilities (key: 920500) - Cash (key: 224000) |
QuestorNOIYieldSD | Returns the net real estate income divided by real estate assets ratio for a given symbol and a given trading date. |
QuestorOperatingIncome | Returns operating income |
QuestorPeriodEnd | Returns the date at which the given period ends. Inputs are symbol, fiscal year and the period name in question. |
QuestorPriceToBookSD | Returns P/B ratio for a given symbol on a given date. P/B calculated as Market Capital divided by Equity. |
QuestorPriceToEarningsAv... | Returns the average price to earnings ratio for a given symbol and a given period. |
QuestorPriceToEarningsSD | Returns the trailing twelve month P/E ratio for a given symbol before or on a given trading date. |
QuestorRealEstateKeys | Returns keys used by REITIR, EIK, REGINN and HEIMA. |
QuestorReleaseDateD | Returns the latest report release date for a given symbol before or on a given date. |
QuestorReportCurrency | Returns the currency denomination of a given report |
QuestorReportReleaseSYP | Returns the release date for a given symbol, financial year and period name |
QuestorReports | Returns the reports available for a given symbol |
QuestorTotalIncome | Returns total income give a symbol, year and period |
Dæmaskjöl
Sýnishorn | Skjal |
|---|---|
 | Questor Skjal sem sýnir notkun á föllum og runum fyrir möppuna Questor. Meðal annars árs- og árshlutareikninga fyrirtækja á markaði og samanburður á lykiltölum. Nýjustu útgáfu af Excel (Excel 2021 eða Office 365) þarf til þess að allir eiginleikar dæmaskjalsins virki. |