Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

Hér má finna upplýsingar um allar þjónustur í KODIAK Excel sem viðkemur sjóðum.

Currencies

Föll og runur til að sækja gengi gjaldmiðla, frá Seðlabanka Íslands og öðrum birgjum.

Þjónustur

Lýsing

CBCurrencyAveRate

Returns the current average exchange rate against ISK for a given currency. This exchange rate comes from the Central Bank of Iceland. If currencyname = ISK then it returns the average rate of ISK not 1.

CBCurrencyAveRateD

Returns the average exchange rate against ISK for a given currency and date. This exchange rate comes from the Central Bank of Iceland. If currencyname = 'ISK' it returns the average rate of ISK not 1.

CBCurrencyAveRateDD

Returns an average of the average exchange rate against ISK for a given currency and period. This exchange rate comes from the Central bank of Iceland

CBCurrencyBuyRateD

Returns the buy exchange rate against ISK for a given currency and date. This exchange rate comes from the Central Bank of Iceland

CBCurrencyRatesD

Returns exchange rates aginst ISK from the Central Bank of Iceland for all available currencies on a given day

CBCurrencyRatesDD

Returns exchange rates against ISK from the Central Bank of Iceland for a given currency and period

CBCurrencySellRateD

Returns the sell exchange rate against ISK for a given currency and date. This exchange rate comes from the Central Bank of Iceland

CBExchRateIndices

Returns the current average rate for a given exchange rate index (SB1, SB2, SB3, SB4 or SB*) from the Central Bank of Iceland.

CBExchRateIndicesD

Returns the current average rate for a given date and exchange rate index (SB1, SB2, SB3, SB4) or ISK for the official index from the Central Bank of Iceland.

CBExchRateIndicesDD

Returns the current averagerate for a given time period and exchange rate index (SB1, SB2, SB3, SB4 or SB*) from the Central Bank of Iceland

CBExchRateIndicesTypes

Name and description of the indices from the Central Bank of Iceland.

CrossRate

Returns the latest Cross rate for a given currency cross (e.g. "USDCAD") on a given day. The Crosses come from Central banks, banks and exchange bureaus or are derived from those sources.

CrossRateD

Returns the Cross rate for a given currency cross (e.g. "USDCAD") on a given day. The Crosses come from Central banks, banks and exchange bureaus or are derived from those sources.

CrossRateDD

Returns the closing Cross rate for a given currency cross (e.g. "USDCAD") for a given period.

CurrencyInterbankCBIBuys...

Total ISK bought by the central bank in the interbank currency market as reported by Central Bank of Iceland in ISK millions on a given date. (Note. CBI reports volumes with a lag of three business days)

CurrencyInterbankCBIBuys...

Total ISK bought by the central bank in the interbank currency market as reported by Central Bank of Iceland in ISK millions on a given date range. (Note. CBI reports volumes with a lag of three business days)

CurrencyInterbankCBISell...

Total ISK sold by the central bank on the interbank currency market as reported by Central Bank of Iceland in ISK millions on a given date. (Note. CBI reports volumes with a lag of three business days)

CurrencyInterbankCBISell...

Total ISK sold by the central bank on the interbank currency market as reported by Central Bank of Iceland in ISK millions on a given date range. (Note. CBI reports volumes with a lag of three business days)

CurrencyInterbankCBITota...

Interbank currency volume as reported by Central Bank of Iceland in EUR millions on a given date. (Note. CBI reports volumes with a lag of three business days)

CurrencyInterbankCBITota...

Interbank currency volume as reported by Central Bank of Iceland in EUR millions on a given date range. (Note. CBI reports volumes with a lag of three business days)

CurrencyInterbankCBITota...

Interbank currency volume as reported by Central Bank of Iceland in ISK millions on a given date. (Note. CBI reports volumes with a lag of three business days)

CurrencyTypes

Returns all available currency types

FXCrossRateD

Returns the average rate for a given currency cross, base and source.

OffshoreEURISKBuyD

Returns the latest offshore EURISK value from Deutsche Bank for a given date. The data is updated weekly

OffshoreEURISKSellD

Returns the latest Offshore EURISK value from Deutshe Bank for a given date. The data is updated weekly

CurrenciesIntraday

Föl og runur til að sækja gengi gjaldmiðla innan dags.

Þjónustur

Lýsing

FXCrossesAvailable

Returns the currency crosses available and when they were last updated.

FXDataSourceDescription

Returns a description of the given data source

FXDataSources

Data sources for intraday currency data

FXLastRateD

Returns the latest cross rate for a given currency cross before a given date time from a given data source

FXLastRateDateTimeD

Returns the date and time for the latest information for a given source, currency cross before or on the given date and time.

FXRateDD

Returns a data set including date and time, bid, average rate, ask for a given currency cross and a given date time range for a given data source

FXRateLast

Returns the latest intraday cross rate for a given currency cross and given data source.

FXRateLastAsk

Returns the latest sell rate for a given currency cross from a given data source

FXRateLastBid

Returns the latest buy rate for a given currency cross from a given data source

FXRateToday

Returns a dataset including the date and time, bid, average rate, ask for a given currency cross from a given data source

Rates

Föll og runur til að sækja vexti gjaldmiðla, t.d. LIBOR, REIBOR, EURIBOR o.fl.

Þjónustur

Lýsing

AllLiborD

Returns liborvalues for all available currencies for a given libortype and date. All libortypes can be found in the query LiborTypesList.

Bubor

Returns the current bubor rate for a given bubor type. All bubor types can be found in the query BuborTypeList.

BuborAllDD

Returns bubor values for all bubor types for a given period

BuborD

Returns the bubor rate for a given date and bubor type. All bubor types can be found in the query BuborTypesList.

BuborDD

Returns bubor information for a given period and bubor type. All bubor types can be found in the query BuborTypesList.

BuborTypeList

Returns a list of all bubor types

CBI28DagaInnlanD

Latest value at or before the given date

CBI28DagaInnlanDD

Innstæðubréf, 28 daga, hámarksvextir, vextir Seðlabanka Íslands.

CBI7DagaInnlanD

Latest value at or before the given date

CBI7DagaInnlanDD

Innlán bundin, 7 daga, flatir vextir

CBIDaglanavextirD

Latest value at or before a given date

CBIDaglanavextirDD

Daglán, forvextir, vextir Seðlabanka Íslands.

CBIStyrivextirD

Latest value at or before the given date

CBIStyrivextirDD

Stýrivextir Seðlabanka Íslands, forvextir, lán gegn veði í verðbréfum til 7 daga.

CBIVedlan7DagaD

Stýrivextir Seðlabanka Íslands, forvextir, lán gegn veði í verðbréfum til 7 daga.

CBIVedlan7DagaDD

Stýrivextir Seðlabanka Íslands, forvextir, lán gegn veði í verðbréfum til 7 daga.

CBIVidskiptareikningarIn...

Latest value at or before the given date

CBIVidskiptareikningarIn...

Viðskiptareikningar innlánsstofnana, vextir Seðlabanka Íslands.

Cibor

Returns the current cibor rate for a given cibor type. All cibor types can be found in the query CiborTypeList.

CiborAllDD

Returns cibor values for all cibor types for a given period

CiborD

Returns the cibor rate for a given date and cibor type. All cibor types can be found in the query CiborTypeList.

CiborDD

Returns cibor information for a given period and cibor type. All cibor types can be found in the query CiborTypeList.

CiborTypeList

Returns a list of all cibor types

Euribor

Returns the current euribor rate for a given euribor type

EuriborAllDD

Returns euribor values for all euribor types for a given period

EuriborD

Returns the euribor rate for a given date and euribor type

EuriborDD

Returns euribor information for a given period and euribor type

Hibor

Returns the current hibor rate for a given hibor type. All hibor types can be found in the query HiborTypelist.

HiborAllDD

Returns hibor values for all hibor types for a given period

HiborD

Returns the hibor rate for a given date and hibor type. All hibor types can be found in the query HiborTypelist.

HiborDD

Returns hibor information for a given period and hibor type. All hibor types can be found in the query HiborTypelist.

HiborTypelist

Returns a list of all hibor types

IborRateD

Returns the interbank offered rate for a given currency, ibor name, maturity on a given date.

IborRateLatestDateD

Returns the latest date on which a value exists for a given currency, ibor name and maturity on or before a given date.

Libor

Returns the current libor rate for a given currency and libor type. All libor types can be found in the query LiborTypeList.

LiborAllDD

Returns libor values for all libor types for a given period and currency

LiborCurrTypes

Returns a list of all currencies which can be used in the libor functions and queries

LiborD

Returns the libor rate for a given date, currency and libor type. All libor types can be found in the query LiborTypeList.

LiborDD

Returns libor information for a given period, currency and libor type. All libor types can be found in the query LiborTypeList.

LiborTypeList

Returns a list of all libor types

Oibor

Returns the current oibor rate for a given oibor type. All oibor types can be found in the query OiborTypeList.

OiborAllDD

Returns oibor values for all oibor types for a given period.

OiborD

Returns the oibor rate for a given date and oibor type. All oibor types can be found in the query OiborTypeList.

OiborDD

Returns oibor information for a given period and oibor type. All oibor types can be found in the query OiborTypeList.

OiborTypeList

Returns a list of all oibor types

Reibid

Returns the current reibid rate for a given reibid type

ReibidAllDD

Returns reibid values for all reibid types for a given period

ReibidD

Returns the reibid rate for a given date and reibid type

ReibidDD

Returns reibid information for a given period and reibid type

Reibor

Returns the current reibor rate for a given reibor type. All reibor types can be found in the query ReiborTypeList.

ReiborAllDD

Returns reibor values for all reibor types for a given period

ReiborD

Returns the reibor rate for a given date and rebor type. All reibor types can be found in the query ReiborTypeList.

ReiborDD

Returns reibor information for a given period and reibor type. All reibor types can be found in the query ReiborTypeList.

ReiborTypeList

Returns a list of all reibor types

Sofibor

Returns the current sofibor rate for a given sofibor type. All sofibor types can be found in the query SofiborTypeList.

SofiborAllDD

Returns sofibor values for all sofibor types for a given period.

SofiborD

Returns the sofibor rate for a given date and sofibor type. All sofibor types can be found in the query SofiborTypeList.

SofiborDD

Returns sofibor information for a given period and sofibor type. All sofibor types can be found in the query SofiborTypeList.

SofiborTypeList

Returns a list of all sofibor types

Stibor

Returns the current stibor rate for a given stibor type. All stibor types can be found in the query StiborTypeList.

StiborAllDD

Returns stibor values for all stibor types for a given period

StiborD

Returns the stibor rate for a given date and stibor type. All stibor types can be found in the query StiborTypeList.

StiborDD

Returns stibor information for a given period and stibor type. All stibor types can be found in the query StiborTypeList.

StiborTypeList

Returns a list of all stibor types

SwapAverageRate

Returns swap averagerate for a given currency and swap type. Swap types can be found in the query SwapTypeList.

SwapAverageRateAllDD

Returns Swap averagerates for all swap types for a given period and currency

SwapAverageRateD

Returns the swap averagerate for a given date, currency and swap type. Swap types can be found in the query SwapTypeList.

SwapBuyRate

Returns swap buyrate for a given currency and swap type. Swap types can be found in the query SwapTypeList.

SwapBuyRateAllDD

Returns Swap buyrates for all swaptypes for a given period and currency

SwapBuyRateD

Returns the swap buyrate for a given date, currency and swap type. Swap types can be found in the query SwapTypeList.

SwapCurrencyList

Returns a list of currencies that have Swap-rates available.

SwapCurrencyTypeList

Returns a list of swaprate types for a given currency.

SwapRateDD

Returns Swap information for a given period, currency and swap type. Swap types can be found in the query SwapTypeList.

SwapSellRate

Returns swap sellrate for a given currency and swap type. Swap types can be found in the query SwapTypeList.

SwapSellRateAllDD

Returns Swap sellrates for all swaptypes for a given period and currency.

SwapSellRateD

Returns the swap sellrate for a given date, currency and swap type. Swap types can be found in the query SwapTypeList.

SwapTypeList

Returns a list of all swaprate types

Wibor

Returns the current wibor rate for a given wibor type. Wibor types can be found in the query WiborTypeList.

WiborAllDD

Returns wibor values for all wibor types for a given period

WiborD

Returns the wibor rate for a given date and wibor type. Wibor types can be found in the query WiborTypeList.

WiborDD

Returns wibor information for a given period and wibor type. Wibor types can be found in the query WiborTypeList.

WiborTypeList

Returns a list of all wibor types


Dæmakjöl

Sýnishorn

Skjal

Currencies

Skjalið sýnir veltu á millibankamarkaði með gjaldeyri, gengisvísitölur og gengi helstu gjaldmiðla gagnvart ISK.

Nýjustu útgáfu af Excel (Excel 2021 eða Office 365) þarf til þess að allir eiginleikar dæmaskjalsins virki.

Currencies.xlsx 

Arftaki LIBOR - LIBOR alternative rates

Skjal sem sýnir hvernig á að sækja nýju LIBOR alternative rates. 

Alternativerates.xlsx 

This sheet demonstrates how to use the IborRateD KODIAK Excel function.

Rates

Skjal með upplýsingum hvernig sækja á vexti gjaldmiðla, t.d. LIBOR, REIBOR, EURIBOR o.fl.
Rates.xlsx new

  • No labels