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 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.
0 kommentar(er)
