I use a LO Calc (I’m running LO 126.96.36.199 on Mac) spreadsheet to keep track of my finances. One payment has to be converted from $12 AUD to GBP as the payment originates in Australia. Is there a way to use Calc to track the exchange rate between the currencies, use that to exchange it back to GBP, and then import the correct payment amount into my sheet?
I’m not sure that this section should be fully automated immediately.
For example, I just went (at random) to this site, got a value of 6.65 (or 6.66?) for the specified amount.
If I had to do your work, I would check this value with two or three more resources before entering this data into the spreadsheet. And I would know for sure that the value is correct.