Check out the video "How to setup the Spreadsheet Fund Add-on for Google Sheets"
https://www.youtube.com/watch?v=K10sfTCsERo
Topic: Google Spreadsheet to manage and automate your Crypto Fund (Read 840 times)
UPD
I have released it as a free Gsheet Addon. Install here:
https://chrome.google.com/webstore/detail/spreadsheet-fund/pkjmaijhdpkmfogpmfaennidncpdgmbl
I have released it as a free Gsheet Addon. Install here:
https://chrome.google.com/webstore/detail/spreadsheet-fund/pkjmaijhdpkmfogpmfaennidncpdgmbl
UPD 23 February 2019
1. Ethereum cold wallets parser added
2. Proper Success Fee mechanism (individual accounting of success fee for each customer, a transaction in internal token)
1. Ethereum cold wallets parser added
2. Proper Success Fee mechanism (individual accounting of success fee for each customer, a transaction in internal token)
UPD 25 November 2018
Fixes caused by Coinmarketcap API changes.
The completely new and reliable mechanism of getting the median price from six sources.
1. The "ticker" function firstly retrieve data from: binance, okex and cryptocompare.
2. If none of them returns data, the script tries to get data from: kucoin, bittrex and coinmarketcap (new api version)
3. If none of them returns data - the ticker function will return 0
Fixes caused by Coinmarketcap API changes.
The completely new and reliable mechanism of getting the median price from six sources.
1. The "ticker" function firstly retrieve data from: binance, okex and cryptocompare.
2. If none of them returns data, the script tries to get data from: kucoin, bittrex and coinmarketcap (new api version)
3. If none of them returns data - the ticker function will return 0
Google spreadsheet is really good is usable for this kind of managing a crypto fund, it is likely the same as the Microsoft Excel they are really usable especially with managing your fund and with some offices works. You can save all your record inside it. It can also compute with its own as long as you know how to use it just like Excel.
UPD 21 September 2018
Added multiple balance sync from the same exchange.
Now you can setup any number of accounts (API keys pair) for the same exchange. For example three account for Binance, two accounts for Kraken, etc
And synchronize all accounts in one total balance
Added multiple balance sync from the same exchange.
Now you can setup any number of accounts (API keys pair) for the same exchange. For example three account for Binance, two accounts for Kraken, etc
And synchronize all accounts in one total balance
that's great friends because I also have a Google spreadsheet in my notebook.
and I learned that from my more senior friend who is more aware of the importance of Google Chrome.
I will appreciate my friends for the knowledge they have given me.
and I learned that from my more senior friend who is more aware of the importance of Google Chrome.
I will appreciate my friends for the knowledge they have given me.
I think you are very smart, do not characterize your identity with rank as Junior Member.
thank you once for his info and i will try it, and i also still use Excel for my work in the Signature part.
Thank you friend !
thank you once for his info and i will try it, and i also still use Excel for my work in the Signature part.
Thank you friend !
UPD 13 May 2018
Get stats about your Fund in Telegram, as often as you set the Timer.
Get stats about your Fund in Telegram, as often as you set the Timer.
UPD 27 April 2018
• No "dust" synchronization.
To avoid synchronization of small amounts (dust) in the spreadsheet - now you can set a minimum USD balance that must be synced from exchanges.
• No "dust" synchronization.
To avoid synchronization of small amounts (dust) in the spreadsheet - now you can set a minimum USD balance that must be synced from exchanges.
UPD 20 April 2018
- Added 7d mini graphs on Portfolio Tab (to USD)
https://imgur.com/8Y5ox8z.jpg
Guys thank you for your interest! I will make English subtitles on theese Video tutorials soon:
https://www.youtube.com/watch?v=DsUIZHrcmuw
https://www.youtube.com/watch?v=Wi_YTnJzqKw
https://www.youtube.com/watch?v=elhsQiWg094
https://www.youtube.com/watch?v=tIOrs--WZGk
- Added 7d mini graphs on Portfolio Tab (to USD)
https://imgur.com/8Y5ox8z.jpg
Guys thank you for your interest! I will make English subtitles on theese Video tutorials soon:
https://www.youtube.com/watch?v=DsUIZHrcmuw
https://www.youtube.com/watch?v=Wi_YTnJzqKw
https://www.youtube.com/watch?v=elhsQiWg094
https://www.youtube.com/watch?v=tIOrs--WZGk
Thank you very much to sonder for his updates! But I also think it like allukaYara... links to similar tutorials for non-Russian speakers would be useful.
UPD 11 April 2018
Bitfinex balance synchronization is added.
To this moment you can sync balances from 10 exchanges:
- Binance
- Bittrex
- Bitfinex
- Kraken
- Poloniex
- Liqui
- HitBTC
- Bitstamp
- KuCoin
Bitfinex balance synchronization is added.
To this moment you can sync balances from 10 exchanges:
- Binance
- Bittrex
- Bitfinex
- Kraken
- Poloniex
- Liqui
- HitBTC
- Bitstamp
- KuCoin
Thank you very much to Sonder for this project and for having shared it with us! I love to use Google Spreadsheet because I can use it everywhere and you help me a lot.
Spreadsheets are great for this!
I would also recommend that you check out the Totle Portfolio Management system. It is a super easy way to manage and diversify your coins with the touch of a slider and does not require complex spreadsheets or manual upkeep.
check it out: https://www.totle.com
I've been doing this a long time ago, storing portfolios in spreadsheets and data on spreadsheets is so helpful to access them anytime, even we can see the data we have created some sheets ,, I think it's worth trying I would also recommend that you check out the Totle Portfolio Management system. It is a super easy way to manage and diversify your coins with the touch of a slider and does not require complex spreadsheets or manual upkeep.
check it out: https://www.totle.com
For this there have a app i use for me. Its BLOCKFOLIO.
You can download it from google playstore. After installing just you have to add the token name and details like which exchange you use to trade this, what was the buying price etc. It will give you every update incluiding all exchanger trading ret and its easy to use too.
You can download it from google playstore. After installing just you have to add the token name and details like which exchange you use to trade this, what was the buying price etc. It will give you every update incluiding all exchanger trading ret and its easy to use too.
I love Excel, I still use it. But when people have online portfolio systems, they do not want to use excel. For this reason, especially old investors will use excel. You also designed excel very useful.
UPD 24 March
- Kraken balance sync added
- Bitstamp balance sync added
- KuCoin balance sync added
- Kraken balance sync added
- Bitstamp balance sync added
- KuCoin balance sync added
Sonder, please PM to me. Thanks.
UPD 24 March
- Kraken balance sync added
- Bitstamp balance sync added
- KuCoin balance sync added
- Kraken balance sync added
- Bitstamp balance sync added
- KuCoin balance sync added
UPD 24 January 2018
1. API Balance synchronization for Binance and HitBTC added
2. SuccessFee is automatically calculated for specific period (from and till date)
3. Internal tokens transfer functionality added. Now you can just send tokens from one client to another.
4. Quick 3rd currency change. Change only one cell - all others will apply automatically
Bugs fixed:
- Price function =ticker is improved. Now it more pretty and try to get price directly from bittrex, if no - from cryptocompare, if no - from coinmarketcap, if no - from cryptonator. For example: prices for RDN and AST is working correctly now
- Exchange balance sync is enhanced
- Performance K column bug is fixed
- Minor code optimizations
To get the spreadsheet - make order on the Gumroad: https://gum.co/UMxwE
1. API Balance synchronization for Binance and HitBTC added
2. SuccessFee is automatically calculated for specific period (from and till date)
3. Internal tokens transfer functionality added. Now you can just send tokens from one client to another.
4. Quick 3rd currency change. Change only one cell - all others will apply automatically
Bugs fixed:
- Price function =ticker is improved. Now it more pretty and try to get price directly from bittrex, if no - from cryptocompare, if no - from coinmarketcap, if no - from cryptonator. For example: prices for RDN and AST is working correctly now
- Exchange balance sync is enhanced
- Performance K column bug is fixed
- Minor code optimizations
To get the spreadsheet - make order on the Gumroad: https://gum.co/UMxwE
Jump to: