Useful functions for Google Sheets.

Chilean Currency Functions

=M_UF(date)

Get the Chilean UF in Chilean pesos on a particular date.

@param {Date} date The date of the desired UF value.

@return The value of the UF on the specified date.

=M_USDCLP(date)

Get the US Dollar in Chilean pesos on a particular date.

@param {Date} date The date of the desired US Dollar value.

@return The value of the US Dollar on the specified date.

=M_EURCLP(date)

Get the Euro in Chilean pesos on a particular date.

@param {Date} date The date of the desired Euro value.

@return The value of the Euro on the specified date.