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...
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