Bitcoin Forum
October 19, 2018, 05:06:01 PM *
News: Make sure you are not using versions of Bitcoin Core other than 0.17.0 [Torrent], 0.16.3, 0.15.2, or 0.14.3. More info.
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Google Spreadsheet to manage and automate your Crypto Fund  (Read 579 times)
sonder
Newbie
*
Offline Offline

Activity: 36
Merit: 0


View Profile WWW
December 10, 2017, 08:40:08 AM
 #1

I have faced with the lack of tool to manage my own small family crypto-investment fund.
The main problem was in complexity to calculate all shares of investors properly, especially in the conditions of constant input and withdrawal of funds.

I decided to build a special Google Spreadsheet which helps to organize and manage your own small fund (thanks to google apps script language) with internal token issuance. All Fund's internal processes as automated as possible and as transparent as possible.

Functionality:
• Internal Token Issuance to account all shares of your investors properly (like Satoshi Pie);
• Easy entrance and withdrawal in any cryptocurrency with one-click automatic calculations, tokens emission/redeem and recording of operations on the Issuance tab;
• Easy management of your fund's cold wallets/exchange storages. Automatic balance synchronization for Poloniex, Bittrex, Liqui, HitBTC, Binance, Kraken, KuCoin, Bitstamp
• Real-time exchange rates for 1200+ crypto and 32 fiat currencies. 5 different sources of data + function to get a median price;
• Tab to account all investor's shares, balances and profit stats;
• Accounting of "Success fee";
• Accounting of Entrance/Redeem/Referal fee with customization;
• Asset Scoring model;
• Tab for rebalancing calculations with Telegram notifications for "Timing" and "Deviation" approaches;
• Easy way to create a "public" version for your fund's spreadsheet and setup automatic synchronization between private and public spreadsheets;
• Automatic Triggers to get "custom-text" notifications about any custom event in your Spreadsheet to your Telegram chat, group chat or channel
• "Historical Data Writer" is a flexible way to write any custom historical data in any time you want;
• Automatic writing of all fund's performance and history as well;
• Real-time portfolio value & internal token price monitoring;
• Easy fund initialization and setup. No coding skills required;

I have recorded video tutorials to describe the most important processes. Check it to get more insights:
General review: https://www.youtube.com/watch?v=DsUIZHrcmuw
Initial setup: https://www.youtube.com/watch?v=Wi_YTnJzqKw
Entrance/Redeem: https://www.youtube.com/watch?v=elhsQiWg094
Success fee: https://www.youtube.com/watch?v=tIOrs--WZGk

If you want to get access to make your own copy - touch me in Telegram https://t.me/acosmos or in PM
1539968761
Hero Member
*
Offline Offline

Posts: 1539968761

View Profile Personal Message (Offline)

Ignore
1539968761
Reply with quote  #2

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

Posts: 1539968761

View Profile Personal Message (Offline)

Ignore
1539968761
Reply with quote  #2

1539968761
Report to moderator
1539968761
Hero Member
*
Offline Offline

Posts: 1539968761

View Profile Personal Message (Offline)

Ignore
1539968761
Reply with quote  #2

1539968761
Report to moderator
IBGigglin
Legendary
*
Offline Offline

Activity: 882
Merit: 1000


Totle


View Profile WWW
December 11, 2017, 06:17:50 PM
 #2

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


▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░▓▓▓▓▓▓
▓▓▓▓▓▓   ░         ░                 ▓▓▓▓▓▓
▓▓▓▓▓▓   ▓▓▓▓▓▓▓▓▓▓▓   ▓▓▓▓▓▓▓▓▓▓▓   ▓▓▓▓▓▓
▓▓▓▓▓▓   ▓▓▓▓▓▓▓▓▓▓▓   ▓▓▓▓▓▓▓▓▓▓▓   ▓▓▓▓▓▓
▓▓▓▓▓▓   ▓▓░     ▓▓▓   ▓▓▓     ▓▓▓   ▓▓▓▓▓▓
▓▓▓▓▓▓   ▓▓▓▓▓   ▓▓▓   ▓▓▓   ▓▓▓▓▓   ▓▓▓▓▓▓
▓▓▓▓▓▓   ░▓▓▓▓   ▓▓▓   ▓▓▓   ▓▓▓▓    ▓▓▓▓▓▓
▓▓▓▓▓▓▓▓    ▓▓   ▓▓▓   ▓▓▓   ▓▓    ▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓       ▓▓▓   ▓▓▓       ▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓     ▓▓▓   ▓▓▓     ▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓   ▓▓▓   ▓▓▓  ░▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░▓▓▓   ▓▓▓░▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓   ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░▒▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
Totle: DEX Aggregator 




                 ▄████▄▄    ▄
██             ████████████▀
████▄         █████████████▀
▀████████▄▄   █████████████
▄▄█████████████████████████
██████████████████████████
  ▀██████████████████████
   █████████████████████
    ▀█████████████████▀
      ▄█████████████▀
▄▄███████████████▀
   ▀▀▀▀▀▀▀▀▀▀▀





       ▄▄▄▄▄▄
    ▄████████
    █████▀▀▀▀
   ▐████
   ▐████
████████████
████████████
   ▐████
   ▐████
   ▐████
   ▐████
   ▐████



                    ▓███    █████   
                    █     ▓█▒   █   
                   ██       ██▒██   
                   █                
            █████████████           
   ████████░             ░████████  
  █░ ░██                     ▒█▒  ██
  █░██     ░▓▓▓▒      ▓▓▓▒     ░█ ██
   ██      ▒▓▓▓▓     ▒▓▓▓▓      ██  
   ██        ░░        ░░       ▒█  
    █░                          █   
     █▓      ██░      ██░     ░█    
       ██░       ████      ░██      
          ████████████████    






                      ▄▄████
                ▄▄▄████████▌
          ▄▄▄███████▀▄█████
     ▄▄█████████▀▀ ▄██████▌
▄▄███████████▀  ▄█████████
 ▀▀▀█████▀    ▄██████████▌
       ██   █████████████
        █▄ █████████████▌
        ▐█▄███▀▀████████
         ███▀    ▀▀████▌
                    ▀▀█
sonder
Newbie
*
Offline Offline

Activity: 36
Merit: 0


View Profile WWW
January 24, 2018, 11:26:20 AM
 #3

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

Activity: 36
Merit: 0


View Profile WWW
March 24, 2018, 06:49:27 AM
 #4

UPD 24 March

- Kraken balance sync added
- Bitstamp balance sync added
- KuCoin balance sync added
Testoman
Newbie
*
Offline Offline

Activity: 12
Merit: 0


View Profile
March 24, 2018, 12:07:28 PM
 #5

UPD 24 March

- Kraken balance sync added
- Bitstamp balance sync added
- KuCoin balance sync added

Sonder, please PM to me. Thanks.
Granxis
Hero Member
*****
Offline Offline

Activity: 700
Merit: 500


★Bitvest.io★ Play Plinko or Invest!


View Profile WWW
March 25, 2018, 07:40:19 AM
 #6

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.



.
.BITVEST DICE.
HAS BEEN RELEASED!


▄████████████████████▄
██████████████████████
██████████▀▀██████████
█████████░░░░█████████
██████████▄▄██████████
███████▀▀████▀▀███████
██████░░░░██░░░░██████
███████▄▄████▄▄███████
████▀▀████▀▀████▀▀████
███░░░░██░░░░██░░░░███
████▄▄████▄▄████▄▄████
██████████████████████

▀████████████████████▀
▄████████████████████▄
██████████████████████
█████▀▀█▀▀▀▀▀▀██▀▀████
█████░░░░░░░░░░░░░████
█████░░░░░░░░░░░░▄████
█████░░▄███▄░░░░██████
█████▄▄███▀░░░░▄██████
█████████░░░░░░███████
████████░░░░░░░███████
███████░░░░░░░░███████
███████▄▄▄▄▄▄▄▄███████

██████████████████████
▀████████████████████▀
▄████████████████████▄
███████████████▀▀▀▀▀▀▀
███████████▀▀▄▄█░░░░░█
█████████▀░░█████░░░░█
███████▀░░░░░████▀░░░▀
██████░░░░░░░░▀▄▄█████
█████░▄░░░░░▄██████▀▀█
████░████▄░███████░░░░
███░█████░█████████░░█
███░░░▀█░██████████░░█
███░░░░░░████▀▀██▀░░░░
███░░░░░░███░░░░░░░░░░

██░▄▄▄▄░████▄▄██▄░░░░
████████████▀▀▀▀▀▀▀██
█████████████░█▀▀▀█░███
██████████▀▀░█▀░░░▀█░▀▀
███████▀░▄▄█░█░░░░░█░█▄
████▀░▄▄████░▀█░░░█▀░██
███░▄████▀▀░▄░▀█░█▀░▄░▀
█▀░███▀▀▀░░███░▀█▀░███░
▀░███▀░░░░░████▄░▄████░
░███▀░░░░░░░█████████░░
░███░░░░░░░░░███████░░░
███▀░██░░░░░░▀░▄▄▄░▀░░░
███░██████▄▄░▄█████▄░▄▄

██░████████░███████░█
▄████████████████████▄
████████▀▀░░░▀▀███████
███▀▀░░░░░▄▄▄░░░░▀▀▀██
██░▀▀▄▄░░░▀▀▀░░░▄▄▀▀██
██░▄▄░░▀▀▄▄░▄▄▀▀░░░░██
██░▀▀░░░░░░█░░░░░██░██
██░░░▄▄░░░░█░██░░░░░██
██░░░▀▀░░░░█░░░░░░░░██
██░░░░░▄▄░░█░░░░░██░██
██▄░░░░▀▀░░█░██░░░░░██
█████▄▄░░░░█░░░░▄▄████
█████████▄▄█▄▄████████

▀████████████████████▀




Rainbot
Daily Quests
Faucet
MKH
Copper Member
Member
**
Offline Offline

Activity: 250
Merit: 13

FIRST SELF-SUSTAINING CRYPTO INFRASTRUCTURE


View Profile
March 25, 2018, 07:23:01 PM
 #7

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.

SCAVO  Technologies
SELF-SUSTAINING CRYPTO MINING FARM  BY USING RENEWABLE ENERGY RESOURCES - LIFETIME CONTRACT
────────  Whitepaper ⬝  Twitter ⬝  Telegram ⬝   Facebook ⬝  Ann Thread     ───────  Join our ICO:  July. 15- Oct. 31
Aleister Crowley
Hero Member
*****
Offline Offline

Activity: 910
Merit: 500


View Profile
March 25, 2018, 07:49:08 PM
 #8

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

Activity: 48
Merit: 0


View Profile
March 25, 2018, 08:00:15 PM
 #9

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

Activity: 36
Merit: 0


View Profile WWW
April 11, 2018, 05:24:01 AM
 #10

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
allukaYara
Jr. Member
*
Offline Offline

Activity: 69
Merit: 1


View Profile
April 11, 2018, 10:11:38 AM
 #11

The video looked particularly informative but unfortunately some of us dont understand English. Any links to similar tutorials provided in English for non-Russian speakers. Thanks
planingkoala
Newbie
*
Offline Offline

Activity: 48
Merit: 0


View Profile
April 11, 2018, 09:07:49 PM
 #12

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

Activity: 36
Merit: 0


View Profile WWW
April 20, 2018, 06:38:54 AM
 #13

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

Activity: 36
Merit: 0


View Profile WWW
April 27, 2018, 02:29:54 AM
 #14

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

Activity: 36
Merit: 0


View Profile WWW
May 13, 2018, 03:55:26 AM
 #15

UPD 13 May 2018

Get stats about your Fund in Telegram, as often as you set the Timer.
aiviaa485
Newbie
*
Offline Offline

Activity: 179
Merit: 0


View Profile
June 01, 2018, 06:34:44 AM
 #16

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

Activity: 238
Merit: 0


View Profile
August 13, 2018, 03:25:59 AM
 #17

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

Activity: 36
Merit: 0


View Profile WWW
September 21, 2018, 02:21:43 PM
 #18

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

Activity: 868
Merit: 501


★Bitvest.io★ Play Plinko or Invest!


View Profile
September 21, 2018, 02:39:08 PM
 #19

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.



.
.BITVEST DICE.
HAS BEEN RELEASED!


▄████████████████████▄
██████████████████████
██████████▀▀██████████
█████████░░░░█████████
██████████▄▄██████████
███████▀▀████▀▀███████
██████░░░░██░░░░██████
███████▄▄████▄▄███████
████▀▀████▀▀████▀▀████
███░░░░██░░░░██░░░░███
████▄▄████▄▄████▄▄████
██████████████████████

▀████████████████████▀
▄████████████████████▄
██████████████████████
█████▀▀█▀▀▀▀▀▀██▀▀████
█████░░░░░░░░░░░░░████
█████░░░░░░░░░░░░▄████
█████░░▄███▄░░░░██████
█████▄▄███▀░░░░▄██████
█████████░░░░░░███████
████████░░░░░░░███████
███████░░░░░░░░███████
███████▄▄▄▄▄▄▄▄███████

██████████████████████
▀████████████████████▀
▄████████████████████▄
███████████████▀▀▀▀▀▀▀
███████████▀▀▄▄█░░░░░█
█████████▀░░█████░░░░█
███████▀░░░░░████▀░░░▀
██████░░░░░░░░▀▄▄█████
█████░▄░░░░░▄██████▀▀█
████░████▄░███████░░░░
███░█████░█████████░░█
███░░░▀█░██████████░░█
███░░░░░░████▀▀██▀░░░░
███░░░░░░███░░░░░░░░░░

██░▄▄▄▄░████▄▄██▄░░░░
████████████▀▀▀▀▀▀▀██
█████████████░█▀▀▀█░███
██████████▀▀░█▀░░░▀█░▀▀
███████▀░▄▄█░█░░░░░█░█▄
████▀░▄▄████░▀█░░░█▀░██
███░▄████▀▀░▄░▀█░█▀░▄░▀
█▀░███▀▀▀░░███░▀█▀░███░
▀░███▀░░░░░████▄░▄████░
░███▀░░░░░░░█████████░░
░███░░░░░░░░░███████░░░
███▀░██░░░░░░▀░▄▄▄░▀░░░
███░██████▄▄░▄█████▄░▄▄

██░████████░███████░█
▄████████████████████▄
████████▀▀░░░▀▀███████
███▀▀░░░░░▄▄▄░░░░▀▀▀██
██░▀▀▄▄░░░▀▀▀░░░▄▄▀▀██
██░▄▄░░▀▀▄▄░▄▄▀▀░░░░██
██░▀▀░░░░░░█░░░░░██░██
██░░░▄▄░░░░█░██░░░░░██
██░░░▀▀░░░░█░░░░░░░░██
██░░░░░▄▄░░█░░░░░██░██
██▄░░░░▀▀░░█░██░░░░░██
█████▄▄░░░░█░░░░▄▄████
█████████▄▄█▄▄████████

▀████████████████████▀




Rainbot
Daily Quests
Faucet
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!