Google Spreadsheet for Crypto Investing.Realtime Portfolio monitoring/management

[sonder]

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

[1715411566]

1715411566

[1715411566]

1715411566

[1715411566]

1715411566

[offliberty]

I strongly recommend what sonder (or @acosmos on Telegram) did.

This will save me a lot of time.

[el kaka22]

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 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.

[carap]

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!

[sonder]

UPD.
New features added:
1. Poloniex all balances synchronization (works only with Poloniex)
2. Update button added - to refresh all data

[sonder]

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 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.

There are fields that needs to be entered manually: SYMBOL, avg. buy price and amount (but if you store all your wealth (not recommended) on Poloniex - there is a synchronisation using polo API. Yes you need to enable API key in your settings. Make sure that you forbid trades and withdrawals through API key.
Anyway you need to trust Google services because you will store your API key on their cloud servers.

=ticker(asset,main) -  function to get coin price. Returns a ticker price. The price is average value aggregated from 52 exchanges using special API
=specific_price(asset,main,exchange) - can get a ticker from specific exchange using specific API
=cmc(asset,option) - return data for one of 700+ coins from coinmarketcap. Available data: d,name,symbol,rank,price_usd,price_btc,24h_volume_usd,market_cap_usd,available_supply,total_supply,percent_change_1h,percent_change_24h,percent_change_7d,last_updated
=get_balance_data() - return a stringified json with all your balances from poloniex
=balance(data,asset) - parse the cell with stringified json and return specific balance

[sonder]

UPD:

1. CMGR function added.
Now you can see CMGR (Compound Month Growth Rate) for your assets

2. Automatic performance logging added.
Now you set a Timer to write your Portfolio Performance

New screenshots:
http://imgur.com/7P4lD8I.png
http://imgur.com/l8PUqPr.png

[sonder]

UPD 05.07.2017

Ticker function updates and fixes:
- More reliable and fast work
- Crypto to Crypto conversion. For example =ticker("EOS";"ETH")

[Zephon]

UPD:

1. CMGR function added.
Now you can see CMGR (Compound Month Growth Rate) for your assets

2. Automatic performance logging added.
Now you set a Timer to write your Portfolio Performance

New screenshots:
http://imgur.com/7P4lD8I.png
http://imgur.com/l8PUqPr.png

How do I get the spreadsheet?

Thanks

[kotanz]

Please PM me the price

[sonder]

UPDATE

[amnizu]

Price only in PM? It's very hight? Discounts are available? I'm only start trading cryptocurrency.

[sonder]

Now the price is 0.02 btc

[sonder]

UPDATE 22.09.2017

1. One click balance synchronization for Bittrex, Poloniex, Liqui added
2. 24h change % in BTC added on Portfolio sheet

[loughlin]

It is a very interesting thing. Have you no any demo options to try? With limited edit access or something. I need this and i plan to make my own app, but seems this is much easier

[Iza]

Very nice spreadsheet and author is very helpful if needed!

[loughlin]

what is the price now for this app. Bitcoin is going up and i think 0.02 is a big amount.
Can you send me a price on PM?

[multinova]

So what plugin are you using for this?
There is a plugin freely availabel but it doesn't update fast enough, it only updates at certain times.
IS your spreadsheet dynamic (real-time) ?

[sonder]

Yes it is real-time. Yes you can setup triggers and timers to update spreadsheet (even when it closed) every 1 minute.
I am do not use any plugin. This is a separate spreadsheet.

I will update the "genesis spreadsheet" where you will have access (with "make copy" right) forever.You need to make your own copy to your Google drive. File > Create a copy.

[jlanzago]

I think you have done a good job with the spreadsheet. I have developed my own, although not as sophisticated as yours, but still gets the job done. I will patiently take a look at your video, because I could learn some things for you. Also, thank you for sharing with the community your work, I think it helps a lot of folks out there.

[sonder]

Thank you for understanding!
Actually I am going to share this spreadsheet as a free Add-on for google spreadsheets, but with some paid-features like a balance sync, telegram alerts, historical data wirters

[xIIImaL]

Thank you for understanding!
Actually I am going to share this spreadsheet as a free Add-on for google spreadsheets, but with some paid-features like a balance sync, telegram alerts, historical data wirters

Checked OP bro. Awesome project you are doing. If you need to person to help in macro and make a script for you please contact me anytime. I am currently looking out for the project such as web maintenance, front end development and Macro works since I have experience in all these fields I have mentioned.

[loughlin]

Thank you for understanding!
Actually I am going to share this spreadsheet as a free Add-on for google spreadsheets, but with some paid-features like a balance sync, telegram alerts, historical data wirters

Any news from here? 😁

[sonder]

UPD 24.11.2017

- Universal Data Writer functionality is added. Now you can just build the row (or rows) with data and formulas which you want to record and set a Timer (reference is updated). You have 3 copies of writer function (writer, writer_2, writer_3). Why? Just for Timer flexibility.
- Balancing sheet is upgraded. Now you can disable any assets from re-balancing calculations
- TICKER function now more reliable. It get's median price from 3 data providers: coinmarketcap, cryptocompare, cryptonator
If any of the source is down - it still works
- TICKER_4 added as "cryptocompare only" price function
- SPECIFIC_PRICE is fixed (parseFloat added)
- IFERROR handlers added to avoid "erroneous views"
- Telegram triggers minor fixes and 3 copies added (for timers flexibility)

Announcement:
- Free Google Spreadsheet Add-on is almost production-ready. Just need to brush HTML popups and tutorial
- Fund Edition version is ready. Here is a short description. Demo video will be soon.

Fund Edition is advanced spreadsheet which helps to organize and manage your own small fund.  All Fund's internal processes as automated as possible and as transparent as possible:

* Internal Token Issuance to account all shares of your investors properly;
* Easy accounting to accept the money (entrance) and withdraw the money (redeem internal tokens) in any cryptocurrency with one-click automatic calculations and recording of operations on the Issuance tab;
* Accounting of "Success fee" for all your investors with recording on the Issuance tab;
* Asset Scoring model;
* Special tab for rebalancing calculations with Telegram notifications for "Timer" and "Deviation" approaches;
* Easy way to create a "public" version for your fund's spreadsheet and setup automatic synchronization between private and public spreadsheets;
* "Exchanges Balance Synchronization" feature is included;
* "Telegram Triggers" feature is included;
* "Historical Data Writer" feature is included;
* Automatic writing of all fund's performance and history as well;


My Telegram https://t.me/acosmos

[sonder]

UPD 10.12.2017

The new Fund Edition Spreadsheet is ready. You can learn more in new thread:
https://bitcointalk.org/index.php?topic=2559144