Funds

Gengi sjóða hjá íslenskum rekstarfélögum.

Föll og runur

Nafn	Lýsing
FundChange12monthsPercentageD	Returns the percentage change of a given fund for a given day
FundChange1mPercentageD	Returns the one month percentage change for a given fund on a given day.
FundChange24mPercentageD	Returns the two year change for a given fund and date. The change is on a yearly basis
FundChange36mPercentageD	Returns the three year change for a give fund on a given day. The changes is on a yearly basis
FundChange3mPercentageD	Returns the three month change for a given fund and date
FundChange48mPercentageD	Returns the four year change for a give fund on a given day. Change is given on a yearly basis
FundChange60mPercentageD	Returns the five years change for a given fund on a given day. Change is given on a yearly basis
FundChange6mPercentageD	Returns the six month percent change for a given fund and date
FundGroups	Returns a list of group names used for funds
FundPriceD	Displays the price of a fund for a given day. If no price is available for the given day, NULL is returned
FundPricesDD	Lists all prices between two dates for a given fund
Funds	Displays a list of all funds in the system
FundsByGroup	Returns a list of funds for a given group name
FundsbyGroupAll	Returns a list of all groups and the funds within them
FundSizeBySizeDate	Get size of fund by size date, different funds update their sizes at different times.
FundSizeD	Returns the information we have about fund size
FundSizeDateD	Returns the value date for a given date and fund
FundSizeEOLM	Return last valid fund size value, relative to date. If date is last day of month, then return latest value, else return last months value.
LastFundPriceD	Displays the price of a fund for a given day. If no price is available for the day, previous price is returned
LastFundPriceDate	The function 'LastFundPriceD' returns the latest price for a given day. The 'LastFundPriceDate' function returns the actual date behind the price returned.

Example sheets
Funds.xlsx