06-17-2021, 06:13 PM
A google spreadsheet tracker for cryptocurrency & stocks with cool features such as
<table> <tr><td> <a href="https://www.reddit.com/r/CryptoCurrency/comments/o1dtgr/a_google_spreadsheet_tracker_for_cryptocurrency/"> <img src="https://external-preview.redd.it/hp7-_z2qztGppDveUsN0D8nAoPWMQYV054rNEGTUxJU.jpg?width=640&crop=smart&auto=webp&s=bd877435a82af88a586d30c8e64b0a3134c49470" alt="A google spreadsheet tracker for cryptocurrency & stocks with cool features such as newsfeed, screener and other tools!" title="A google spreadsheet tracker for cryptocurrency & stocks with cool features such as newsfeed, screener and other tools!" /> </a> </td><td> <!-- SC_OFF --><div class="md"><p>Dear all,</p> <p>I want to share with you a google spreadsheet tracker I made. To be honest I think this one really rocks and I am excited to share it with you. Best part of all is that I did all the work for you, so that it's easy for you to use!</p> <p>Here are is a picture of the dashboard</p> <p>​</p> <p><a href="https://preview.redd.it/l5est0ybno571.png?width=2284&format=png&auto=webp&s=a067d625a18376dc2126830f9c3a96432dba6502">https://preview.redd.it/l5est0ybno571.png?width=2284&format=png&auto=webp&s=a067d625a18376dc2126830f9c3a96432dba6502</a></p> <p><strong>Characteristics & strenghts of the investment tracker</strong></p> <ul> <li>Can track both stocks & crypto. Any crypto listed on coingecko. Any stocks which google finance can find.</li> <li>Allows subgroup analysis of your portfolio for stocks. You can create two categories, for example 'short-term investments' & 'long-term investments' and compare their performance with each other. You can also name them 'dividend' and 'growth' stocks. Be creative.</li> <li>Tracks not only your current holdings, but also precise information on your past holdings. So for how much did you sell your last stock? Howmuch loss or gain? This allows you to reflect on past decisions and learn from them.</li> <li>Provides you with great graphical representation of your different holdings, exchanges, sector/industry, cost basis and more.</li> <li>Has additional tools to help you form your future decisions. One is the "newsfeed". With this newsfeed you can stay up to date with the click of a button. It provides you with the top 20 stories of either yahoo finance or seeking alpha for any stock you own. Alternatively, you can check out general cryptocurrency news.</li> <li>Another tool added to tracker is a screener. It extract data from finviz. Can help you decide if a stock you have been eye balling is worth a further look.</li> </ul> <p><strong>Limitations of the investment tracker</strong></p> <ul> <li>Currently tracking more than 10 cryptocurrencies will signficantly slow down performance of the spreadsheet. This is because of limitations of importhtml/importxml functions. I am working on a solution for this.</li> <li>There are no adjustments for stock-split.</li> <li>Dividends are taken into account, but there is no 'dividend analysis'. For example, howmany dividends to you expect next month, etc.</li> <li>Return is calculated over 'one holding period'. This does not take into account cash flows. Better would be to use money-weighted-average return and compare this for example with a benchmark like NASDAQ or S&P500.</li> </ul> <p>Plan on improving all of these limitations in the future as well as work on other features such as a rebalancing tool. </p> <p><strong>Link to the tracker:</strong> <a href="https://docs.google.com/spreadsheets/d/1Dyk7s17cbSgooxJQOMclfpZOsQCGVlzuYdEVuJZRJfc/edit?usp=sharing">https://docs.google.com/spreadsheets/d/1Dyk7s17cbSgooxJQOMclfpZOsQCGVlzuYdEVuJZRJfc/edit?usp=sharing</a></p> <p>Would love to hear your thoughts! Did you like the tracker? Manage to set it up? Any issues? Other things you want to see?</p> <p>Build this especially for people who do both stocks & crypto!</p> </div><!-- SC_ON --> submitted by <a href="https://www.reddit.com/user/pashtun92"> /u/pashtun92 </a> <br/> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/o1dtgr/a_google_spreadsheet_tracker_for_cryptocurrency/">[link]</a></span> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/o1dtgr/a_google_spreadsheet_tracker_for_cryptocurrency/">[comments]</a></span> </td></tr></table>Kind Regards R
<table> <tr><td> <a href="https://www.reddit.com/r/CryptoCurrency/comments/o1dtgr/a_google_spreadsheet_tracker_for_cryptocurrency/"> <img src="https://external-preview.redd.it/hp7-_z2qztGppDveUsN0D8nAoPWMQYV054rNEGTUxJU.jpg?width=640&crop=smart&auto=webp&s=bd877435a82af88a586d30c8e64b0a3134c49470" alt="A google spreadsheet tracker for cryptocurrency & stocks with cool features such as newsfeed, screener and other tools!" title="A google spreadsheet tracker for cryptocurrency & stocks with cool features such as newsfeed, screener and other tools!" /> </a> </td><td> <!-- SC_OFF --><div class="md"><p>Dear all,</p> <p>I want to share with you a google spreadsheet tracker I made. To be honest I think this one really rocks and I am excited to share it with you. Best part of all is that I did all the work for you, so that it's easy for you to use!</p> <p>Here are is a picture of the dashboard</p> <p>​</p> <p><a href="https://preview.redd.it/l5est0ybno571.png?width=2284&format=png&auto=webp&s=a067d625a18376dc2126830f9c3a96432dba6502">https://preview.redd.it/l5est0ybno571.png?width=2284&format=png&auto=webp&s=a067d625a18376dc2126830f9c3a96432dba6502</a></p> <p><strong>Characteristics & strenghts of the investment tracker</strong></p> <ul> <li>Can track both stocks & crypto. Any crypto listed on coingecko. Any stocks which google finance can find.</li> <li>Allows subgroup analysis of your portfolio for stocks. You can create two categories, for example 'short-term investments' & 'long-term investments' and compare their performance with each other. You can also name them 'dividend' and 'growth' stocks. Be creative.</li> <li>Tracks not only your current holdings, but also precise information on your past holdings. So for how much did you sell your last stock? Howmuch loss or gain? This allows you to reflect on past decisions and learn from them.</li> <li>Provides you with great graphical representation of your different holdings, exchanges, sector/industry, cost basis and more.</li> <li>Has additional tools to help you form your future decisions. One is the "newsfeed". With this newsfeed you can stay up to date with the click of a button. It provides you with the top 20 stories of either yahoo finance or seeking alpha for any stock you own. Alternatively, you can check out general cryptocurrency news.</li> <li>Another tool added to tracker is a screener. It extract data from finviz. Can help you decide if a stock you have been eye balling is worth a further look.</li> </ul> <p><strong>Limitations of the investment tracker</strong></p> <ul> <li>Currently tracking more than 10 cryptocurrencies will signficantly slow down performance of the spreadsheet. This is because of limitations of importhtml/importxml functions. I am working on a solution for this.</li> <li>There are no adjustments for stock-split.</li> <li>Dividends are taken into account, but there is no 'dividend analysis'. For example, howmany dividends to you expect next month, etc.</li> <li>Return is calculated over 'one holding period'. This does not take into account cash flows. Better would be to use money-weighted-average return and compare this for example with a benchmark like NASDAQ or S&P500.</li> </ul> <p>Plan on improving all of these limitations in the future as well as work on other features such as a rebalancing tool. </p> <p><strong>Link to the tracker:</strong> <a href="https://docs.google.com/spreadsheets/d/1Dyk7s17cbSgooxJQOMclfpZOsQCGVlzuYdEVuJZRJfc/edit?usp=sharing">https://docs.google.com/spreadsheets/d/1Dyk7s17cbSgooxJQOMclfpZOsQCGVlzuYdEVuJZRJfc/edit?usp=sharing</a></p> <p>Would love to hear your thoughts! Did you like the tracker? Manage to set it up? Any issues? Other things you want to see?</p> <p>Build this especially for people who do both stocks & crypto!</p> </div><!-- SC_ON --> submitted by <a href="https://www.reddit.com/user/pashtun92"> /u/pashtun92 </a> <br/> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/o1dtgr/a_google_spreadsheet_tracker_for_cryptocurrency/">[link]</a></span> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/o1dtgr/a_google_spreadsheet_tracker_for_cryptocurrency/">[comments]</a></span> </td></tr></table>Kind Regards R