Release Notes for new data and updates
Below you will find release notes for all KODIAK Excel releases along with new data and updates.
Dec 7, 2022
New Function
Name | Description |
|---|---|
BasePointSpread | Returns the premium on a bond |
Nov 22, 2022
Deprecated Functions and Queries
The group BondsIndex is no longer updated. Please use functions and queries in the group NasdaqOMXIndex.
Name | Description |
|---|---|
AllBondsIndexDetailsD | DEPRECATED - values not updating anymore. Returns value, orderbookweights and description for all indices on að given day |
AllBondsIndexSeriesDD | DEPRECATED - values not updating anymore. Returns values for all indices and given period |
BondsIndexDetailsD | DEPRECATED - values not updating anymore. Returns value, orderbookweights and description for a given index and day |
BondsIndexDetailsDD | DEPRECATED - values not updating anymore. Returns values, orderbookweights and description for a given index and period |
BondsIndexList | DEPRECATED - values not updating anymore. Returns a list of all bonds indices |
BondsIndexNetChange | DEPRECATED - values not updating anymore. Returns the last netchange for a given index |
BondsIndexNetChangeD | DEPRECATED - values not updating anymore. Returns net change for a given index and date |
BondsIndexPointChange | DEPRECATED - values not updating anymore. Returns the last point change for a given index |
BondsIndexPointChangeD | DEPRECATED - values not updating anymore. Returns point change for a given index and date |
BondsIndexSeriesDD | DEPRECATED - values not updating anymore. Returns values for a given index and period |
BondsIndexValue | DEPRECATED - values not updating anymore. Returns the current value for a given index |
BondsIndexValueD | DEPRECATED - values not updating anymore. Returns value for a given index and date |
BondsIndexYield | DEPRECATED - values not updating anymore. Returns the current yield for a given index |
BondsIndexYieldD | DEPRECATED - values not updating anymore. Returns yield for a given index and date |
BondsIndexYieldSeriesDD | DEPRECATED - values not updating anymore. Returns values for a given index and period. Skips lines where the index yield is not known |
OrderbookWeight | DEPRECATED - values not updating anymore. Returns the weight of a given orderbook in a given index |
OrderbookWeightD | DEPRECATED - values not updating anymore. Returns a weight of an instrument in a given index on a given day |
Sep 21, 2022
New Functions and Queries
Update KODIAK Excel to use the new functions and queries
Group | Name | Description | Type |
|---|---|---|---|
Financials | FinISATStepFiveDetails | FinIsatStep5 plus Ebitda % and Equity % | Query |
GenderLens | GGenderLensFullReport | Gefur lista yfir öll fyrirtæki, með öllum upplýsingum um kynjaskiptingu og stærðir stjórna og frkv.stjórna fyrir ákveðið tímabil | Query |
GenderLens | GGenderLensScore | Gefur GEMMAQ einkunn fyrir gefinn ticker | Function |
GenderLens | GGenderOfCEO | Gefur kyn stjórnarformanns fyrir gefinn ticker | Function |
GenderLens | GGenderOfChair | Gefur kyn framkvæmdastjóra fyrir gefinn ticker | Function |
GenderLens | GSizeOfBoard | Gefur stærð stjórnar fyrir gefinn ticker og dags. | Function |
GenderLens | GSizeOfDirectors | Gefur stærð framkvæmdastjórnar fyrir gefinn ticker og dags. | Function |
GenderLens | GWomenOfBoard | Gefur fjölda kvenna í stjórn fyrir gefinn ticker og dags. | Function |
GenderLens | GWomenOfDirectors | Gefur fjölda kvenna í framkvæmdarstjórn fyrir gefinn ticker og dags. | Function |
NasdaqOMXPrices | Vwap | Returns the intraday VWAP (volume weighted average price) for a given symbol | Function |
Questor | QuestorLatestYearlyReportYearD | Returns the fiscal year for the latest yearly report for a given company on or before a given date | Function |
Index value
=@IndexValue
=@IndexValueD
Are now available for the following indexes:
OMXI10YI
OMXI10YNI
OMXI5YI
OMXI5YNI
OMXI1YNI