A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | ||||||||
2 | Please DO NOT request access: Make a COPY from the FILE menu to your OWN Drive. | |||||||
3 | ||||||||
4 | Free crypto portfolio tracker by Transilvlad | |||||||
5 | ||||||||
6 | CryptoBooks v.2.10.1 | |||||||
7 | Powered by CoinGecko & CryptoCompare APIs | |||||||
8 | ||||||||
9 | Version 2: | by Transilvlad | ||||||
10 | Twitter: | https://twitter.com/transilvlad | ||||||
11 | Github: | https://github.com/transilvlad/crypto-books | ||||||
12 | Support: | https://www.reddit.com/r/Terra_Luna_crypto/comments/pdcux6/free_advanced_crypto_multiwallet_tracking_and/ | ||||||
13 | Don't forget to like! | |||||||
14 | ||||||||
15 | Version 1: | by MindupLife | ||||||
16 | Article: | https://mindup.medium.com/free-crypto-portfolio-tracker-based-on-google-sheets-ef76070ec325 | ||||||
17 | Import sheet: | https://docs.google.com/spreadsheets/d/1_N74DXHHTVxcH08Tx_sHiz-2xUxB_qIqfF17x1y8kFE | ||||||
18 | This article is mostly out of date as of version 2. Import sheet is still valid. | |||||||
19 | ||||||||
20 | Donations: | About 500 hours of work went in version 2 of this project so far. | ||||||
21 | BTC: | bc1qlpufkxa00kg2ddv5uunk8rulm6le0hj9ac0657 | ||||||
22 | BNB: | 0x63351C6e4d66B1aAdE9aa588bAA31Dc27CE620d4 | ||||||
23 | LTC: | ltc1qv8vqxg7jfvu9mqrc7cxyd6q9vaerdadczufqsh | ||||||
24 | DOGE | DNV6rpvH3zjRt9aV3h6WQYCJXvf5HULhP7 | ||||||
25 | ||||||||
26 | This is a fork of the original Crypto portfolio tracker for Google Sheets work of TechupBusiness/MindupLife. | |||||||
27 | Original GitHub repository can be found linked from the repo as with all forks. | |||||||
28 | ||||||||
29 | StockBooks v2.0.11 | |||||||
30 | Looking for a tracking sheet for the stock market? | |||||||
31 | https://docs.google.com/spreadsheets/d/1daqc1x5HGAzlBHLOqDH9l0JvN9tKaxgwuA2Jmjc7Nlc/ | |||||||
32 | ||||||||
33 | Changelist | |||||||
34 | 2.0.1 | Added Google Finance for fiats and improved error control. | ||||||
35 | 2.0.2 | Added daily flux for given asset and improved formulas to show losses on liquidated assets and factor them in. | ||||||
36 | 2.0.3 | Made trades have equality between buy and sell fiat value. | ||||||
37 | 2.0.4 | Added Settings for FIAT currency and stable coins. | ||||||
38 | 2.0.5 | Fixed missing fiat error. | ||||||
39 | 2.1.0 | Added CryptoCompare API for FIAT rates. This will make adding bulk FIAT rates without so much throttling as is with CoinGecko. API key is required - See Settings tab. | ||||||
40 | 2.1.1 | Fixed Flux. | ||||||
41 | 2.1.2 | Fixed stable coins fiat values. | ||||||
42 | 2.1.3 | Added flux daily/hourly interval. | ||||||
43 | 2.1.4 | Added flux interval choice between daily and hourly. | ||||||
44 | 2.1.5 | Added flux volume and charts. Great for day trading. | ||||||
45 | 2.1.6 | Made Flux support multiple workbooks. | ||||||
46 | 2.1.7 | Improved Flux update error messages. | ||||||
47 | 2.1.8 | Use CryptoCompare API (key contingent) if CoinGecko fails for reliable Coins update. CryptoCompare doesn't update Rank, Volume, Valuation, ATH and MAX supply. | ||||||
48 | 2.1.9 | Made room for new ATH percentage bar indicator in Coins column L. | ||||||
49 | 2.2.0 | Added X column, fixed ATH not updating when using CryptoCompare API, made flux fall-back to CryptoCompare API if CoinGecko API request failed. | ||||||
50 | 2.2.1 | Update ATH every time it's lower than 24h high. | ||||||
51 | 2.2.2 | Updated formulas to account for withdrawing and added notes all over. | ||||||
52 | 2.2.3 | Added discounting of realised profits (withdrawals) from allowance till 0. | ||||||
53 | 2.2.4 | Added error returning to UI. | ||||||
54 | 2.2.5 | Limit error return to a single API. | ||||||
55 | 2.2.6 | Fixed CryptoCompare add fiat values / Removed successful update dialog. | ||||||
56 | 2.2.7 | Added free money columns for Interest, Referrals and Airdrops in Coins. | ||||||
57 | 2.3.0 | Added Wallet tracking for staking wallets. | ||||||
58 | 2.3.1 | Added Wallet tracking for staked and un-staked amounts. | ||||||
59 | 2.3.2 | Upgraded wallet to be multi currency. | ||||||
60 | 2.3.3 | Upgraded wallet with FIAT values and added tracking of Wallet coins into Coins workbook. | ||||||
61 | 2.3.4 | Added Profit/Loss column to wallet workbooks. | ||||||
62 | 2.3.5 | Fixed Airdrop and Interest for wallets display in Coins. | ||||||
63 | 2.3.6 | Made Dashboard Fees graph show wallet fees as well. | ||||||
64 | 2.3.7 | Minor content updates. | ||||||
65 | 2.4.0 | Updated Flux to display both Overall (Invested, Average & Profit/Loss) and just from Last liquidation. This should aid you in retaining past profits by keeping track of your current investment run. | ||||||
66 | 2.4.1 | Updated Flux graphs. | ||||||
67 | 2.5.0 | Added Sparkline to Coins workbook with separate update menu option. | ||||||
68 | 2.5.1 | Made Sparkline color red/green depending on period trend. | ||||||
69 | 2.5.2 | Integrated Sparkline update at the end of Coins update. Automated Wallet in Coins option. Made flux support wallets (2). | ||||||
70 | 2.5.3 | Optimised sparkline update for uneven results and added dedicated menu item if key present on open. | ||||||
71 | 2.5.4 | Added Loss field to Wallets. | ||||||
72 | 2.5.5 | Fixed Add FIAT Values for GOOGLEFINANCE formulas in Wallets. | ||||||
73 | 2.5.6 | Aligned trade types between Trades and Wallets. | ||||||
74 | 2.5.7 | Updated Flux trades formula. | ||||||
75 | 2.5.8 | Fixed Flux trades sorting. | ||||||
76 | 2.5.9 | Added Referral and Mining details from wallets to Coins workbook free section. | ||||||
77 | 2.5.10 | Added 24 hour Profit/Loss in Coins workbook. | ||||||
78 | 2.5.11 | Patched Sparkline against excessively large stray values returned by API. | ||||||
79 | 2.5.12 | Fixed Dashboard taxable formula. | ||||||
80 | 2.5.13 | Integrated deposits, gains and withdrawals from wallets into Dashboard. | ||||||
81 | 2.5.14 | Fixed deposit, withdraw and gift stats from wallets. | ||||||
82 | 2.5.15 | Updated Coins amount and Flux Balance formatting. (Update by copying coins amount formula and Flux workbook) | ||||||
83 | 2.6.0 | Updated Flux to support 5 wallets and added Deposits and HODL workbooks with support for 5 wallets. (Update by copying workbooks) | ||||||
84 | 2.6.1 | Upgraded HODL workbook to show prices at ATH, P/L, Gains and Sparkline. (Update by copying workbook) | ||||||
85 | 2.6.2 | Upgraded Flux, Deposits, HODL and Settings workbooks. (Update by copying everything) | ||||||
86 | 2.6.3 | Added Transaction ID column to Trades and wallet Trades. (Update by copying everything) | ||||||
87 | 2.6.4 | Updated dashboard stats and notes. (Update by copying rows 13 to 21 from Daskboard workbook) | ||||||
88 | 2.6.5 | Updated dashboard stats and Coins formulas from Holdings and Free. (Update by copying rows 13 to 21 from Daskboard workbook and ) | ||||||
89 | 2.7.0 | Added Export / Restore functionality. (Update by copying everything) | ||||||
90 | 2.7.1 | Fixed Wallets and Flux restore bug and Flux formula bug. (Update via Export/Restore onwards) | ||||||
91 | 2.7.2 | Fixed Wallets Trades and Convert stats for Dashboard. Fixed Export and Restore. | ||||||
92 | 2.7.3 | Updated Coins amount formula to avoid very small negative numbers < 0.0000000001. | ||||||
93 | 2.7.4 | Fixed Dashboard colors. | ||||||
94 | 2.7.5 | Added menu options for creating New Wallet and Flux workbooks. | ||||||
95 | 2.7.6 | Improved wallets aggregation update. | ||||||
96 | 2.7.7 | Updated Flux layout. | ||||||
97 | 2.7.8 | Added Staking workbook that shows staked/available/total for each staked coin. | ||||||
98 | 2.7.9 | Added Airdrops workbook that shows value over time and by coin and adjusted styles for some workbooks. | ||||||
99 | 2.7.10 | Added order preservation for wallet and flux workbooks in the Export / Restore process. | ||||||
100 | 2.7.11 | Changed Airdrops to Free to show all free coins. |