![]() 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 |