Historic Currency exchange sheet

Question

I'd like to set a sheet showing the historic exchange rate for a currency since a specified date until today and automatically updated when opening the sheet (like googlefinance in googlesheet).
Like that another cell in another sheet will pick by searching in the table according to another specified date.
If someone did it yet, it would an appreciated shortcut and saving time if shared ?!
Regards