Google Sheets Add-On for |

Investment Fund Administration & Portfolio Tracking Automation in Google Spreadsheet:

  • Track portfolio of cryptocurrencies, stocks, forex or any other asset with calculating of Net Asset Value in real-time.
  • Auto-sync balances from wallets and exchanges.
  • Accounting for shares of investors by the mutual unit.
  • Automation of Entrance/Redeem/Transfer Fund's shares.
  • Recording of fund performance and portfolio snapshots.
  • Proper performance/entry/redeem fees accounting.
  • Telegram notifications.
  • Portfolio rebalancing, reporting, assets valuation, and more...
Free-hosted, Private & Powerful

Back-Office of your Fund

Fully Automated
All processes are as automated as possible: portfolio tracking, entrance to the fund, redeem, transfer shares, fees taking, performance recording, etc.
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 class of assets by manual entry.
Flexibility and Power of Spreadsheets
Feel free to modify and extend our templates and build yours around them.
Privacy and Control
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.

Pull real-time market rates and portfolio balances into
Google Spreadsheet in an easy way

10+
Wallets and Exchanges
Balances from Bitcoin & Ethereum wallets with ERC20 , Coinbase, Binance, Kraken, HitBTC, KuCoin, Bittrex, Poloniex, Bitfinex, and more.
4500+
Cryptocurrencies
Market rates convertible in any other crypto/fiat currency or stock. For greater reliability we calculate a median from 3 sources.
10 000+
Stocks
Market rates for stocks with name mapping to avoid collisions with cryptocurrencies.
How it Works?
Add-on loads the set of templated sheets and UI into your Google Spreadsheet and provides Google Apps Scripts for obtaining real-time market rates, balances from crypto wallets and exchanges, sending Telegram notifications, etc.

All that provides a powerful automation for Fund Administration, Fund Accounting, Portfolio Tracking and Investment Management.

All data in your Google Spreadsheet remains private and secured. API keys which are used to sync balances do not leave your spreadsheet and are stored in Google's PropertiesService. Add-on's source code was verified by Google and can be accessible by request here.
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.
FAQ
How many Funds I can manage with the Add-On?
Inifinite. To launch new Fund - just create another spreadsheet on your Google Drive.

Also, you are free to run different strategies in the separate spreadsheets and then combine them into a aggregated spreadsheet
How I will get real-time market rates into my Spreadsheet?
The add-on calls external API's with Google Apps Script to get market rates, processes this data and puts all coins and stocks rates on the special "tickers" sheet in your spreadsheet.

Add-on loads market rates from 3 different sources for greater reliability. All market rates are provided without delays.
What about new listed coins and stocks?
All new coins and stocks will be added automatically. You don't have to worry about that.
How I will get my balances from exchanges and wallets into my Spreadsheet?
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 users of the spreadsheet have access to API keys
Can I add my own assets? For example some kind of Real Estate property?
Yes you can! Actually you are free to add any assets you want, but you need to update the price of your asset manually. Add-on only provides real-time market rates only for cryptocurrency and stocks (for now).
In what currencies are calculations and accounting made?
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 I can calculate the shares of my investors?
By using mutual unit (share, token, call it what you want) and making records on the "Issuance" tab.

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
How does Add-on record performance and send Telegram notifications?
100% automatically by using Timers in Google Spreadsheet.

You are free to choose the time for making records and getting notifications. Add-on will continue to work after you have closed your spreadsheet.

For Telegram you need to set up API keys of your bot - it's easy

Where can I ask a question and get technical support?
Feel free to contact the developer at address spreadsheetfund@gmail.com
or Telegram: @acosmos about any questions.

I will provide any support if needed.

How to set up the Spreadsheet Fund?

Watch this 5 minute video tutorial
Our Partners