Repurposing our Excel Newton’s Method Spreadsheet to Solve for Stock Price Given Vol
Recently, we did a video where we repurposed our Newton's method code where we solved for the implied volatility and used it to calculate a stock price assuming we already knew the volatility. Someone requested that I do the same calculation with a spreadsheet. So this is a quick video demonstrating how to do the same calculation with a spreadsheet and also at the end I will briefly show how to use goal seek to solve the same problem.
Original Newton’s Method Video: https://youtu.be/Jpy3iCsijIU
Original Newton’s Method Spreadsheet Video: https://youtu.be/ljlqGWz1xDY
Original Stock Calculation Video: https://youtu.be/NF-XMP8RjJo
Github:https://github.com/kpmooney/numerical_methods_youtube/tree/master/root_finding/implied_volatility
Spreadsheet: https://github.com/kpmooney/numerical_methods_youtube/blob/master/root_finding/implied_volatility/find_stock.xlsx
Tip Jar: https://paypal.me/kpmooney
-
5:51
kpmooney
3 years agoRepurposing our IV code to solve for Stock Price.
4 -
30:13
kpmooney
3 years agoRevisiting the Implied Volatility Calculation: Possible Pitfalls of Newton’s Method (Part 1)
13 -
15:52
Dividendology
1 year agoUltimate Stock Valuation Spreadsheet Tutorial! (How to Value a Stock!)
14 -
1:51
syeduddin1786
1 year agoHow To Calculate Future Investment By Using Future Value Formula In Excel.
1 -
3:05
Excellery
3 months agoAdding Stocks into Excel
37 -
3:40
ExcelwithExcel
2 years agoHow to use FVSCHEDULE function in Microsoft Excel to find the future value of an given investment
8 -
12:10
Kaceli TechTraining
11 months agoHow to Use Excel for the Absolute Beginner
5 -
1:42
syeduddin1786
1 year agoUsing Sumproduct Formula in Excel.
12 -
9:06
Professor Capko
1 year agoHow to Easily Calculate a Bond Price in Excel
1 -
10:00
Learn Crypto!
2 years agoCapital Allocation Spreadsheet (w/Charts) for Ethereum Bear Market
4