SpreadsheetFund

Amazing Fund Management in Google Spreadsheets

Features

  • Pull reliable real-time market rates
    Add-on provides real-time market rates for 8000+ 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 custom filters
    Setup API keys and Add-on will pull balances from the CEX exchanges into your Google Spreadsheet: Binance, Bittrex, Bitfinex, Bitmex, Bybit, Kraken, HitBTC, KuCoin, Poloniex, FTX, OKEX, Coinbase, Coinbase PRO, 3commas, MyFXBook

    Also DeFi positions and ERC20 tokens balances sync are supported for networks:
    Bitcoin, Ethereum, BSC, Avalanche, xDai, Polygon, Fantom, HECO, Optimism, OEC, Arbitrum, CELO, Moonriver, Cronos, Boba, Metis, BitTorrent, Aurora, Moonbeam balances

    DeFi protocols supported:
    https://docs.google.com/spreadsheets/d/1CMIxvPKUwW...

    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
    • "Hardle Rate" for performance fee
  • 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 automatically 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
Portfolio tracking
  • Real-time market rates for 5000+ cryptocurrencies
  • Accounting of investors
  • Entrance/Redeem/Transfer Fund's shares
Use Add-on
Premium 1 year
$179 (-20%)
  • All from free +
  • Market rates for stock market
  • Auto-sync balances from wallets and exchanges
  • Entry/redeem/performance fees
  • Recording of historical Fund's performance & portfolio snapshots
  • Reporting to public spreadsheet
  • Telegram notifications
  • Rebalancing tab

Subscribe
We process automatically only payments by cryptocurrencies. If you want to pay by fiat or you have any
other problems with your payment please contact us at email
spreadsheetfund@gmail.com
Get the "Source Code"
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
- Advanced Telegram bot
- Custom development

Cons:
- No automatic updates carried out by subscription, but still can be updated manually
You will get a lifetime access to the spreadsheet with the codebase