The URL in the example above contains the &f=b fragment, which means bid.
For automatic update when a workbook is opened: You can manually trigger the data refresh by clicking on Data → Refresh All. You can referece to the cell like to any other cell in Excel. That's all, now you have a cell with the desired data.
You can hide the header and the style of the cell by unselecting the Header Row and Banded Rows respectively. The new sheet with the required data will be automatically created. Specify the data URL in the field URL, e.g.
How to import the data from Yahoo Finances to Excel?
I don't believe such a function exists for Excel (at least by default). Divide the EUR/JPY rate by the EUR/USD rate. Get EUR/USD and EUR/JPY using the formula above. Unfortunately, the data source isn't updated.įor example, we want to get the USD/JPY rate for today. This will return the exchange rate between USD and EUR for the date mm/dd/yyyy. Usage: =ECBExchangeRate("mm.dd.yyyy", "USD") Data is supposedly from the European Central Bank.Ĭlick Insert > Script > Search for ECBExchangeRate There's a Google Spreadsheet script that returns the exchange rate between EURO and a currency that you specify. Here are some options for you: GOOGLE SPREADSHEETS
This will work for all exchange rates Google Finance is tracking. E.g, to get the current rate for USD/EUR: =GoogleFinance("CURRENCY:USDEUR") In Google Spreadsheets, getting current exchange rates is very easy with the built-in Google Finance querying function.