Fund Administration and Portfolio Tracking
Automation in Google Sheets

  • Portfolio tracking for cryptocurrencies, stocks, forex or any custom asset like real estate, precious metals, ETFs, etc.
  • Free real-time market rates for 5000+ crypto, 10 000+ stocks.
  • Auto-sync balances from wallets and exchanges.
  • Accounting for shares of investors by mutual units.
  • Easy performance/entry/redeem fees accounting.
  • Auto-recording of portfolio snapshots and performance.
  • Custom telegram notifications.
  • Custom public reports.
  • Portfolio rebalancing, assets valuation, and more...

Real-time market rates and portfolio balances

10+
Exchanges
Balances from Coinbase, Binance, Kraken, HitBTC, KuCoin, Bittrex, Poloniex, Bitfinex, Bitcoin and Ethereum wallets with all ERC20 tokens.
5 000+
Cryptocurrencies
New coins is adding automatically.
All market rates are convertible in any other crypto/fiat/custom asset.
10 000+
Stocks
New stocks is adding automatically.
All market rates have name mapping to avoid collisions with cryptocurrencies.
How it Works?
Add-On loads Google Apps Scripts for obtaining real-time market rates, balances from crypto wallets and exchanges, sending Telegram notifications, etc.

Add-On also provides the set of powerful templates and UI for Fund Administration, Portfolio Tracking and Investment Management automation.

All data in your Google Spreadsheet remains private and secured. API keys which are used to sync balances do not leave your spreadsheet and stored in the Google's PropertiesService. Add-on's source code was verified by Google and can be accessible by request here.
Free-hosted
Back-Office of your Investment Fund
Automated
All Fund's processes are as automated as possible: balances sync, portfolio tracking, entrance to the fund, redeem, transfer shares, fees taking, performance recording, reporting, etc.
Universal
Suitable for all Investment Assets. Add-on pulls prices and balances for cryptocurrencies, forex and stocks markets, but you are free to extend it for any other custom assets by manual entry.
Powerful
Use the flexibility and power of spreadsheets to extend and customize functionality. We provide professional templates, but you are free to build something yours around.
Private
No third party servers or databases except your Google account. Get full control over your data and maintain Investment Fund in your private Google Spreadsheet for free.
More than 30 Crypto Funds already use
the Spreadsheet•Fund Add-On
Alex Smirnov
CEO at Phenom
This add-on is truly amazing. It rapidly simplified the way we manage both of our funds - crypto and classic stock. All balances are automatically retrieved through APIs, rebalance sheet allows us to properly perform rebalancing without the hustle of complicated calculations. Another advantage is that you customize spreadsheet for your own needs, make reports and add any kind of assets, e.g. real estate.

Many thanks to the developers. This piece of software definitely worth its price
Alexey Popov
CEO & Fund Manager at Rubus Fund
Great tool for crypto fund for automation of many processes which we must do by hand regularly. I really like it. Thank you!
Dino Calha
Fund Manager at a private fund
I have recently signed up to use this software to manage my fund and I honestly couldn't be happier!! It is user friendly and the support I received from the developers was unmatched. Anytime I had a query they were there to answer my questions which really made my life easy. I definitely recommend this product to anyone who is looking for fund management software.

How to start?

Watch this 5 minute "Quick start" video
FAQ
Question:
How many Funds I can manage with the Add-On?
Answer:
Inifinite. To launch a new Fund - just create another spreadsheet on your Google Drive.

Also, you are free to run different strategies in multiplie separate spreadsheets and then combine all of them into one aggregated spreadsheet.
Question:
How I will get my balances from exchanges and wallets into my Spreadsheet?
Answer:
The add-on can auto sync your balances from Bitcoin & Ethereum wallets with ERC20 , Coinbase, Binance, Kraken, HitBTC, KuCoin, Bittrex, Poloniex and Bitfinex exchanges.

All you need to do is setup your API keys for particular exchange under settings and you are done. All API keys are stored in the Google's PropertiesService of the spreadsheet for which the add-on is activated.

Only owner of the spreadsheet have access to the API keys.
Question:
In what currencies calculations and accounting are made?
Answer:
You are free to set up any fiat/crypto/stocks currencies for accounting and the calculation of your fund's performance.

For example, USD as a base currency, BTC as a second currency and RUB as a third currency
Question:
How I can calculate the shares of my investors?
Answer:
By using mutual unit (share, token, call it what you want).

When an investor makes a deposit - fund issues new shares for him. When an investor makes a withdrawal - fund burns his shares. When one investor transfers his shares to another - fund makes a record about the transfer. The price of share reflects the performance of your Fund. The price is unaffected by deposits and withdrawals.

Add-on automates all calculations like "how many shares to issue" "how many shares to burn" including Entry and Redeem fees. Add-on makes all records on the "Issuance" tab automatically. Then these records are used for accounting of investor's shares
Our Partners