Built on Google Sheets with data from REST APIs.
Project Overview
The portfolio tracker allows me to track the performance of my JSE stocks and cryptocurrencies. The tracker also lets me track my historic transactions, their worth, and destinations or sources. The tracker was built in Google Sheets using Google App Script to create scripts to automate the collection of price data for each JSE stock and cryptocurrency I have invested in. This script runs every 30 minutes and collects price data by REST APIs from AltCoin Trader and CoinGecko. For JSE stocks, I use Google Sheets’ GOOGLEFINANCE function to fetch information from Google Finance.
With the tracker, I know my total investment(JSE Stocks and Cryptocurrency) and have a performance (profit or loss) breakdown.
For each investment, I know the following:
