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
3 months of premium subscription.
50$
Please choose you payment method
1 year of premium subscription.
150$
Please choose you payment method

Html code will be here

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
Get Source Code
Make a request - and we will get back to you as soon as possible.
Your E-mail