SpreadsheetFund

Investment Fund Back-Office in one Google Spreadsheet
Features
Pull reliable real-time market rates
Add-on provides real-time market rates for 4500+ cryptocurrencies and 10000+ stocks. You can convert any crypto/fiat/stock to any other crypto/fiat/stock with a simple function.

All rates are pulled from multiple sources. For greater reliability we calculate the median price. We do the mapping of names and symbols to avoid conflicts and collisions.
Auto-sync balances from crypto exchanges and wallets with "Dust filter"
Setup API keys and Add-on will pull balances from the exchanges into your Google Spreadsheet: Binance, KuCoin, Bittrex, Kraken, Bitfinex, Coinbase, Poloniex and HitBTC.

Also you can sync Bitcoin, Ethereum and all ERC20 tokens from cold wallets.

More integrations are coming. Leave a request
Powerful portfolio tracking
Special "Portfolio" templated sheet is used to collect all your balances together in one place and to represent all portfolio values in currencies you want.

You can see a portfolio structure, portfolio values and prices in three customizable currencies, prices of mutual units, 24h changes, and other statistics
Accounting for investor's shares and profits
Automatization of Entrance/Redeem/Transfer Fund's shares with customizable fees. "Issuance" templated sheet is used to keep track and account of all operations:

  • Initialization of Fund (first mutual units or "shares" issuance)
  • Mint new units when an investor buys a stake in a Fund
  • Burn units when an investor sells a stake
  • Entry and Redeem fees calculations
  • Transfer of shares from one investor to another
  • Proper Performance Fees taking
Recording fund's performance
"Performance" and "PortfolioHistory" sheets are used to record fund's performance once a day at a preferable time. Just set up a timer in the settings menu.

Add-on will write snapshots of your portfolio, total supply and price of fund's units and other statistics. This data can be used for reporting and audit.
Reporting & auditability
Keep two separate spreadsheets: private and public

Add-on will copy a custom data from the private to the public spreadsheet once a day at a preferable time. Just select which sheets you want to copy and you are done.
Telegram notifications
Get messages into your Telegram chat, channel or group about:

  • Portfolio statistics by timer
  • Notification about Issuance/Redeem/Transfer of shares
  • Notification about Performance Fee taking
  • Notification about Public reports
  • And others
Rebalancing & scoring
"Rebalancing" template which helps make all rebalancing calculations + valuation model on the "tickers" sheet and already assessed blockchain assets
Free vs Premium features
Free
Forever
$0
Portfolio tracking
  • Real-time market rates for 4500+ cryptocurrencies
  • Market rates update only twice a day
  • Accounting for shares of investors
  • Entrance/Redeem/Transfer Fund's shares
  • No fees automation
Use Add-on
Premium
3 months
$50
  • All from free +
  • Market rates for 10000+ stocks
  • Market rates update unlimited
  • Auto-sync balances from wallets and exchanges
  • Entry/redeem/performance fees
  • Recording of historical fund performance & portfolio snapshots
  • Automatic Reporting
  • Telegram notifications
  • Rebalancing & asset valuation model
Buy
Premium
1 year
$150 (-25%)
  • All from free +
  • Market rates for 10000+ stocks
  • Market rates update unlimited
  • Auto-sync balances from wallets and exchanges
  • Entry/redeem/performance fees
  • Recording of historical fund performance & portfolio snapshots
  • Automatic Reporting
  • Telegram notifications
  • Rebalancing & asset valuation model
Buy
We accept only cryptocurrencies through this page. If you want to pay by fiat or you have any
other problems with your payment please contact us at email
spreadsheetfund@gmail.com

Html code will be here

Get the "Source Code" Version
You can get the copy with full source code to build something you want

Pros:
- Full control of Add-on
- Lifetime premium functionality
- Unlimited timers
- Custom development

Cons:
- No updates carried out by subscription
We will send you access to the spreadsheet with the source-code. You will make your own private copy
Get Source Code
Make a request - and we will get back to you as soon as possible.
Your E-mail