An introduction to financial markets

(Foundamental analysis - Portfolio theory and capital market theory with applications using excel)
What you'll learn:
selection of securities, constract an investment portfolio using market theories, optimazations,
value-at-risk,
combining investments,
evaluate stocks and portfolio

Requirements
only the will for knowledge and curiosity about markets

Description
If you chose this course, you did well! Financial markets are very interesting. Many mathematical tools existing which does the life of an analyst or an investor easier. Measures such as average, variance or standard deviation help us to select the appropriate securities and finally construct our investment mixture with the terms of portfolio and calculate the mean return and it's variance. We will calculate value-at-risk, which is the maximum potential loss which might have by the prices variation. Also, we will be able to create a combination of risk-free asset with our "dangerous" investments. All these will happen by nobel priced market theories with practical apply, such as portfolio theory, single index model and capital market theory. We will evaluate our stocks and our portfolio, but first we will optimize it. A fascinating journey of profit maximization will begin. Let's have an overview of what you will learn:

calculation of stock return

calculation of stock variance

construct portfolio with risky investments using portfolio theory

optimizations (same as excel solver)

construct portfolio with risky investments using single index model

calculation of value-at-risk (parametrics and analytical methods)

construct portfolio combining risk-free asset with "dangerous" investments using capital market theory

overvalue and undervalue securities using alpha value

overvalue or undervalue portfolio using alpha value

examine if the portfolio went better or worst than market

calculation of portfolio's utility

all the above using simple programming and equations such as average, var, sqrt, if, sumproduct etc

Who this course is for
Everyone who wants to learn about markets and data analysis can watch the course


https://rapidgator.net/file/c438554bee98ec30617fd5ea8876f746/QvYxsOOD__An_introdu.part1.rar.html
https://rapidgator.net/file/622a4d512f5f5433322699d083e2fe96/QvYxsOOD__An_introdu.part2.rar.html
https://rapidgator.net/file/fdda9387396dc2badc66e41863fee0c6/QvYxsOOD__An_introdu.part3.rar.html

or
https://uploadgig.com/file/download/78DCba4e03Ae477e/QvYxsOOD__An_introdu.part1.rar
https://uploadgig.com/file/download/82b677dd5E4439Ce/QvYxsOOD__An_introdu.part2.rar
https://uploadgig.com/file/download/9C8523D2443945Fa/QvYxsOOD__An_introdu.part3.rar