Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...

Add labelDæmaskjöl

Sýnishorn

Skjal

Image Added

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.

Questor.xlsx