Funds

Funds

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

Föll og runur

Nafn

Lýsing

FundChange12monthsPercentageDReturns the percentage change of a given fund for a given day
FundChange1mPercentageDReturns the one month percentage change for a given fund on a given day.
FundChange24mPercentageDReturns the two year change for a given fund and date. The change is on a yearly basis
FundChange36mPercentageDReturns the three year change for a give fund on a given day. The changes is on a yearly basis
FundChange3mPercentageDReturns the three month change for a given fund and date
FundChange48mPercentageDReturns the four year change for a give fund on a given day. Change is given on a yearly basis
FundChange60mPercentageDReturns the five years change for a given fund on a given day. Change is given on a yearly basis
FundChange6mPercentageDReturns the six month percent change for a given fund and date
FundGroupsReturns a list of group names used for funds
FundPriceDDisplays the price of a fund for a given day. If no price is available for the given day, NULL is returned
FundPricesDDLists all prices between two dates for a given fund
FundsDisplays a list of all funds in the system
FundsByGroupReturns a list of funds for a given group name
FundsbyGroupAllReturns a list of all groups and the funds within them
FundSizeBySizeDateGet size of fund by size date, different funds update their sizes at different times.
FundSizeDReturns the information we have about fund size
FundSizeDateDReturns the value date for a given date and fund
FundSizeEOLMReturn last valid fund size value, relative to date. If date is last day of month, then return latest value, else return last months value.
LastFundPriceDDisplays the price of a fund for a given day. If no price is available for the day, previous price is returned
LastFundPriceDateThe function 'LastFundPriceD' returns the latest price for a given day. The 'LastFundPriceDate' function returns the actual date behind the price returned.
Example sheets