Then, in cell A1 enter the following formula Creating the second Currency Google Sheetįor this next step, simply create a separate Google sheet. To get around this, we must create a second currency spreadsheet. However, for some reason this data does not display correctly when connected directly to Google Data Studio. It has an amount in ZAR that was the exchange rate for each of the currencies on the date listed in the left hand column. ![]() We can use this formula for each of the currencies we want to convert, so that we have a sheet that looks like the one below. You can see the formula at work in the image below. ![]() So we make reference to the cell A2 in our formula. In the formula above, we want to find out what the US dollar to South African rand exchange rate was on 1 January 2014. =index(GoogleFinance( “Currency:USDZAR”, “close”, $A2),2,2) However, I want to see historical data for each of these currencies. That formula converts 1 USD to however many ZAR is the current exchange rate. If I wanted to get the current exchange rate for each currency to the ZAR, I’d use this formula: In my spreadsheet, I want to see how the South African Rand (ZAR) has been trading against the following currencies The first step is to determine what currencies we want to change. There are three steps to creating this report.ġ. ![]() In this post I’ll show you how to make Currency Exchange Rate report in Google Data Studio showing five years worth of data.īefore I begin I owe a big thank you to Lee Hurst, who helped me figure out how to fix some issues in Google Sheets.īelow is the report and I’ll show you how to create it.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |