{"repo":"lorenzodotta02/Finance-functions-for-Google-Sheets","free":true,"listed":false,"github":"https://github.com/lorenzodotta02/Finance-functions-for-Google-Sheets","clone":"git clone https://github.com/lorenzodotta02/Finance-functions-for-Google-Sheets.git","description":"FFGS is a collection of custom Google Sheets functions designed as an alternative to GOOGLEFINANCE()","language":"JavaScript","stars":29,"topics":["apps-script","bonds","cryptocurrency","etf","finance","gold","google-sheets","api","borsa-italiana","coinmarketcap-api"],"license":"GPL-3.0","category":"blockchain-web3","readme_excerpt":"Finance Functions for Google Sheets A collection of custom Google Sheets functions designed as an alternative to GOOGLEFINANCE() These functions retrieve updated prices for: - Bonds - ETPs (ETFs / ETCs / ETNs) - Cryptocurrencies - Commodities --- Installation Tutorial here --- Available Custom Functions Function Purpose --- --- ETPPRICE(date; code; [stockExchange]; [currency]) Returns the latest price for an ETP (ETF/ETC/ETN) BONDPRICE(date; isin; stockExchange) Returns the latest price for a bond CRYPTOPRICE(date; symbol) Returns the latest cryptocurrency price COMMODITYPRICE(date; name) Returns the latest spot price of a commodity (EUR/gram) ⚠️ Important: date must always be Utils!$A$1, this cell auto-refreshes every 15 minutes and forces recalculation. ⚠️ If you use the US locale, replace semicolons ; with commas. --- Function Inputs Explained ETPPRICE(date; code; [stockExchange]; [currency]) Returns the latest price for an ETP (ETF/ETC/ETN) Parameters: - date → always Utils!$A$1 - code → ISIN code/Yahoo Finance ticker - stockExchange → OPTIONAL but recommended MIC code (ISO 10383) of the market where the ETP is traded - currency → OPTIONAL Currency filter (e.g. \"USD\"). Only used when stockExchange is XLON (London Stock Exchange) Optional parameter: stockExchange This is only needed when you pass an ISIN and want to force a specific market . Supported MICs: MIC Exchange --- --- XETR XETRA XLON London Stock Exchange 🔥 XMIL Borsa Italiana XAMS Euronext Amsterdam XPAR Eurone","default_branch":null,"files":null,"tree":[],"storefront":"/r/lorenzodotta02","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/lorenzodotta02/Finance-functions-for-Google-Sheets/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}