Skip to main content

Posts

Showing posts from April, 2021

Compare stock portfolio to compound interest saving account

In investing, it is important to define the target that we want to achieve. Many investors like to compare their portfolios with a market index, but is outperforming the market index a good target? It is not a quantitative target to be measurable as market indexes fluctuate daily. I, personally, aim only for 10% growth a year. If at the end of the year, I see my portfolio grows 10%, I am pleased with that result no matter that S&P500 grows 50% the same year. To see if my stock portfolio grows in line with the 10% target, I choose to compare it to a saving account with the same interest. In this post, I will show you how to use a fictive saving account with daily compound interest as the target to benchmark a stock portfolio. Idea Computation Visualization Evolution of target saving account with 5% annual compound interest Evolution of target saving account with 10% annual compound interest Evolution of target saving account with 15% annual compound interest Conclusion

Demo stock portfolio tracker with Google Sheets and Google Data Studio

I am happy to announce the release of LION stock portfolio tracker. It is a personal stock portfolio tracker built with Google Sheets and Google Data Studio. The stock portfolio's transactions are managed in Google Sheets and its performance is monitored interactively on a beautiful dashboard in Google Data Studio. You can try with the demo below and follow the LION stock portfolio tracker guide to create your own personal stock portfolio tracker with Google Sheets and Google Data Studio. Demo dashboard Demo spreadsheet Guide Disclaimer Demo dashboard Demo spreadsheet Guide LION Stock Portfolio Tracker - Guide Disclaimer The post and the LION stock portfolio tracker are only for informational purposes and not for trading purposes or financial advice. It is your responsibility to use the LION stock portfolio tracker for managing your investment. I shall not be liable for any damages relating to your use of the LION stock portfolio tracker.