Stuðningsþjónustur og Reference data
- Heiða
Hér má finna upplýsingar um allar þjónustur í KODIAK Excel sem notaðar er til stuðnings við aðrar þjónustur.
Utilities
Ýmis föll og runur til að nota með öðrum þjónustum.
Upplýsingar um ýmiskonar forsendur og lista, svo sem lista af öllum skráðum auðkennum á hverjum undirmarkaði, lista af undirmörkuðum, lista af kauphallaraðilum og grunnupplýsingar um hvert auðkenni.
Upplýsingar um uppfærslutíma á nýjustu gögnum þannig að notendur geti séð ef gögn eru óeðlilega gömul eða uppfærsla ekki eðlileg.
Föllin GeniusNow() og GeniusToday() eru KODIAK útgáfur af Excel föllunum Now() og Today() sem henta engan vegin með KODIAK og notendur skulu forðast að nota.
Föllin NextBusinessDay() og PriorBusinessDay() skila upplýsingum um síðasta og næsta viðskiptadag miðað við gefinn dag.
Þjónustur | Lýsing |
|---|---|
AllNasdaqOMXSymbols | Returns a list of all symbols listed on the Nasdaq OMX exchange |
AllXICESymbolsDD | Returns all symbols trading on the XICE exchange between two dates. |
BankdaysCountDD | Returns number of bankdays for a given period |
BankdaysDD | Returns all bankdays in a given period |
DatabaseTimestamp | Returns the date and time when the summary trade information was registered in the database |
GeniusNow | Returns the time and date of the Genius database server. |
GeniusToday | Returns the current date of the Genius database server. |
IcexMemberName | Returns the name for a member symbol |
IcexMembers | Returns a list of all current members trading in the Icelandic Stock Exchange |
IsoCountryCodeToName | Returns the english name for a given country IsoCode |
LastDayOfMonth | Returns the last day of a given month |
NextBankday | Returns the next bankday according to a given date |
NextBankday2 | Returns the next bankday according to a given date |
NextBusinessDay | Returns the next trading date according to a given date |
NextBusinessdayToday | Returns the next businessday according to the current day |
PreviousBusinessday | Returns the previous trade date according to a given date |
SubMarketList | Returns the names of all submarkets |
SubMarketListExchange | Returns the names of all submarkets for a given exchange |
SubmarketSymbols | Returns all symbols in a given submarket. To get a list of all submarkets use the SubMarketList method |
ReferenceData
Föll til að fletta upp ýmsum upplýsingum um skráð auðkenni.
Þjónustur | Lýsing |
|---|---|
AmortizationTypeS | Returns the amortization type for a given bond symbol |
AverageDailyTurnover | Returns the average daily turnover given tradable. The yearly turnover, divided by the number of trading days, excluding negotiated (reported) trades according to the Nasdaq INET trading system |
AverageDailyTurnoverEUR | Returns the average daily turnover as reported by the Nasdaq exchange in EUR |
BaseIndexValueS | Returns the base value for an index for a given bond symbol |
BasicDataNameByCode | Returns the name based on a basic data id code |
Isin | Returns an ISIN code for a given symbol |
IsinToSymbol | Returns a symbol for a given ISIN code |
IssuerName | Returns the name of a given issuer symbol |
IssuerNameS | Returns the issuer name for a given bond symbol |
LISThreshold | Returns the 'Large in scale' threshold in the trading currency (using the latest CBI rate) |
LISThresholdEUR | Returns the 'Large in scale' threshold in EUR for the given share |
ListingDate | Returns the listing date of a given security |
LongName | Returns the name for a given symbol |
OwnShares | Returns the amount of shares owned by the company. Data comes from VBSI and is updated every Friday |
OwnSharesD | Returns the amount of own shares owned by the company at a given date. Data is from VBSI and is updated every Friday. The oldest data is from 20.03.2014 |
OwnSharesLatestDateD | Latest date for which we have information on own shares before a given date regardless of symbol |
OwnSharesLatestDateSD | Latest date for which we have own shares for a given symbol and before a given date |
ReferenceIndexSymbolS | Returns the reference index for a given bond symbol. |
SecurityType | Returns the security type for a given symbol. |
TotalIssue | Returns the number of issued shares for a given symbol |
TotalIssueD | Returns the total number of shares for a given symbol on a given trading date |
TotalIssueLatestDateSD | Latest date for which we have Total Issued Shares for a given symbol and before a given trading date |
TradableCurrency | Returns the issue currency of a given currency |