No video

Linear Programming: Investment with Excel Solver

  Рет қаралды 15,977

Tallys Yunes

Tallys Yunes

4 жыл бұрын

Enjoyed this content & want to support my channel? You can get the spreadsheet I build in the video or buy me a coffee! Links below:
Buy me a coffee: www.buymeacoff...
Buy complete spreadsheet: www.buymeacoff...
Buy me an item from my wishlist: www.buymeacoff...
Given a budget, a collection of investments, and a simplified measure of risk, how to split your money among the investments in order to maximize the return?

Пікірлер: 15
@williama.rivera9414
@williama.rivera9414 Жыл бұрын
Very informative and instructive video. One question; How the risks scores are determined? Thank you for teaching
@TallysYunes
@TallysYunes Жыл бұрын
The risk scores are just a way to estimate how risky an investment is. They are a simplified view of what's actually happening. In that sense, they could be calculated in any way that is plausible and acceptable to whoever is interested in solving the problem. For example: from a conversation with experts, from past volatility of the investments (though we all know past behavior isn't a good indicator of future behavior), from forecasts on the investments' performance, etc. In more complicated portfolio optimization models, this simple idea of a risk score is replaced by some measure of the variance of the returns of the portfolio, which turns the model into a non-linear model.
@williama.rivera9414
@williama.rivera9414 Жыл бұрын
@@TallysYunes Thank you so much for answer and explanation. I'm clear in how the linear program function.
@yohiachen6664
@yohiachen6664 2 жыл бұрын
With many thanks!
@CanerErden
@CanerErden 3 жыл бұрын
Thank you so much
@TallysYunes
@TallysYunes 3 жыл бұрын
You're welcome!
@guliaminjonova2709
@guliaminjonova2709 2 жыл бұрын
Thank you for the super useful videos! Could you please post the video of the mathematical model you discussed in your class?
@TallysYunes
@TallysYunes 2 жыл бұрын
In this video I already give you the complete mathematical model and just go over it briefly. In class, I build it from scratch. I'm planning on making another collection of videos in which I create all the models from scratch, but they're not available yet. This is on my to-do list for 2022.
@madeleinexu3375
@madeleinexu3375 2 жыл бұрын
Hi Dr. Yunes, Thank you so much for providing the informative lectures. Those are great resources to help me to learn the subject effectively and efficiently. For this lecture, I am not very family with the average rate per dollar. Could you please explain more about the constraint (b)? Thank you so much for your help in advance. Kindest regards, Mad
@TallysYunes
@TallysYunes 2 жыл бұрын
You're welcome. Glad to hear the video was helpful. Constraint (b) is just an example of how to implement a weighted average type of constraint. You weigh each investment by how risky it is and average them out. This is a very simplified measure of risk. In practice, people use more complicated (and non-linear) formulas for that. But since this is an early example in the course, I'm keeping it simple for now.
@madeleinexu3375
@madeleinexu3375 2 жыл бұрын
@@TallysYunes Dr.Yunes, Thank you so much for taking the time to reply. It’s very much appreciated. Thank you for offering informative explanation. I will definitely keep studying your lectures to learn more. Have a wonderful day, Kindest regards, Mad
@Tanujanshu
@Tanujanshu Жыл бұрын
Very well explained 👍👍👍
@TallysYunes
@TallysYunes Жыл бұрын
Thank you so much!
@NISRAMI
@NISRAMI 3 жыл бұрын
Are the problems stored some place?
@TallysYunes
@TallysYunes 3 жыл бұрын
I'm not sure what you mean.
Linear Programming: Employee Scheduling with Excel Solver
13:10
Tallys Yunes
Рет қаралды 152 М.
Бутылка Air Up обмани мозг вкусом
01:00
Костя Павлов
Рет қаралды 1,9 МЛН
Can This Bubble Save My Life? 😱
00:55
Topper Guild
Рет қаралды 51 МЛН
The Joker saves Harley Quinn from drowning!#joker  #shorts
00:34
Untitled Joker
Рет қаралды 58 МЛН
Excel Solver. Mixing problem: Fund Portfolio
12:53
Prof C
Рет қаралды 8 М.
Goal Programming: Soft Constraints with Excel Solver
35:26
Tallys Yunes
Рет қаралды 10 М.
LP formulation - Investment/Finance Problem
4:59
Joshua Emmanuel
Рет қаралды 43 М.
Introduction to Two-Stage Stochastic Optimization (Conceptual)
24:39
Integer Programming: Set Covering with Excel Solver
20:39
Tallys Yunes
Рет қаралды 12 М.