Formulas and Functions
ఈ కంట్రో‌ల్‌ను మారిస్తే, ఈ పేజీ ఆటోమేటిక్‌గా అప్‌డేట్ చేయబడుతుంది

CURRENCYH

The CURRENCYH function returns historical data on the exchange rate between two currencies for a given date. The value returned is in the currency to which you’re converting (currency‑2).

CURRENCYH(currency-1, currency-2, close, date)

currency-1: The currency code for the currency from which you’re converting. currency‑1 is a string enclosed in quotes.

currency-2: The currency code for the currency to which you’re converting. currency‑2 is a string enclosed in quotes.

close: An optional modal value specifying the exchange rate attribute to be returned.

"close" (0 or omitted): The exchange rate of currency-1 to currency-2 at the close of trading on the day specified by date, expressed as an amount in currency‑2.

"open" (1): The exchange rate of currency-1 to currency-2 at the beginning of trading on the day specified by date, expressed as an amount in currency‑2.

"high" (2): The highest exchange rate on the day specified by date, expressed as an amount in currency‑2.

"low" (3): The lowest exchange rate on the day specified by date, expressed as an amount in currency‑2.

date: The date for which you want the historical exchange rate information. date can be a valid past date string enclosed in quotes (for example "1/11/2014" or "31 Dec 2015"), a formula that returns a past date, or a reference to a cell containing a valid past date or date formula.

Notes

  • Currency codes are defined by ISO 4217, a standard published by the International Organization for Standardization. You can find the ISO 4217 currency codes on the web.

  • If you enter a formula with CURRENCYH when the Internet is unavailable, CURRENCYH returns no value. However, when the Internet becomes available, the formula updates with a value returned by CURRENCYH.

Examples

=CURRENCYH("USD", "GBP", 3, "18/4/2017") returns £0.78, the lowest rate of exchange ("low" or 3) from the United States dollar (USD) to Pounds sterling (GBP) on 18 April 2017.

=CURRENCYH("gbp", "bmd", "open", "31/12/2015") returns BMD1.48, the exchange rate from Pounds sterling (GBP) to the Bermudian dollar (BMD) at the beginning of trading on 31 December 2015.

=CURRENCYH("usd", "aud", "close", TODAY()-2) returns the exchange rate from United States dollars to Australian dollars (in AUD) at the close of trading two days ago.

The CURRENCYH function is powered by Yahoo

See alsoCURRENCY
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ఉపయోగకరంగా ఉందా?
అక్షరాల పరిమితి: 250
అక్షరాల గరిష్ట పరిమితి 250.
మీ ఫీడ్‌బ్యాక్ అందించినందుకు ధన్యవాదాలు.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.