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.
STOCKHISTORY 5th parameter ([Header], default=1 for Show headers) can be set to 0 (no headers). So formula in B2 could be:
=IFERROR(STOCKHISTORY($A2,B$1,B$1,,0,1), "-")
=IFERROR(STOCKHISTORY($A2,B$1,B$1,,0,1), "-")
Lorenzo Okay! Didn't know that as I actually never use that function.
Riny_van_Eekelen. Played with it only recently after wasting time on Power Query returns only 100 rows