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.
  • Accounting for shares of investors by mutual units.
  • Free real-time market rates for 5000+ crypto, 10 000+ stocks.
  • Auto-sync balances from wallets and exchanges.
  • 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 synchronization of balances

14+
Integrations
Sync balances from:
Binance, Bittrex, Bitfinex, Bitmex, Bybit, Kraken, HitBTC, KuCoin, Poloniex, FTX, OKEX, Coinbase, Bitcoin and Ethereum wallets with the ERC20 tokens.
5 000+
Cryptocurrencies
New coins is adding automatically.
Reliable median price from multiple sources.
25 000+
Stocks
New stocks is adding automatically.
Stocks & crypto have conventional name mapping to avoid collisions.
Powerful Back-Office for 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. You can track any custom asset by manual entry or automate price pulling by functions like GOOGLEFINANCE
Customizable
Use the flexibility and power of Google Spreadsheets. We provide professional templates, but you are free to build something yours around.
Private & free-hosted
No third party servers or databases except your Google account. Maintain Investment Fund in your private Google Spreadsheet for free.
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.
Reviews
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.
FAQ
Question:
How I can add my custom asset?
Answer:
All market rates (crypto/fiat/stocks) are updated and collected on the "tickers" sheet. Then you can retreive any price using custom function "ticker".

In order to extend it with you custom assets - add a new row on the "tickers" sheet with your custom symbol:name and it's price (in USD).
For example: MYHOUSE, 1000000. Note you need to update the price manually.
But if you add some ETFs, you can update using GOOGLEFINANCE, just put the formula in the cell and you are done.

The "tickers" function will take any symbol:name as first parameter and any symbol:name as second and do convertion for you. For example: "=ticker("MYHOUSE";"BTC")" will return the price of your house in Bitcoin.a
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
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

How to start?

Watch this 5 minute "Quick start" video
Our Partners