Cryptocurrency Excel Template For Mac

Oct 26, 2017 - Wyckoff method in cryptocurrency trading has been made popular among. To coinmarketcap, build your own altcoin tracking spreadsheet.

It was just recently I made my first investment in crypto currencies, I spent. 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 value changes, gains or loss. I see investments in crypto currencies as a great alternative to diversify my portfolio. Right now crypto currencies stand at about 0.8% in my portfolio and I'm looking to increase it to about 5% by the end of 2017.

The idea of the following spreadsheet was inspired from a regular stock tracking sheet, see: GOOGLEFINANCE Here is a catch, to get real-time updates in Google Spreadsheets you will have to use =IMPORTXML function to get real-time updates from some crypto currency exchange service. Luckily a Reddit user lawnchairwiz have provided us with solution, see: For those that use Google Sheets to track their ETH transactions, here's a quick way to get the price from coinmarketcap.com: Copy the URL cell A1.