Diversset Investments. Stock selection. Portfolio construction.

Build an efficient investment portfolio using Excel!

19 min · 9. feb. 2023
episode Build an efficient investment portfolio using Excel! cover

Description

In this episode, I explain how to build a well-diversified investment portfolio [https://diversset.com] and minimize the portfolio's risk using one of the popular portfolio management models, the Markowitz model. I am explaining how to use Excel to build your first portfolio management model. You can also watch my video on Medium [https://medium.com/@Sanji_vals/how-to-construct-an-efficient-stock-portfolio-a917d6e47586], where I explain step-by-step how to build an efficient portfolio.

Comments

0

Be the first to comment

Sign up now and become a member of the Diversset Investments. Stock selection. Portfolio construction. community!

Get Started

1 month for 9 kr.

Then 99 kr. / month · Cancel anytime.

  • Podcasts kun på Podimo
  • 20 lydbogstimer pr. måned
  • Gratis podcasts

All episodes

6 episodes

episode Calculate stock target price with the DCF model. artwork

Calculate stock target price with the DCF model.

I explain the DCF model and give a basic idea of how the model works!  If you don't like manual calculations but want to know your selected stock's fair value (target price), you can use a great iOS application called Stock Target Price [https://apps.apple.com/us/app/stock-target-price/id1589969451]. Calculate stock target price, extract investment ideas and define the right time to trade stocks.   If you are interested in understanding the DCF model deeply and want to get the ready excel model for DCF, you can take my stock market crash course [https://www.udemy.com/course/financial-instruments-and-analysis/?referralCode=CFD1565180443B63D1F7] on Udemy, and I will share the valuable models.  Follow me on Instagram for stock investments [https://www.instagram.com/stock_market_investments_01/]-related content.

9. juni 202314 min
episode When to sell stocks. Pay attention to these things to define the right time to sell stocks. artwork

When to sell stocks. Pay attention to these things to define the right time to sell stocks.

In this episode, I talk about 8 of the most important things you should pay attention to define the right time to sell stocks!  If you are interested in an automated approach, you can try the great iOS application Stock Target Price [https://apps.apple.com/us/app/stock-target-price/id1589969451] to define the right time to trade stocks in the short term. The app uses the VWAP indicator and the trading activity.  To get valuable trade recommendations and define a fundamentally great time to buy stocks, you can use the interesting and simple iOS application Stocks 2 buy [https://apps.apple.com/us/app/stocks-2-buy/id6444135874]  If you want to learn fundamental analysis, find great stocks, and protect your investments using risk management and portfolio management models, you can take my 11-hour Udemy stock market crash course [https://www.udemy.com/course/financial-instruments-and-analysis/?referralCode=CFD1565180443B63D1F7] Follow me on Instagram for stock investments [https://www.instagram.com/stock_market_investments_01/]-related content.

9. maj 202310 min
episode When to buy stocks. Indications that can tell when you should buy stocks. artwork

When to buy stocks. Indications that can tell when you should buy stocks.

In this podcast I talk about very important indicators that can help you differentiate helthy investment conditions from poor investment conditions. And Invest at the right time.  If you are interested in learning about all financial instruments, how to analyse them, how to find valuable investments and protect your risks, you can take my Udemy stock market crash course [https://www.udemy.com/course/financial-instruments-and-analysis/?referralCode=CFD1565180443B63D1F7].  You can use these great iOS applicatons that will fasilitate your investment process by helping you find great investment ideas! Stock target price app [https://apps.apple.com/us/app/stock-target-price/id1589969451] - calculate stock fair value, define right time to trade stocks, extract investment ideas. Stocks 2 buy [https://apps.apple.com/us/app/stocks-2-buy/id6444135874] - get valuable trade recommendations based on three very important indicators, used by professional traders.  Diversset [https://diversset.com] - find great stocks tailored to your investment strategy and build an efficient investment portfolio.  Follow me on Instagram [https://www.instagram.com/stock_market_investments_01/], for more stock investments related content.

9. apr. 202310 min
episode How to evaluate your investment portfolio. How to calculate the maximum portfolio loss. How to forecast the portfolio income range artwork

How to evaluate your investment portfolio. How to calculate the maximum portfolio loss. How to forecast the portfolio income range

In this episode, I continue to talk about portfolio management. This time I focused on calculating the portfolio's maximum risk, forecasting the profits range, and evaluating your investment portfolio. If you want to find great stocks tailored to your risk appetite and build an efficient portfolio [https://diversset.com], visit the web page Diversset.  To learn about fundamental analysis, risk management, and portfolio management and get useful financial models, take my stock market crash course [https://www.udemy.com/course/financial-instruments-and-analysis/?referralCode=CFD1565180443B63D1F7] on Udemy.  If you want to read free Medium articles, visit the links below:  For calculating the maximum portfolio loss [https://medium.com/the-investors-handbook/how-much-money-can-you-lose-by-investing-in-stocks-bc79cfa8b3b6] For forecasting the portfolio income range [https://medium.com/insiderfinance/how-much-money-can-you-make-by-investing-in-financial-assets-19f8387c88d] For evaluating your investment portfolio [https://medium.com/insiderfinance/how-to-evaluate-your-investment-portfolios-performance-88bc0ab80186] Follow me on Instagram for stock investments [https://www.instagram.com/stock_market_investments_01/]-related content.

9. mar. 202318 min