title: IT solution for Portfolio Construction using Value Investing and Modern Portfolio Theory principles
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¼Ð°Ð³Ð¸ÑÑÑÐ°
titleType: Subtitle
Creators: name: ÐÐ°ÑÑÑÑ ÐÐ±Ð°Ð½ÑÐµÑ, Ð­ÑÐ¸Ðº
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2023
Subjects: ÑÑÐ¾Ð¸Ð¼Ð¾ÑÑÐ½Ð¾Ðµ Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ
ÑÐ¾Ð²ÑÐµÐ¼ÐµÐ½Ð½Ð°Ñ ÑÐµÐ¾ÑÐ¸Ñ Ð¿Ð¾ÑÑÑÐµÐ»Ñ
ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ðµ Ð¿Ð¾ÑÑÑÐµÐ»Ñ
Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ
value investing
modern portfolio theory
portfolio creation
data visualization

description: Ð¦ÐµÐ»ÑÑ Ð´Ð¸Ð¿Ð»Ð¾Ð¼Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÐÐ¢-ÑÐµÑÐµÐ½Ð¸Ñ Ð´Ð»Ñ ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÑÑÐ²Ð° Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¸Ð¾Ð½Ð½Ð¾Ð³Ð¾ Ð¿ÑÐµÐ´Ð¿ÑÐ¸ÑÑÐ¸Ñ Ð¿Ð¾ÑÑÑÐ¾Ð»Ð¸Ð¾. ÐÐ°Ð½Ð½ÑÐµ Ð±ÑÐ´ÑÑ ÑÐ¾Ð±Ð¸ÑÐ°ÑÑÑÑ Ð¸Ð· ÑÐ°Ð·Ð½ÑÑ Ð¸ÑÑÐ¾ÑÐ½Ð¸ÐºÐ¾Ð² Ð¸ Ð¾Ð±ÑÐ°Ð±Ð°ÑÑÐ²Ð°ÑÑÑÑ Ñ Ð¿Ð¾Ð¼Ð¾ÑÑÑ ÐÐ¾Ð½Ð²ÐµÐ¹ÐµÑ Ð´Ð°Ð½Ð½ÑÑ ETL. ÐÑÐ¸Ð½ÑÐ¸Ð¿Ñ ÑÑÐ¾Ð¸Ð¼Ð¾ÑÑÐ½Ð¾Ð³Ð¾ Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¸ ÑÐ¾Ð²ÑÐµÐ¼ÐµÐ½Ð½Ð¾Ð¹ Ð¿Ð¾ÑÑÑÐµÐ»ÑÐ½Ð¾Ð¹ ÑÐµÐ¾ÑÐ¸Ð¸ Ð±ÑÐ´ÑÑ Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÐµÐ½Ð¾ Ð² Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ð¸ ETL, ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð¾Ð¼ Ð½Ð° Python. Ð ÐµÐ·ÑÐ»ÑÑÐ°ÑÑ Ð±ÑÐ´ÑÑ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ñ Ð´Ð»Ñ Ð°Ð½Ð°Ð»Ð¸Ð· Ð´Ð°Ð½Ð½ÑÑ Ð¸ Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ñ Ð¿Ð¾Ð¼Ð¾ÑÑÑ Ð¿Ð»Ð°ÑÑÐ¾ÑÐ¼Ñ Ð±Ð¸Ð·Ð½ÐµÑ-Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÐºÐ¸. ÐÑÐ½Ð¾Ð²Ð½Ð°Ñ ÑÐµÐ»Ñ Ð¿ÑÐ¾ÐµÐºÑÐ° â ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ðµ ÑÐ´Ð¾Ð±Ð½Ð¾Ð¹ Ð¸ Ð¼Ð°ÑÑÑÐ°Ð±Ð¸ÑÑÐµÐ¼Ð¾Ð¹ Ð¿Ð»Ð°ÑÑÐ¾ÑÐ¼Ñ Ð´Ð»Ñ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¸Ð¾Ð½Ð½Ð¾Ð³Ð¾ Ð¿Ð¾ÑÑÑÐµÐ»Ñ Ð¸ Ð´Ð¾ÐºÐ°Ð·Ð°ÑÑ Ð¿ÑÐ¸Ð±ÑÐ»ÑÐ½Ð¾ÑÑÑ ÑÐ¾Ð½Ð´Ð¾Ð²ÑÑ ÑÑÐ½ÐºÐ¾Ð² Ð² Ð´Ð»Ð¸ÑÐµÐ»ÑÐ½ÑÐ¹ Ð¿ÑÐ¾Ð±ÐµÐ³. ÐÐµÐºÐ¾ÑÐ¾ÑÑÐµ ÑÐ°ÑÑÐµÑÑ Ð¾ÑÐ½Ð¾ÑÐ¸ÑÐµÐ»ÑÐ½Ð¾ Ð¸ÑÑÐ¾ÑÐ¸ÑÐµÑÐºÐ¾Ð¹ Ð´Ð¾ÑÐ¾Ð´Ð½Ð¾ÑÑÐ¸ Ð°Ð¼ÐµÑÐ¸ÐºÐ°Ð½ÑÐºÐ¸Ñ ÑÐ¾Ð½Ð´Ð¾Ð²ÑÑ ÑÑÐ½ÐºÐ¾Ð² Ð±ÑÐ»Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½ÑÐ¹ Ð¢ÑÑÐ½Ð¾Ð¼ [1] Ð¸ ÐÐµÐ±ÑÑÐµÑÐ¾Ð¼ [2]. Ð ÐµÐ·ÑÐ»ÑÑÐ°ÑÑ Ð±ÑÐ»Ð¸ Ð¿ÑÐ¾ÑÑÐ¾ Ð²ÑÐ´Ð°ÑÑÐ¸Ð¼Ð¸ÑÑ. ÐÑÐ»Ð¸ ÐÑÐ»Ð¸ Ð±Ñ Ð² 1957 Ð³Ð¾Ð´Ñ 100 Ð´Ð¾Ð»Ð»Ð°ÑÐ¾Ð² Ð±ÑÐ»Ð¾ Ð²Ð»Ð¾Ð¶ÐµÐ½Ð¾ Ð² Ð¸Ð½Ð´ÐµÐºÑ S&amp;P 500, Ð¾Ð½ ÑÑÐ°Ð» Ð±Ñ $584 066,64 Ðº Ð´ÐµÐºÐ°Ð±ÑÑ 2022 Ð³Ð¾Ð´Ð°. Ð¡ÑÐµÐ´Ð½ÑÑ Ð´Ð¾ÑÐ¾Ð´Ð½Ð¾ÑÑÑ Ð¸Ð½Ð´ÐµÐºÑÐ° S&amp;P 500. Ñ 2012 Ð¿Ð¾ 2021 Ð³Ð¾Ð´ (20 Ð»ÐµÑ) ÑÐ¾ÑÑÐ°Ð²Ð¸Ð» 9,51%. Ð¡Ð°Ð¼Ð°Ñ Ð²ÑÑÐ¾ÐºÐ°Ñ Ð¾Ð¶Ð¸Ð´Ð°ÐµÐ¼Ð°Ñ Ð´Ð¾ÑÐ¾Ð´Ð½Ð¾ÑÑÑ Ð¿Ð¾ÑÑÑÐ¾Ð»Ð¸Ð¾, ÑÐ¾Ð·Ð´Ð°Ð½Ð½Ð¾Ðµ Ñ Ð¿Ð¾Ð¼Ð¾ÑÑÑ Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Python, ÑÐ¾ÑÑÐ°Ð²Ð¸Ð»Ð¾ 16,03%. Ð¥Ð¾ÑÑ Ð´Ð¾ÑÐ¾Ð´Ð½Ð¾ÑÑÑ Ð²ÑÐ±ÑÐ°Ð½Ð½ÑÑ Ð¿Ð¾ÑÑÑÐµÐ»ÐµÐ¹ Ð¿ÑÐµÐ²ÑÑÐ°ÐµÑ ÑÑÐ°Ð»Ð¾Ð½Ð½ÑÐ¹ ÑÑÐ¾Ð²ÐµÐ½Ñ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸, Ð²ÑÐµ ÐµÑÐµ Ð¼Ð¾Ð¶Ð½Ð¾ Ð¿Ð¾Ð»ÑÑÐ¸ÑÑ Ð´Ð¾Ð¿Ð¾Ð»Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÑ Ð¿ÑÐ¸Ð±ÑÐ»Ñ, Ð¿ÑÐ¸Ð¼ÐµÐ½ÑÑ Ð°ÐºÑÐ¸Ð²Ð½ÑÐ¹ Ð¿Ð¾ÑÑÑÐµÐ»Ñ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ðµ. Ð¢ÐµÐ¼ Ð½Ðµ Ð¼ÐµÐ½ÐµÐµ, ÑÐ°ÐºÐ¶Ðµ Ð²Ð°Ð¶Ð½Ð¾ Ð¿Ð¾Ð´ÑÐµÑÐºÐ½ÑÑÑ, ÑÑÐ¾ Ð¿ÑÐµÐ´ÑÐ´ÑÑÐ¸Ðµ Ð¾ÑÑÐµÑÑ Ð½Ðµ Ð³Ð°ÑÐ°Ð½ÑÐ¸ÑÑÐµÑ ÑÐµÑ Ð¶Ðµ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð² Ð² Ð±ÑÐ´ÑÑÐµÐ¼.
description: The thesis aims to develop an IT solution for the construction of an investment portfolio. The data will be collected from different sources and processed through and ETL data pipeline. Value Investing and Modern Portfolio Theory principles will be introduced in the ETL application developed in Python. The results will be used for data analytics and data visualization with the help of a business intelligence platform. The main purpose of the project is to create a user-friendly and scalable platform for investment portfolio creation, and to prove the profitability of stock markets in the long run. Some calculation about historic returns in American stock markets were developed by Thune [1] and Webster [2]. The results were simply outstanding. If $100 would have been invested in the S&amp;P 500 index in 1957, it would become $584,066.64 by December 2022. The average rate of return of the S&amp;P 500 index between 2012 and 2021 (20 years) was 9.51%. The highest expected return of the portfolios created by the Python application was 16.03%. Although the returns of the selected portfolios exceed the benchmarkâs performance, it is still possible to gain some extra return by applying active portfolio management. Nevertheless, it is also important to highlight that previous returns do not guarantee the same results in the future.