CURRENCY CONVERTER USD FULL

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.

interval (optional) - how often you wish to pull the data.Use the DATE function in these arguments. start_date, end_date (optional) - your period of interest.

CURRENCY CONVERTER USD FULL

See a full list of available attributes here.

Currency converter usd