{"repo":"PaulRBerg/cryptfolio-scripts","free":true,"listed":false,"github":"https://github.com/PaulRBerg/cryptfolio-scripts","clone":"git clone https://github.com/PaulRBerg/cryptfolio-scripts.git","description":"A collection of Google Apps Script custom functions for tracking crypto portfolios in Google Sheets","language":"JavaScript","stars":25,"topics":["crypto","cryptocurrency","google-apps-script","google-sheets","portfolio","spreadsheet"],"license":"MIT","category":"blockchain-web3","readme_excerpt":"Cryptfolio Scripts A collection of Google Apps Script custom functions for tracking crypto portfolios in Google Sheets. The price data is pulled using CoinGecko's API, and the token balances are obtained by making queries to various RPC servers like PublicNode. If this project helped you, consider buying me a coffee via [3Cities][3cities] or [GitHub Sponsors][sponsors] . How to Use 1. Obtain a CoinGecko Demo API by following the instructions here. 2. Open the [Cryptfolio template][template] in Google Sheets. 3. Click on \"File\", and then \"Make a copy\". This will create a copy of the template in Google Sheets. 4. From the toolbar, click on \"Extensions\", and then on \"Apps Script\". You should be able to see the code now. 5. Add the chains and tokens you want to track in the ChainId and Token objects in data.gs . 6. Query the price data by running the GET ALL PRICES function. 7. Use the GET ERC20 BALANCE and GET NATIVE BALANCE functions to query your holdings in real-time. 8. Calculate the USD value of your holdings by reading the local price data with INDEX and MATCH . [!NOTE] The GET ALL PRICES can only be run from within Apps Script. See the Custom Functions section below. Template The [template][template] shows how to query balances for ARB, ETH, MKR, and OP, and how to calculate the values of the holdings: Rationale I built this because I was frustrated with the existing solutions, which are either too complex, too expensive, or too unstable. Cryptfolio is: - Free to use - Mi","default_branch":null,"files":null,"tree":[],"storefront":"/r/PaulRBerg","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/PaulRBerg/cryptfolio-scripts/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."}