Quote from: el kaka22 on April 21, 2017, 08:54:33 PM

How a google sheet will get update when my portfolio get changed ? DO I need to enter every time I make a change with my portfolio ?
I guess your coverage on wide range of exchanges seems good but are you using any api to get auto update functionality into spread sheet ?

If you take time to explain more on the purpose and real time application of your sheet will be good to understand the use of your hard work.

Quote from: offliberty on April 21, 2017, 08:30:45 AM

I strongly recommend what sonder (or @acosmos on Telegram) did.

This will save me a lot of time.

Vouches from newbie never counts. Better luck next time.

There are fields that needs to be entered manually: SYMBOL, avg. buy price and amount (but if you store all your wealth (not recommended) on Poloniex - there is a synchronisation using polo API. Yes you need to enable API key in your settings. Make sure that you forbid trades and withdrawals through API key.
Anyway you need to trust Google services because you will store your API key on their cloud servers.

=ticker(asset,main) - function to get coin price. Returns a ticker price. The price is average value aggregated from 52 exchanges using special API
=specific_price(asset,main,exchange) - can get a ticker from specific exchange using specific API
=cmc(asset,option) - return data for one of 700+ coins from coinmarketcap. Available data: d,name,symbol,rank,price_usd,price_btc,24h_volume_usd,market_cap_usd,available_supply,total_supply,percent_change_1h,percent_change_24h,percent_change_7d,last_updated
=get_balance_data() - return a stringified json with all your balances from poloniex
=balance(data,asset) - parse the cell with stringified json and return specific balance