Here are a few Google Scripts to retrieve and parse financial data.
This function gets the current price of cryptocurrencies from CoinMarketCap.com in USD.
This function gets the current price of cryptocurrencies from CoinGecko.com Public API in the selected currency. More details: https://www.coingecko.com/en/api/documentation
This function gets the current price of cryptocurrencies from Newton.co in CAD.
This function gets the account details (balance) of KuCoin.
This fuction retrieves the AnchorUST/UST exchange rate.
⚠️ UST has collapsed the lost the peg to the US dollar in May 2022.
This function gets the current price of precious metals from Kitco.com website.
This function gets the current price of precious metals. This would also need to be provided the API keys.
This function gets the NAV of the Mutual Fund given the mutual fund code in Morning Star.
This function gets the NAV of RBC Mutual Funds given the mutual fund code from RBC Funds.
Feel free to join the open-source community and contribute to this repository.