Google Spreadsheets
How To Count Duplicates in Google Spreadsheets (COUNTIF)
November 01, 2019I'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 Spreadsheets. Everything good here, except I decided to count how many...
Google Spreadsheet To Track BTC/Altcoin Trading on Monthly Basis
September 28, 2017Investments in crypto-currencies are among one of the most interesting findings for me this year. I decided to give them a try just a few months ago, see: First Investment In Crypto Currencies - Bought 0.2 ETH for EUR 50 Affiliate link here: If you are just planning to acquire your first bitcoin, consider to...
How To Track Your CryptoCurrencies Portfolio Automatically Using Google Spreadsheets
July 07, 2017It was just recently I made my first investment in crypto currencies, 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 average cost dollar and decided to build a separate Google Spreadsheet to track...
Simple Google Spreadsheet to Track Stock Portfolio Changes Using GOOGLEFINANCE
July 02, 2017There 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 portfolio, net yield on cost and current net yield from dividend payouts and of course total gain values using Google Spreadsheets and GOOGLEFINANCE ...
How to check Google rankings with Google Spreadsheets
June 13, 2014In 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 with Drupal, involved Google maps, Feeds parsing (Flickr, Wikipedia and more...