I wrote my own fiat/crypto/precious metals tracker in PHP/mysql. I made it for my own purpose.
I preffer to write something once, and don't waste time later on to update rates in Excel, everytime.
When it was ready, I placed it on the server for everybody: https://assetbalance.info. You are welcome to use it.

I wrote  similar fiat/crypto/precious metals tracker in PHP/mysql. I made it for my own purpose.
When it was ready, I placed it on the server for everybody: https://assetbalance.info. You are welcome to use it.

Try assetbalance.info

try online assetbalance.info

I wrote my own fiat/crypto/precious metals tracker in PHP/mysql. I made it for my own purpose.
I preffer to write something once, and don't waste time later on to update rates in Excel, everytime.
When it was ready, I placed it on the server for everybody: https://assetbalance.info. You are welcome to use it.

To get live portfolio balance for many people you can do following:
1. Create a separate account for each person using online app that has relevant API.
2. Combine them in excel.
In excel choose insert->link to external data.

fro example assetbalance.info API response looks like this:

{"rate_update":"1508596922","crypto":3767.58673695916,"currency":7605.14,"precious_metals":1611.742383041976,"total":32984.46912000113,"base_symbol":"PLN","base_unit":"PLN","base_name":"Polish Zloty"}

therefore select "," and ":" to separate columns

I'd like to add to the list one more online tracker: assetbalance.info
Advantages:30 days history chart, mobile friendly, assets are not limited to crypto, public and private portfolio with api.
Disadvantages: No API to exchanges, no dynamic portfolio based on public addresses.