Investing in industry funds in Excel

I was inspired to write this article by a wonderful series of the respected @abak "Investment Theory for Beginners". As a candy, I give below a link to a plate that receives the current prices for European funds, their profitability and other parameters from the Internet. In addition, I would like to expand the original article a little from the point of view of a novice investor investing from home and devoid of goodies in the interior of Deutsche Bank.





Disclaimer: The author is never an expert in website scraping and investments. Everything that is described here was done for the soul and on the knee. The author does not promise anything to anyone, but only shares his own experience and thoughts on investments, in particular in industry funds. Another goal is to provide food for thought, and not provide a recipe for all diseases. Everything that is described here was obtained by the author through trial and error, and, as you know: "Cut off heads are rapidly growing wiser." Therefore, the main message of the article: Do not be afraid to experiment.






Why foundations

Although all the necessary information is available and free, everyone has to get to the bottom of the really working schemes that generate income. The foam that everyone sees every day on banners like: "Buy shares of such and such and sell such and such" have nothing to do with real life. In particular, advertising of funds sent by banks (“Invest in a super-ETF and gain as much as 4.5% per annum !!!”) had the opposite effect on the author and postponed investments in funds for three years. Before moving on to funds, I will focus on the cons of stocks and bonds.





Promotions:





  • It is difficult to establish the point of entry and exit from the position. All indicators seem to exist for this, but in practice they do not work.





  • ROE… (. finance.yahoo.com, Statistics Financials), , , , .





  • .





  • / : , , , . ?





  • , (, Wirecard!)





:









  • - , , ,





:





  • : , , , .





  • , , ( , ).





  • , ( , ). : Lehman Brothers.









. , , . , .





, , , , ariva.de. , , GitHub. , , : , - .





, Selenium , SeleniumBasic. . „Update“, () „ariva.de“.





:





. , , .





  • WKN ( „C“): „ “ (ISIN), . ISIN , finance.yahoo.com , , „“, . -. WKN- .





  • Favorites ( „D“): , - „Update only favorites“ , . , , .





  • ( „E“): . .





  • ( „F“): . , . .





  • Benchmark ( „G“): .





  • ( „H“): . , .





  • URL ( „I“): WKN.





  • ( „J“ - „N“): 3/6 , 1/3/5 . 85% , – 15% .





  • ( „O“): , ( ) .





  • : ( „P“), ( „Q“),   ( „R“): ( „S“).





  • , -. „Sorting“ A. „A59:A67“, ( B) , (TRUE) (FALSE).









: :





  • 3m/6m/1yr/3yrs/5yrs: . 3 .





  • () (3m/6m…) AB:AI.





  • „AJ“ . , , . , , . .





:





: , , ? 6 3 ( ) 6 (). , , . , : 0.2. , .  , , , 6 . „ “, . . . , , , !





– . , . , , .





, , :





  • : , , , , - . .





  • , , , . , , ( ).





. .





:





  • 3 . . – - , .





  • 3 , - .





  • , „finanzen.net“/“ariva.de“ „Fonds“/„ETFs“ „Fonds-Suche“ „ETF-Suche“ ( ETF), . .





:





  • , . , (, , , ) . , – . , .





  • : , , , / . , / , . :-)





  • , (: „green benefit Global Impact Fund“). , , , 10 .





  • : AirBerlin Sympatex, . Wirecard . .





  • ( , , ):





  • , . 10% , ( /, ), , .





  • 10% – .





, :





  • (): . 5%, .





  • StopLoss-: , . , . .





  • . , ( 2020) - , . . .





  • Put-. :





  • : , .





  • : , , .





  • , . , , : / .





: , . 7. , /.





: , , , .





21% . , . .





  • , …: , :





  • : W-8BEN , , ( )?





  • ?





  • , , . -.





  • ?





  • , 2014 . 10% (//). , .





  • , GameStop?





  • . . , GameStop , . Reddite - -.





All information contained in the article was obtained from open sources and is never secret. In addition, the tablet is more likely Schrödinger's cow - it is not known whether she is alive or already dead, you can only find out empirically by starting to invest.





Link to plate





Be healthy!





Live richly!












All Articles