Video není dostupné.
Omlouváme se.
Monte Carlo Simulation Option Values in Excel
Komentáře • 3
Další v pořadí
Automatické přehrávání
Monte Carlo Simulation of Option Value in Google SheetsRonald Moy, Ph.D., CFA, CFP
zhlédnutí 1,5K
Monte Carlo Simulation Retirement WithdrawalsRonald Moy, Ph.D., CFA, CFP
zhlédnutí 11K
Monte Carlo Simulation of Stock Price MovementOption Trader
zhlédnutí 94K
PRIME ZA 10KČ?!Štěps
zhlédnutí 196K
CO TVOJE TĚLO NEDOKÁŽE UDĚLAT (ALE MĚLO BY TO UMĚT) 😅🤣Stejk
zhlédnutí 284K
FIZI DRINK VS. COCA COLA? Co je zdravější? #shorts #marcel #cocacola #fizistyleMARCEL
zhlédnutí 177K
Wavy or Curly? #hairstyle #hairtok #hairhack #hairtutorial #hair #easyhairstyle #beautifulcurlsAlina Shmidt
zhlédnutí 24M
Quantitative Project Risk Analysis in Excel Lesson 04iziRisk in English
zhlédnutí 6K
Introduction to Monte Carlo Simulation in Excel 2016Maggie Winslow
zhlédnutí 339K
How to Simulate Stock Price Changes with Excel (Monte Carlo)Matt Macarty
zhlédnutí 225K
Monte Carlo Method: Value at Risk (VaR) In ExcelRyan O'Connell, CFA, FRM
zhlédnutí 46K
Option Pricing - Binomial Model using Excel and VBAFinRow Academy
zhlédnutí 2,2K
Two Dice Monte Carlo Simulation in ExcelFinally Learn
zhlédnutí 8K
Monte Carlo Simulation in Excel - Retirement SavingsRonald Moy, Ph.D., CFA, CFP
zhlédnutí 38K
Using Monte Carlo simulations for valuationFinancial Analysis with Dr Jeff
zhlédnutí 16K
FIZI DRINK VS. COCA COLA? Co je zdravější? #shorts #marcel #cocacola #fizistyleMARCEL
zhlédnutí 177K
Getting her riled up for no reason 🤣Hunna & Lib
zhlédnutí 29M
Ženu pronásleduje vrah #horrorshorts #shorthorrorstory #shorthorrorstoriesPrézovy noční můry
zhlédnutí 219K
I CAN'T BELIEVE THIS HAPPENED!!!Zhong
zhlédnutí 38M
DRAMA MR.BEASTAVidrail
zhlédnutí 250K
STEP CHALLENGE🦶Celine & Michiel
zhlédnutí 7M
Cool barbie shoes! #shoes #makeover #diy #upcycling #handmadeLa La Laugh! Shorts
zhlédnutí 5M
Koupím Barče Cokoliv Co Trefí Šipkou!DodoCZ
zhlédnutí 134K
Superb video! Thanks a lot!
I'm still struggling with the fact that the expected return on the stock is 3.24% (implying a stock value of $51.62 at expiry) and the option values predicted by the model converge to $3.20 and $1.60. These option values do not make sense. I think it may be because the model is using stock RETURNS to predict option PRICES. Returns are normally distributed while prices are not. Think of the bell curve; for returns it is symmetrical as the values can be positive or negative. But prices cannot be negative, their lower bound is zero. So, when the options are valued by taking the average of all their predicted prices, the result is overstated because the model is not properly accounting for negative returns. I think this is a flaw in the model because, intuitively, the option values just do not make any sense. How can a call and a put with $50 strikes be valued at $3.20 and $1.60 respectively when the expected value of the stock at expiration is $51.6 (3.24% return)? How does one interpret such option prices given the model's inputs?
Excellent video. Thank you for the detailed example. I replicated your example and the values i got for the call and the put options at expiration seemed to converge on 3.2 and 1.6 respectively. But an average stock return of 3.24% would imply a stock value of 51.62 at expiration and therefore a call value of 1.62 and a put value of 0 - on average. What don't I understand? Also, how do we interpret the call and put values generated by Monte Carlo? Are these the "expected values" for the options given the stock average return and standard deviation? Thanks.