<h2 id="current-currency-value"><a href="#current-currency-value" aria-hidden="true" tabindex="-1"><span class="icon icon-link"></span></a>Current currency value</h2>
<p><code>=GOOGLEFINANCE("Currency:USDGBP")</code></p>
<hr>
<h2 id="historical-currency-value"><a href="#historical-currency-value" aria-hidden="true" tabindex="-1"><span class="icon icon-link"></span></a>Historical currency value</h2>
<p><code>=GOOGLEFINANCE("Currency:USDGBP", "price", DATE(YYYY,MM,DD), DATE(YYYY,MM,DD))</code> for the rates on each day between the two dates.</p>
<p>For the rate on one particular date, in one cell</p>
<p><code>=index(GOOGLEFINANCE("Currency:USDGBP", "price", DATE(YYYY,MM,DD)), 2, 2)</code></p>
<p>Sources</p>
<ul>
<li><a href="https://www.howtogeek.com/449986/how-to-convert-currency-in-google-sheets/">How to Convert Currency in Google Sheets</a></li>
<li><a href="https://support.google.com/docs/thread/13455470/google-finance-retrieve-historical-prices-in-a-single-cell?hl=en">Google finance retrieve historical prices in a single cell</a></li>
</ul>


Current currency value
\=GOOGLEFINANCE("Currency:USDGBP")

Historical currency value
\=GOOGLEFINANCE("Currency:USDGBP", "price", DATE(YYYY,MM,DD), DATE(YYYY,MM,DD)) for the rates on each day between the two dates.
For the rate on one particular date, in one cell
\=index(GOOGLEFINANCE("Currency:USDGBP", "price", DATE(YYYY,MM,DD)), 2, 2)
Sources

How to Convert Currency in Google Sheets
Google finance retrieve historical prices in a single cell


Currency conversion

Current currency value

Historical currency value