Translate Functional Currency to Reporting Currency USD Equity Accounts

Is there a way to translate by the daily spot rate by transaction in equity accounts instead of taking the period end rate and net activity? For example, the beginning balance in August for Ireland's set of books is $100,000 EUR, and there are 5 transactions for that month that total $10,000 EUR. Instead of taking the net activity balance and converting to USD using the period end rate, is there a way to use the daily spot rate for each date on those 5 transaction? Since this is an Equity Account, we want to make sure we have the