![]() I hope that this article will help you get the up-to-date information about currency exchange rates and you won't be caught unawares when it comes to working with finances. Below you will get a full list of currencies of the world along with few cryptocurrencies supported by GOOGLEFINANCE. To use the GOOGLEFINANCE function properly, you need to know currency codes. For example, the currency code for Canadian dollar is CAD: =GOOGLEFINANCE(CONCATENATE("CURRENCY:", C2, B2), "price", DATE(year($A2), month($A2), day($A2)), DATE(year($A2), month($A2)+1, day($A2)+7), "DAILY") All currency codes for the GOOGLEFINCANCE functionĬurrency codes consist of ALPHA-2 Code (2-letter country code) and of the first letter of the currency name. The DATE function returns year, month, and day from A2. ![]() To combine a few variables into one, we use the CONCATENATE function instead of a traditional ampersand (&). The source data - currency codes and start date - are in A2:C2. Let's find out the EUR to USD exchange rates over a 7-day period: One more example of GOOGLEFINANCE in Google Sheets illustrates how you can use cell references in all arguments of the function. Get exchange rates easier using cell references =GOOGLEFINANCE("CURRENCY:USDEUR","price",TODAY()-10,TODAY()) We can also use the GOOGLEFINANCE function to pull the exchange rates for the last N days (10 days in the formula below): =GOOGLEFINANCE("CURRENCY:USDEUR", "price", A1, A1+5, "DAILY")Ī1 is a start date, and we add the needed number of days to it: You can use cell references instead of dates to simplify the formula and adjust it in a couple of clicks: =GOOGLEFINANCE("CURRENCY:USDEUR", "price", DATE(2017,9,1), DATE(2017,9,10), "DAILY")Īs a result, we have a table with the rates finalized at the end of the day. It can be "DAILY" or "WEEKLY", or in numbers - 1 for daily, 7 for weekly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |