Forum Discussion
Exchange Rates in Excel
Hello, I'm trying to build a data table with multiple exchange rates for a couple of multiple dates (The close price of the exchange rate for the last 3 days of the last 5 years). I'm trying using th...
elatorre70 Perhaps the attached file can get you started.
The double FILTER function is needed to get rid of the row and column headers that are created by the STOCKHISTORY function. Couldn't think of any other way to do that.
Just in case, for some cells recalculation gives
I guess due to errors are inside. Didn't try to fix it since Lorenzo formula works.