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")Īll 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.See a full list of available attributes here. Before XEU rates are theoretical ones.įor Gold (XAU), Silver (XAG), platinum (XPT) and Palladium (XPD), rates and amounts are expressed in grams ( 1 ounce=31.103 g).Tip. Use the XEU code to see Ecu (European Currency Unit) exchange rates. Use this currency converter for live prices.īefore, the Euro(EUR) exchange rates are theoretical ones. NZD New-Zealand Īny trouble ? See How to use this converterĪmounts can be entered with a comma or dot to separate the decimal part.īe careful : some historic rates of minor currencies are not known a long way in the past.Įxchange rates are refreshed daily and are the official ones published by Central banks on 14 December 2023. On 14 December 2023 100 EUR-Euroland =109.19 USD-United States ġ00 USD-United States =91.58 EUR-Euroland Įnter an amount in the box field of your chosen currency and click here to see the converted amount :ĬNY China This tool converts currencies at a specific date using historical ratesĪctual value adjusted with Consumer Price Index is also computed on bottom of the page for major currenciesįill in the following fields and click Go! Historical currency converter with official exchange rates from 1953
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |