UPD.
New features added:
1. Poloniex all balances synchronization (works only with Poloniex)
2. Update button added - to refresh all data
Topic: Google Spreadsheet for Crypto Investing.Realtime Portfolio monitoring/management - page 2. (Read 6889 times)
April 25, 2017, 05:14:47 AM
April 24, 2017, 08:45:21 AM
I bought this "Google Spreadsheet for real time market data". And it works.
I got few fresh ideas from his scripts.
Good illustration of how powerful google spreadsheets are!
I got few fresh ideas from his scripts.
Good illustration of how powerful google spreadsheets are!
April 21, 2017, 04:54:33 PM
How a google sheet will get update when my portfolio get changed ? DO I need to enter every time I make a change with my portfolio ?
I guess your coverage on wide range of exchanges seems good but are you using any api to get auto update functionality into spread sheet ?
If you take time to explain more on the purpose and real time application of your sheet will be good to understand the use of your hard work.
I guess your coverage on wide range of exchanges seems good but are you using any api to get auto update functionality into spread sheet ?
If you take time to explain more on the purpose and real time application of your sheet will be good to understand the use of your hard work.
I strongly recommend what sonder (or @acosmos on Telegram) did.
This will save me a lot of time.
Vouches from newbie never counts. Better luck next time. This will save me a lot of time.
April 21, 2017, 04:30:45 AM
I strongly recommend what sonder (or @acosmos on Telegram) did.
This will save me a lot of time.
This will save me a lot of time.
April 11, 2017, 03:38:18 PM
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 editable
Google 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: @acosmos or in PM
Screenshots:
https://i.imgur.com/RroHsOJ.jpg
https://i.imgur.com/bgaz9eO.jpg
https://i.imgur.com/bgaz9eO.jpg
https://i.imgur.com/HSc6Qwy.jpg
https://i.imgur.com/HMd5oxc.jpg
https://i.imgur.com/WjIwZZL.jpg
DEMO Video
https://www.youtube.com/watch?v=fbbNiUzbJfg
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 editable
Google 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: @acosmos or in PM
Screenshots:
https://i.imgur.com/RroHsOJ.jpg
https://i.imgur.com/bgaz9eO.jpg
https://i.imgur.com/bgaz9eO.jpg
https://i.imgur.com/HSc6Qwy.jpg
https://i.imgur.com/HMd5oxc.jpg
https://i.imgur.com/WjIwZZL.jpg
DEMO Video
https://www.youtube.com/watch?v=fbbNiUzbJfg
Jump to: