Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Investment Portfolio Optimization with Excel & R

Understand and Operationalize Markowitz´s Portfolio Theory with Excel´s Solver Add-in & R´s fPortfolio Package
4.5
4.5/5
(31 reviews)
10,690 students
Created by Carlos Martínez, PhD

9.2

CourseMarks Score®

10.0

Freshness

8.0

Feedback

9.1

Content

Platform: Udemy
Price: $11.99
Video: 2h 59m
Language: English
Next start: On Demand

Top Value Investing courses:

Detailed Analysis

CourseMarks Score®

9.2 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

10.0 / 10
This course was last updated on 3/2021.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

8.0 / 10
We analyzed factors such as the rating (4.5/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.1 / 10
Video Score: 8.0 / 10
The course includes 2h 59m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
Detail Score: 9.7 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
8 resources.
0 exercise.
0 test.

Table of contents

Description

Would you like to be able to optimize asset portfolios, using market data to maximize the expected return per unit of risk? That´s precisely what you will learn in this course “Investment Portfolio Optimization in Excel and R.” My name is Carlos Martínez, I have a Ph.D. in Management from the University of St. Gallen in Switzerland. I have presented my research at some of the most prestigious academic conferences and doctoral colloquiums at the University of Tel Aviv, Politecnico di Milano, University of Halmstad, and MIT. Furthermore, I have co-authored more than 25 teaching cases, some of them included in the case bases of Harvard and Michigan.
This is a very comprehensive course that includes presentations, tutorials, and assignments. The course has a practical approach based on the learning-by-doing method in which we will build an optimal portfolio from the real prices of 20 companies. In addition to the videos, you will have access to all the Excel files and R codes that we will develop in the videos and to the solutions of the eight assignments included in the course with which you will self-evaluate and gain confidence in your new skills.
After a brief introduction to the theoretical framework, we will illustrate all the concepts of the theory with a portfolio of two assets, with which we will elaborate the efficient frontier, and estimate the optimal portfolio and the capital market line. Then, we will extrapolate these learnings to a portfolio of 20 assets, and estimate the weights of a portfolio that maximizes the expected return per unit of risk. Once we know portfolio theory in-depth, we will have earned the right to use R´s fPortafolio package, with which we will be able to automate all the vector algebra procedures using R´s computational power.
The ideal students of this course are university students and professionals in numerical areas interested in pursuing a career as financial analysts or investing in risk assets. The course includes an introduction to vector algebra so the only requirement for the course is a basic knowledge of spreadsheets and R.
I hope you are ready to upgrade yourself and learn to optimize investment portfolios with excel and R. I´ll see you in class!

Requirements

• The course includes an introduction to vector algebra so the only requirement for the course is a basic knowledge of spreadsheets and R.

You will learn

✓ Optimize for the highest Sharpe ratio in a real data portfolio using Excel´s Solver Add-in and R´s fPortfolio package
✓ Undestand and Operationalize Markowitz´s Portfolio Theory
✓ Calculate Variance and Sharpe ratio for a twenty-asset portfolio
✓ Compute Covariance and Correlation of two assets
✓ Calculate Value at Risk (VaR) of a Portfolio
✓ Learn basic Vector Algebra (Matrix Multiplication)

This course is for

• The ideal students of this course are university students and professionals in numerical areas interested in pursuing a career as financial analysts or investing in risk assets.

How much does the Investment Portfolio Optimization with Excel & R course cost? Is it worth it?

The course costs $11.99. And currently there is a 87% discount on the original price of the course, which was $94.99. So you save $83 if you enroll the course now.

Does the Investment Portfolio Optimization with Excel & R course have a money back guarantee or refund policy?

YES, Investment Portfolio Optimization with Excel & R has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Investment Portfolio Optimization with Excel & R course, but there is a $83 discount from the original price ($94.99). So the current price is just $11.99.

Who is the instructor? Is Carlos Martínez, PhD a SCAM or a TRUSTED instructor?

Carlos Martínez, PhD has created 15 courses that got 220 reviews which are generally positive. Carlos Martínez, PhD has taught 21,004 students and received a 4.6 average review out of 220 reviews. Depending on the information available, Carlos Martínez, PhD is a TRUSTED instructor.

More info about the instructor, Carlos Martínez, PhD

Ph.D. in Management | MBA | MsC. in Finance | Industrial Eng
(English profile below)Carlos es un apasionado del método de casos de enseñanza, coautor de más de 25 de ellos en las áreas de finanzas, estrategia, operaciones y desarrollo sostenible. Algunos de estos han sido incluidos en las bases de casos de prestigiosas escuelas de negocio como Harvard, Michigan e IESE.Es Ingeniero Industrial y Master en Finanzas de la Universidad Centroamericana, MBA con distinción de INCAE Business School y Ph.D. en Management de la Universidad de San Galo, Suiza. Ha orientado su investigación hacia el impacto de la información social, ambiental, y de gobierno corporativo (ESG) en los mercados financieros. También ha desarrollado estudios relacionados con el acceso al financiamiento emprendedor en contextos con vacíos institucionales.Su investigación ha sido presentada en prestigiosas conferencias como el coloquio doctoral del Alliance for Research on Corporate Sustainability (MIT, EEUU), la conferencia especializada “From start-up to scale-up” del Academy of Management (University of Tel-Aviv, Israel), la tercera conferencia en Entrepreneurial Finance (Politecnico de Milano, Italia) y el Congreso Anual del European Accounting Association (Valencia, España).Carlos es coautor de cinco artículos en revistas científicas arbitradas (peer-reviewed) y dos capítulos en libros de editoriales de prestigio (Edward Elgar y World Scientific Publishing). Su investigación ha sido citada por el International Integrated Reporting Council en documentos dirigidos a inversionistas institucionales. Adicionalmente, ha sido revisor ocasional de artículos científicos para varias revistas arbitradas.*****Carlos is passionate about the teaching case method and has co-authored more than 25 of them in the areas of finance, strategy, operations, and sustainable development. Some of these have been included in the case bases of prestigious Universities such as Harvard and Michigan.He is an Industrial Engineer and Master in Finance from Central American University. He also has an MBA with honors from INCAE Business School, and a Ph.D. in Management from the University of St. Gallen, Switzerland. Carlos has oriented his research towards the impact of social, environmental, and corporate governance (ESG) information on financial markets. He has also developed studies related to access to entrepreneurial financing in contexts with institutional voids.His research has been presented at relevant conferences such as the doctoral colloquium of the Alliance for Research on Corporate Sustainability (MIT, USA), the specialized conference “From Start-up to Scale-up” of the Academy of Management (University of Tel-Aviv, Israel ), the third conference on Entrepreneurial Finance (Politecnico de Milano, Italy) and the Annual Congress of the European Accounting Association (Valencia, Spain).Carlos has co-authored five articles in peer-reviewed journals and two chapters in books from prestigious publishers (Edward Elgar and World Scientific Publishing). His research has been cited by the International Integrated Reporting Council in documents aimed at institutional investors. Additionally, he has been an occasional reviewer of scientific articles for several peer-reviewed journals.

9.2

CourseMarks Score®

10.0

Freshness

8.0

Feedback

9.1

Content

Platform: Udemy
Price: $11.99
Video: 2h 59m
Language: English
Next start: On Demand

Students are also interested in

Other courses by ​Carlos Martínez, PhD

Get this widget on your website (for course creators):

Investment Portfolio Optimization with Excel & R rating
Copy this code and paste it to your website:
<a href="https://coursemarks.com/course/investment-portfolio-optimization-with-excel-r/" target="_blank" title="Investment Portfolio Optimization with Excel & R on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/92.svg" width="200px" alt="Investment Portfolio Optimization with Excel & R rating"/></a>