The RECEIVED function returns the amount received at the maturity date for a invested security. Basis is the type of day counting you want to use: 0: US 30/ 360 (default), 1: real days, 2: real days/ 360, 3: real days/ 365 or 4: European 30/ 365. The settlement date must be before maturity date.
A función RECEIVED devolve a cantidade recebida dun valor investido até a data de vencimento. A base é o xeito de contar os días que quer usar: 0: EUA 30/ 360 (por omisión), 1: días reais, 2: días reais/ 360, 3: días reais/ 365 ou 4: Europa 30/ 365. A data de depósito debe ser anterior á data de vencimento.