Tuesday, March 6, 2018

yogi_Compute currency exchange rate for each date noted in column A

Google Spreadsheet   Post  #2389

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-06-2018

question by: Ged Vengauskas
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/9kfoanQVNJQ;context-place=forum/docs
How to list currency exchange rates for each day on Google Spreadsheet?
I would like to know if it is possible to get currency exchange rates for each past day on Google Spreadsheets. 

Currently I have the following formula (Column B contains all the dates that had cash flow): =GOOGLEFINANCE("CURRENCY:EURGBP", "price", B13, B13+100, "DAILY")

The drawback with this formula is that even though it starts with the first given date it disregards that some of the dates on my spreadsheet appear more than once or that some of the dates are not in subsequent order and simply lists new exchange rates in a regular order. With that said I want the formula to follow the dates on my spreadsheet. For example if I would have 30/01/2018 a few times in a row in Column B I would like the formula to give the same exchange rate in each row as long as the date remains the same.

I have also tried this formula:
=GOOGLEFINANCE("CURRENCY:EURGBP", "price", B13:B100, "DAILY")
However the spreadsheet is giving an error.