Bitcoin Forum
October 21, 2017, 10:36:19 AM *
News: Latest stable version of Bitcoin Core: 0.15.0.1  [Torrent]. (New!)
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Google Spreadsheet for Crypto Investing.Realtime Portfolio monitoring/management  (Read 4822 times)
sonder
Newbie
*
Offline Offline

Activity: 22

immerse yourself


View Profile WWW
April 11, 2017, 07:38:18 PM
 #1

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:
http://i.imgur.com/RroHsOJ.jpg
http://i.imgur.com/bgaz9eO.jpg
http://i.imgur.com/bgaz9eO.jpg
http://i.imgur.com/HSc6Qwy.jpg
http://i.imgur.com/HMd5oxc.jpg
http://i.imgur.com/WjIwZZL.jpg

DEMO Video
https://www.youtube.com/watch?v=fbbNiUzbJfg

Мой канал в Telegram: https://t.me/encryptmymoney
1508582179
Hero Member
*
Offline Offline

Posts: 1508582179

View Profile Personal Message (Offline)

Ignore
1508582179
Reply with quote  #2

1508582179
Report to moderator
1508582179
Hero Member
*
Offline Offline

Posts: 1508582179

View Profile Personal Message (Offline)

Ignore
1508582179
Reply with quote  #2

1508582179
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1508582179
Hero Member
*
Offline Offline

Posts: 1508582179

View Profile Personal Message (Offline)

Ignore
1508582179
Reply with quote  #2

1508582179
Report to moderator
offliberty
Newbie
*
Offline Offline

Activity: 13


View Profile
April 21, 2017, 08:30:45 AM
 #2

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

This will save me a lot of time.
el kaka22
Legendary
*
Offline Offline

Activity: 1120


Crypto-Games.net: Multiple coins, multiple games


View Profile
April 21, 2017, 08:54:33 PM
 #3

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
Member
**
Offline Offline

Activity: 63


View Profile WWW
April 24, 2017, 12:45:21 PM
 #4

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!

Trading robots - wrong assumptions made by beginners - https://bitcointalk.org/index.php?topic=1722689 - share your practical experiences!
sonder
Newbie
*
Offline Offline

Activity: 22

immerse yourself


View Profile WWW
April 25, 2017, 09:14:47 AM
 #5

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

Мой канал в Telegram: https://t.me/encryptmymoney
sonder
Newbie
*
Offline Offline

Activity: 22

immerse yourself


View Profile WWW
April 25, 2017, 09:37:05 AM
 #6

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

Мой канал в Telegram: https://t.me/encryptmymoney
sonder
Newbie
*
Offline Offline

Activity: 22

immerse yourself


View Profile WWW
June 16, 2017, 04:59:30 PM
 #7

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

Мой канал в Telegram: https://t.me/encryptmymoney
sonder
Newbie
*
Offline Offline

Activity: 22

immerse yourself


View Profile WWW
July 05, 2017, 02:22:44 PM
 #8

UPD 05.07.2017

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

Мой канал в Telegram: https://t.me/encryptmymoney
Zephon
Newbie
*
Offline Offline

Activity: 19


View Profile
July 06, 2017, 05:52:45 AM
 #9

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
Newbie
*
Offline Offline

Activity: 2


View Profile
July 09, 2017, 12:42:10 PM
 #10

Please PM me the price
sonder
Newbie
*
Offline Offline

Activity: 22

immerse yourself


View Profile WWW
August 30, 2017, 03:34:51 PM
 #11

UPDATE

Мой канал в Telegram: https://t.me/encryptmymoney
amnizu
Jr. Member
*
Offline Offline

Activity: 52

TokenStars – the first platform to tokenize people


View Profile
August 30, 2017, 07:04:12 PM
 #12

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

sonder
Newbie
*
Offline Offline

Activity: 22

immerse yourself


View Profile WWW
August 30, 2017, 07:44:14 PM
 #13

Now the price is 0.02 btc

Мой канал в Telegram: https://t.me/encryptmymoney
sonder
Newbie
*
Offline Offline

Activity: 22

immerse yourself


View Profile WWW
September 23, 2017, 04:49:32 PM
 #14

UPDATE 22.09.2017

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

Мой канал в Telegram: https://t.me/encryptmymoney
loughlin
Full Member
***
Offline Offline

Activity: 137

Only me!


View Profile
September 30, 2017, 08:31:12 AM
 #15

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
Newbie
*
Offline Offline

Activity: 19


View Profile
October 03, 2017, 01:18:06 AM
 #16

Very nice spreadsheet and author is very helpful if needed!
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!