Recently I have made a Google Spreadsheet for crypto investing with automatic Telegram alerts using Google Apps Script functions.
Originally, I did it for myself, but then a lot of people are interested in such a tool. So I decided to develop this tool to a more interesting product.
This Spreadsheet was conceived so that anyone who knows Excel could build their own systems of any complexity. Actually you can build your own trading systems, analytics and even trading bots (without execution mechanism, but with signal notifications to Telegram)
The full list of features:
1. Real-time prices of 1000+ crypto currencies (you can choose 5 different data providers)
2. Real-time currency convertor: crypto to fiat (14 fiat currencies) and any crypto to any crypto (1000+ cryptocurrencies)
3. Real-time portfolio monitoring
4. Additional real-time data is available:
- last price from specific exchange (14 exchanges are supported)
- total trading volume for 1000+ cryptos
- capitalisation for 1000+ cryptos
- supply of 1000+ cryptos
- 1h/24h/7d price change of 1000+ cryptos
- CMGR % (Compound Month Growth Rate)
- first exchange price
- date of launch
- a lot of meta-data
5. Automatic writing of portfolio data:
- historical prices of assets
- portfolio structure changes
- portfolio performance vs bitcoin prices
6. Sheet "Filter" for initial assessment of blockchain assets
7. Sheet "Scoring" to calculate assets allocation (system for dynamic asset allocation)
8. Automatic checking for signals for Re-balancing actions (based on current deviation) with special Telegram notification.
9. Easy accounting
10. "Top 30 gainers and losers" sheet
11. "New coins" sheet for monitoring new exchange listings
12. Automatic Telegram alerts with custom text for any update/event in the spreadsheet.
13. The Spreadsheet works in the cloud for free. There is no need to keep your PC powered.
14. Source code is opened and editableGoogle Spreadsheets works in your Google Drive (in Google cloud for free). So you don't need to have any dedicated server for such systems.
All instructions inside: for functions, timers, telegram bot setup, etc.
If you are interested in the Spreadsheet, please contact me in Telegram: https://t.me/acosmos
Screenshots:https://i.imgur.com/RroHsOJ.jpghttps://i.imgur.com/bgaz9eO.jpghttps://i.imgur.com/bgaz9eO.jpghttps://i.imgur.com/HSc6Qwy.jpghttps://i.imgur.com/HMd5oxc.jpghttps://i.imgur.com/WjIwZZL.jpgDEMO Videohttps://www.youtube.com/watch?v=fbbNiUzbJfg
