Google Spreadsheets

How To Count Duplicates in Google Spreadsheets (COUNTIF)

1 November, 2019 | 10,475 views

I've been using Google Spreadsheets literally for everything that can be counted or measured (dividend income, stock trades, body weight and so on).  And so did when I decided to build an option trading journal I built it using Google…


Google Spreadsheet To Track BTC/Altcoin Trading on Monthly Basis

28 September, 2017 | 9,979 views

Track your altcoin/BTC investment portfolio with Google Spreadsheets Investments in crypto-currencies are among one of the most interesting findings for me this year (2017). I decided to give them a try just a few months ago, see: First…


How To Track Your CryptoCurrencies Portfolio Automatically Using Google Spreadsheets

7 July, 2017 | 72,860 views

It was just recently I made my first investment in cryptocurrencies, I spent EUR 50 to acquire about 0.2 Ethereum. As I bought them for a long term (buy and hold) and actually I'm planning to acquire more coins every month using dollar…


Simple Google Spreadsheet to Track Stock Portfolio Changes Using GOOGLEFINANCE

2 July, 2017 | 43,632 views

There is a super simple and easy way to track your stock portfolio with real-time price, cost basis, market value, value gain, even individual stock weight in the portfolio, net yield on cost and current net yield from dividend payouts,…


How to check Google rankings with Google Spreadsheets

13 June, 2014 | 7,596 views

In this article I will show, how you can check and track your SERP with Google Spreadsheets.But at first I will tell you a story - More than 3 years ago I started to work on a hobby (but large scale site) dedicated to Georgia. It was built…