Currency Exchange Trends with Google Finance: Master In-Cell Charts in Google Sheets

Do you want to create a chart inside a cell that displays the currency exchange trend during the last 30 days? You’re in the right place! This post will show you how to use Google Finance to achieve this easily, freeing you from manual data entry and bringing automated financial insights to your fingertips.

How to Create a Currency Exchange Trend Chart with Google Finance

Creating a currency exchange trend chart in Google Sheets is a simple process if you follow these steps:

1. Enter the GOOGLEFINANCE formula: In the cell where you want to create the chart, enter the GOOGLEFINANCE formula: =GOOGLEFINANCE("CURRENCY:"FROM&TO
   

2. Add the source and target currencies: Replace "FROM" with the source currency ($C$4) and "TO" with the target currency (B9): =GOOGLEFINANCE("CURRENCY:"&$C$4&B9
   

3. Add the attribute: Add the attribute “price”: =GOOGLEFINANCE("CURRENCY:"&$C$4&B9, ”price"
   

4. Set the time range: Add the start and end dates for the time range you want to analyze: =GOOGLEFINANCE("CURRENCY:"&$C$4&B9, ”price”, TODAY()-$C$5, TODAY())
   

5. Wrap the data with the SPARKLINE formula: Enclose the GOOGLEFINANCE formula within the SPARKLINE formula to create the in-cell chart: =SPARKLINE(GoogleFinance("CURRENCY:"&$C$4&B9, "price", TODAY()-$C$5, TODAY()))
   

6. Press "enter" to complete:

Complete formula:

=SPARKLINE(GoogleFinance("CURRENCY:"&$C$4&B9,"price",TODAY()-$C$5,TODAY()))

By following these steps, you can quickly create a chart that shows the currency exchange data retrieved by the GOOGLEFINANCE formula in Google Sheets.

Check out this video tutorial here.

Try it yourself now:

Click here to copy and paste the Google Sheet spreadsheet used in the video.