Get exchange rate on a specific date from GoogleFinance
I'm having trouble stopping the googlefinance function on a specific date to use "that" specific exchange rate to convert currency from GBP to EUR.
Here is my formulae:
Here is the error:
When evaluating GOOGLEFINANCE, the query for the symbol: 'CURRENCY:GBPEUR' returned no data.
I've looked at other solutions on SO but none to avail. I've actually added "date" and "price" to my formulae from other solutions. Like so:- Solution 1
First of all,
date(2017,15,11) means the 11th day of 15th month of the year, so you'll need to swap the month and day.
Secondly, historical data queries, such as
=GOOGLEFINANCE("CURRENCY:GBPEUR", "price", date(2017,11,15))
return a table with columns and headers.
Date Close 11/15/2017 23:58:00 1.1163
From the way you use this formula, I see you just want the exchange rate. Wrap the function in
index(..., 2, 2) to get the second cell in second row.
=index(GOOGLEFINANCE("CURRENCY:GBPEUR", "price", date(2017,11,15)), 2, 2)
Get exchange rate on a specific date from GoogleFinance, I am trying to use this formula "=GOOGLEFINANCE("currency:usdegp", "8/1/2018",)". It isn't working with the date there. I would really like it to Currency Exchange Rate of a Specific Date. When you want to get the currency exchange rate of any currency in a specific date, the formula would be as below. Formula: =GOOGLEFINANCE("CURRENCY:USDEUR", "price", DATE(2017,9,1)) This formula returns the exchange rate of USD with EUR on 01/09/2017. Currency Exchange Rates of Specific Dates
your issue is (was) that you trying to force data for non-existing 15th month. syntax for
=DATE(YEAR(), MONTH(), DAY())
so the full formula should be:
=Finance!B4*INDEX(GOOGLEFINANCE("CURRENCY:GBPEUR", "price", DATE(2017, 11, 15)), 2, 2)
=Finance!B4*INDEX(GOOGLEFINANCE("CURRENCY:GBPEUR", "price", "15/11/2014"), 2, 2)
=Finance!B4*INDEX(GOOGLEFINANCE("CURRENCY:GBPEUR", "price", DATEVALUE("15/11/2014")), 2, 2)
=Finance!B4*INDEX(GOOGLEFINANCE("CURRENCY:GBPEUR", "price", A1), 2, 2)
where A1 contains valid date
trying to get Google Finance currency function using a specific date , Some are recorded in USD, others in EUR. I need to convert these values to USD based on the exchange rate on the date of the transaction. My GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval]) ticker - The ticker symbol for the security to consider. It’s mandatory to use both the exchange symbol and ticker symbol for accurate results and to avoid discrepancies. For example, use “NASDAQ:GOOG” instead of “GOOG.” If the exchange symbol is not
Here's my version of this formula.
B3 should be valid date.
=index(GOOGLEFINANCE("CURRENCY:USDCNY", "price", B3), 2, 2)
PS. I'm not sure why, but when I specify the 15-Dec-2018 the formula shows me an error. All other dates are work correct.
Historical Currency Conversion Using GoogleFinance – Sisense , The format for a GOOGLEFINANCE formula to find the current exchange rate is =GOOGLEFINANCE("Currency:USDGBP") , where you can replace USD and GBP with other suitable three-letter currency codes. The example above shows the then-current USD to GBP rate. GOOGLEFINANCE to get currency exchange rates over any period of time. We can use the GOOGLEFINANCE function to see how the currency exchange rates have changed over a specified period of time or for the last N days. Exchange rates over a specified period of time
15-Dec-2018 is a Sunday - hence the error. You can add a -2 or +2 because the error will also pop up on Saturdays. I prefer the -2
How to Convert Currency in Google Sheets, Here is what I am trying to do: Have the GOOGLEFINANCE retrieve the exchange rate given the date on the far left. As you can see, the date on A2,B2,C2 is Stocks are traded on an exchange like the New York Stock Exchange (NYSE), NASDAQ, London Stock Exchange (LSE), and more. You can buy and sell stock through brokers. Google Finance is a stock tracking tool. Google also offers Google Finance as a way to view stock data, including charts to view company performance over time. The best part is that
[Google Sheets] Using GOOGLEFINANCE() to retrieve the exchange , GOOGLEFINANCE to get currency exchange rates over any period of time. We can I have the settlement dates and number of shares but, before 2003, I don't have the purchase price. So, I'm trying to use the GOOGLEFINANCE function to figure out the price but if I write =GoogleFinance("GOOG", "PRICE", 3/3/2000) I get a 2x2 array rather than just the historical price.
Currency conversion in Google Sheets, I'm having trouble stopping the googlefinance function on a specific date to use "that" specific exchange rate to convert currency from GBP to EUR. Here is my Build current and historic rate tables with your chosen base currency with XE Currency Tables. For commercial purposes, get an automated currency feed through the XE Currency Data API.
Get exchange rate on a specific date from GoogleFinance, This section handles the historical currency exchange rates. Convert Currency in Google Sheets, but of a specific date or dates. Currency Exchange Rate of a Monitor the market with Google Finance. Get free stock quotes and up-to-date financial news.