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 the new STOCKHISTORY function but I have not been able to get it. Attached you will find an example of the table I am trying to build. If you have other ideas, it would be awesome! Thank you!!
5 Replies
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.
- 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), "-")Lorenzo Okay! Didn't know that as I actually never use that function.
