The Excel formula `I_EOL_CRY_EXCHANGE_RATE` retrieves the average exchange rate across a time range from Exact Online.
Parameters:
- `divisionCode`: division code.
- `foreignCurrencyCode`: foreign currency code
- `calendarDate`: calendar date
- `useExactMatchOnly`: whether to only match on the specific date.
- `searchMaxDaysBefore`: maximum number of days to search before as a positive number. Specify -1 to signal none.
- `searchMaxDaysAfter`: maximum number of days to search after as a
positive number. Specify -1 to signal none.
Returns: average exchange rate across time range.