Google Spreadsheet to manage and automate your Crypto Fund

in cryptocurrency •  7 years ago  (edited)

All functionality described bellow are available in the free Gsheet Addon:
http://spreadsheet.fund/

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;
• 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 and liqui
• Real-time exchange rates for 4500 + 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 "Performance 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;

Install here:
https://chrome.google.com/webstore/detail/spreadsheet-fund/pkjmaijhdpkmfogpmfaennidncpdgmbl

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!