I need to run an 'on field change' action on a workflow on a custom record type. It will run a calculation that uses the current exchange rate between two currencies. Is there a way to get this exchange rate in a formula on a Set Field Value action, or do I need to do a custom script to retrieve the exchange rate first?

Definitely not a workflow for this.