all country currency rate in indian rupees list with symbol

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.

All country currency rate in indian rupees list with symbol