Fx table excel
Import the merged table to Excel. With the resulting table in the Power Query Editor, there is just one thing left for you to do - load it in your Excel workbook. And it is the easiest part! In the Power Query Editor, click the Close & Load drop-down arrow, and choose Close and Load To…. In the Import Data dialog box, select Table and New Worksheet options. Click OK. There are a number of sources of historical currency fx rates which you could download and input into a table. If you have the dates in ascending order in column A and the exchange rate in column b, your vlookup formula could use the date, get the exchange rate, then apply that against your medical bill amount. It is also set with Quoting= Spread, which means the forward fx rates in the table further below are entered as differences f-s (forward – spot). The wizard generates a simple table of input fx forward rates consisting of only two tenors - %1M and %2M - with a flat spread of 0.002, i.e. 20 basis points.