Keep track of forex pair prices in Excel and Google Sheets

 

If you use spreadsheets (Excel or Google Sheets) to manage your forex and metals portfolio, do check out Finsheet ( finsheet.io), a website my friends and I started recently. To get latest quote of EUR/USD, use this one simple function:


=FS_Latest("OANDA:EUR_USD")


If you are a trader that needs intra-day data to do technical analysis or backtesting, this function will give you 1-minute price of EUR/USD from the beginning of today (04/26/2022) until now:


=FS_CryptoCandles("OANDA:EUR_USD", "1", "04/26/2022")


The website is completely free right now since we just launched. Really appreciate if you guys can check it out and let me know any feedback you may have. Thanks a lot.