███████╗███████╗ ██████╗ ███████╗ ██╔════╝██╔════╝██╔════╝ ██╔════╝ █████╗ █████╗ ██║ ███╗███████╗ ██╔══╝ ██╔══╝ ██║ ██║╚════██║ ██║ ██║ ╚██████╔╝███████║ ╚═╝ ╚═╝ ╚═════╝ ╚══════╝
A collection of custom
Google Sheets functions
designed as an alternative
to GOOGLEFINANCE()
Finance Functions for Google Sheets provides custom spreadsheet functions that fetch updated prices directly from official exchanges and APIs.
- ETPs (ETFs / ETCs / ETNs)
- Bonds
- Cryptocurrencies
- Commodities
Available Functions
| Function | Purpose |
|---|---|
ETPPRICE(date; code; [stockExchange]; [currency]) |
Latest price for an ETP (ETF/ETC/ETN) from European exchanges |
BONDPRICE(date; isin; stockExchange) |
Latest bond price: Euronext, MOT, EuroTLX, Tradegate, Gettex and more |
CRYPTOPRICE(date; symbol) |
Latest cryptocurrency price via CoinMarketCap |
COMMODITYPRICE(date; name) |
Gold, Silver, Platinum, Palladium spot price (EUR/gram) |
Installation
Follow the step-by-step guide to enable functions in your spreadsheet.
Watch Installation Video