SheetsFinance Docs
Real-time & Pricing

FOREX

SheetsFinance has 100+ real-time FOREX ratios that can be accessed in the same way you would a stock or cryptocurrency to return real-time ratio pricing or historical data. Some examples are:

  • USD/GBP ("USDGBP")

  • USD/EUR ("USDEUR")

  • USD/HKD ("USDHKD")

  • USD/SGD ("USDSGD")

  • USD/CAD ("USDCAD")

  • USD/JPY ("USDJPY")

  • USD/AUD ("USDAUD")

  • EUR/GBP ("EURGBP")

  • EUR/USD ("EURUSD")

  • EUR/HKD ("EURHKD")

  • EUR/AUD ("EURAUD")

  • EUR/JPY ("EURJPY")

  • EUR/SGD ("EURSGD")

See our Symbol Search for the entire list!

Realtime

Realtime FOREX quotes are accessed through our SF() function in the same way you would access stock and crypotcurrency data with our Real-time data type. For example to get the USD/EURO realtime price you would use the following:

=SF("USDEUR", "realTime", "price")

You can access the following FOREX realtime subtypes:

  • Name ("name") - e.g. "USD/EUR"

  • Stock Exchange ("exchange") - always returns FOREX

  • Current Price ("price")

  • Change ("change")

  • Change % ("changesPercentage")

  • Day Low ("dayLow")

  • Day High ("dayHigh")

  • Year Low ("yearLow")

  • Year High ("yearHigh")

  • Price Average 50 days ("priceAvg50")

  • Price Average 200 days ("priceAvg200")

  • Quote Timestamp ("timestamp")

Note: You can use our Function Generator to create the formulas for you.

Time series

Historical price data in the form of daily and intraday time series can be generated for any of the included FOREX ratios in the same way you would access stock or cryptocurrency time series.

Daily

=SF_TIMESERIES("USDEUR", "2000-05-04", "2019-12-13")

Note: Naturally there will be no volume data for FOREX time-series

See Time series for detailed information on how to use the SF_TIMESERIES() function.

Intraday

=SF_TIMESERIES("USDEUR", "null", "null", "1hr")

Note: Naturally there will be no volume data for FOREX time series

See Time series for detailed information on how to use the SF_TIMESERIES() function.

Was this helpful?
Was this helpful?