Google Spreadsheets

How To Count Duplicates in Google Spreadsheets (COUNTIF)

| 15 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 Spreadsheets. Everything good here, except I decided to count how many trades there have been, how many are open, how many are closed, how many are winning, how many are losing and based on that make a simple calculation to figure out what is my winning rate…


Google Spreadsheet To Track BTC/Altcoin Trading on Monthly Basis

| 16 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 Investment In Crypto Currencies - Bought 0.2 ETH for EUR 50 For support please visit the Terramatris website: Custom Google Spreadsheet Development for Crypto Currency Portfolio Tracking Soon I decided to use dollar cost averaging to acquire four different…


How To Track Your CryptoCurrencies Portfolio Automatically Using Google Spreadsheets

| 51 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 cost averaging and decided to build a separate Google Spreadsheet to track value changes, gains, or losses. For support please visit the Terramatris website: Custom Google Spreadsheet Development for Crypto Currency Portfolio Tracking I see investments in…


Simple Google Spreadsheet to Track Stock Portfolio Changes Using GOOGLEFINANCE

| 98 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, and of course total gain values using Google Spreadsheets and GOOGLEFINANCE function. For support with this Spreadsheet please visit the Terramatris website: Custom Google Spreadsheet Development for Crypto Currency Portfolio Tracking Currently, I hold 9…


How to check Google rankings with Google Spreadsheets

| 1 views

<p>In this article I will show, how you can check and track your SERP with Google Spreadsheets.</p><p>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 Open data)</p><p>So basically I built a kinda Mash-up - web site, that aggregates different information related to tourism objects in Georgia…