ABCDEFGH
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
DOGEDNV6rpvH3zjRt9aV3h6WQYCJXvf5HULhP7
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.1Added Google Finance for fiats and improved error control.
35
2.0.2Added daily flux for given asset and improved formulas to show losses on liquidated assets and factor them in.
36
2.0.3Made trades have equality between buy and sell fiat value.
37
2.0.4Added Settings for FIAT currency and stable coins.
38
2.0.5Fixed missing fiat error.
39
2.1.0Added 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.1Fixed Flux.
41
2.1.2Fixed stable coins fiat values.
42
2.1.3Added flux daily/hourly interval.
43
2.1.4Added flux interval choice between daily and hourly.
44
2.1.5Added flux volume and charts. Great for day trading.
45
2.1.6Made Flux support multiple workbooks.
46
2.1.7Improved Flux update error messages.
47
2.1.8Use 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.9Made room for new ATH percentage bar indicator in Coins column L.
49
2.2.0Added 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.1Update ATH every time it's lower than 24h high.
51
2.2.2Updated formulas to account for withdrawing and added notes all over.
52
2.2.3Added discounting of realised profits (withdrawals) from allowance till 0.
53
2.2.4Added error returning to UI.
54
2.2.5Limit error return to a single API.
55
2.2.6Fixed CryptoCompare add fiat values / Removed successful update dialog.
56
2.2.7Added free money columns for Interest, Referrals and Airdrops in Coins.
57
2.3.0Added Wallet tracking for staking wallets.
58
2.3.1Added Wallet tracking for staked and un-staked amounts.
59
2.3.2Upgraded wallet to be multi currency.
60
2.3.3Upgraded wallet with FIAT values and added tracking of Wallet coins into Coins workbook.
61
2.3.4Added Profit/Loss column to wallet workbooks.
62
2.3.5Fixed Airdrop and Interest for wallets display in Coins.
63
2.3.6Made Dashboard Fees graph show wallet fees as well.
64
2.3.7Minor content updates.
65
2.4.0Updated 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.1Updated Flux graphs.
67
2.5.0Added Sparkline to Coins workbook with separate update menu option.
68
2.5.1Made Sparkline color red/green depending on period trend.
69
2.5.2Integrated Sparkline update at the end of Coins update. Automated Wallet in Coins option. Made flux support wallets (2).
70
2.5.3Optimised sparkline update for uneven results and added dedicated menu item if key present on open.
71
2.5.4Added Loss field to Wallets.
72
2.5.5Fixed Add FIAT Values for GOOGLEFINANCE formulas in Wallets.
73
2.5.6Aligned trade types between Trades and Wallets.
74
2.5.7Updated Flux trades formula.
75
2.5.8Fixed Flux trades sorting.
76
2.5.9Added Referral and Mining details from wallets to Coins workbook free section.
77
2.5.10Added 24 hour Profit/Loss in Coins workbook.
78
2.5.11Patched Sparkline against excessively large stray values returned by API.
79
2.5.12Fixed Dashboard taxable formula.
80
2.5.13Integrated deposits, gains and withdrawals from wallets into Dashboard.
81
2.5.14Fixed deposit, withdraw and gift stats from wallets.
82
2.5.15Updated Coins amount and Flux Balance formatting. (Update by copying coins amount formula and Flux workbook)
83
2.6.0Updated Flux to support 5 wallets and added Deposits and HODL workbooks with support for 5 wallets. (Update by copying workbooks)
84
2.6.1Upgraded HODL workbook to show prices at ATH, P/L, Gains and Sparkline. (Update by copying workbook)
85
2.6.2Upgraded Flux, Deposits, HODL and Settings workbooks. (Update by copying everything)
86
2.6.3Added Transaction ID column to Trades and wallet Trades. (Update by copying everything)
87
2.6.4Updated dashboard stats and notes. (Update by copying rows 13 to 21 from Daskboard workbook)
88
2.6.5Updated dashboard stats and Coins formulas from Holdings and Free. (Update by copying rows 13 to 21 from Daskboard workbook and )
89
2.7.0Added Export / Restore functionality. (Update by copying everything)
90
2.7.1Fixed Wallets and Flux restore bug and Flux formula bug. (Update via Export/Restore onwards)
91
2.7.2Fixed Wallets Trades and Convert stats for Dashboard. Fixed Export and Restore.
92
2.7.3Updated Coins amount formula to avoid very small negative numbers < 0.0000000001.
93
2.7.4Fixed Dashboard colors.
94
2.7.5Added menu options for creating New Wallet and Flux workbooks.
95
2.7.6Improved wallets aggregation update.
96
2.7.7Updated Flux layout.
97
2.7.8Added Staking workbook that shows staked/available/total for each staked coin.
98
2.7.9Added Airdrops workbook that shows value over time and by coin and adjusted styles for some workbooks.
99
2.7.10Added order preservation for wallet and flux workbooks in the Export / Restore process.
100
2.7.11Changed Airdrops to Free to show all free coins.