Release Notes for new data and updates

Below you will find release notes for all KODIAK Excel releases along with new data and updates.


New Function

NameDescription
BasePointSpreadReturns the premium on a bond


Deprecated Functions and Queries

The group BondsIndex is no longer updated. Please use functions and queries in the group NasdaqOMXIndex.

NameDescription

AllBondsIndexDetailsD

DEPRECATED - values not updating anymore. Returns value, orderbookweights and description for all indices on að given day
AllBondsIndexSeriesDDDEPRECATED - values not updating anymore. Returns values for all indices and given period
BondsIndexDetailsDDEPRECATED - values not updating anymore. Returns value, orderbookweights and description for a given index and day
BondsIndexDetailsDDDEPRECATED - values not updating anymore. Returns values, orderbookweights and description for a given index and period
BondsIndexListDEPRECATED - values not updating anymore. Returns a list of all bonds indices
BondsIndexNetChangeDEPRECATED - values not updating anymore. Returns the last netchange for a given index
BondsIndexNetChangeDDEPRECATED - values not updating anymore. Returns net change for a given index and date
BondsIndexPointChangeDEPRECATED - values not updating anymore. Returns the last point change for a given index
BondsIndexPointChangeDDEPRECATED - values not updating anymore. Returns point change for a given index and date
BondsIndexSeriesDDDEPRECATED - values not updating anymore. Returns values for a given index and period
BondsIndexValueDEPRECATED - values not updating anymore. Returns the current value for a given index
BondsIndexValueDDEPRECATED - values not updating anymore. Returns value for a given index and date
BondsIndexYieldDEPRECATED - values not updating anymore. Returns the current yield for a given index
BondsIndexYieldDDEPRECATED - values not updating anymore. Returns yield for a given index and date
BondsIndexYieldSeriesDDDEPRECATED - values not updating anymore. Returns values for a given index and period. Skips lines where the index yield is not known
OrderbookWeightDEPRECATED - values not updating anymore. Returns the weight of a given orderbook in a given index
OrderbookWeightDDEPRECATED - values not updating anymore. Returns a weight of an instrument in a given index on a given day


 

New Functions and Queries  

Update KODIAK Excel to use the new functions and queries

GroupNameDescriptionType
FinancialsFinISATStepFiveDetailsFinIsatStep5 plus Ebitda % and Equity %Query 
GenderLensGGenderLensFullReportGefur 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ímabilQuery 
GenderLensGGenderLensScoreGefur GEMMAQ einkunn fyrir gefinn tickerFunction
GenderLensGGenderOfCEOGefur kyn stjórnarformanns fyrir gefinn tickerFunction
GenderLensGGenderOfChairGefur kyn framkvæmdastjóra fyrir gefinn tickerFunction
GenderLensGSizeOfBoardGefur stærð stjórnar fyrir gefinn ticker og dags.Function
GenderLensGSizeOfDirectorsGefur stærð framkvæmdastjórnar fyrir gefinn ticker og dags.Function
GenderLensGWomenOfBoardGefur fjölda kvenna í stjórn fyrir gefinn ticker og dags.Function
GenderLensGWomenOfDirectorsGefur fjölda kvenna í framkvæmdarstjórn fyrir gefinn ticker og dags.Function
NasdaqOMXPricesVwapReturns the intraday VWAP (volume weighted average price) for a given symbolFunction
QuestorQuestorLatestYearlyReportYearDReturns the fiscal year for the latest yearly report for a given company on or before a given dateFunction



Index value

=@IndexValue
=@IndexValueD

Are now available for the following indexes:

OMXI10YI

OMXI10YNI
OMXI5YI
OMXI5YNI
OMXI1YNI