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 -
31:10
Microsoft Excel Full Course
3 years agoExcel 365 Part 7 – Printing A Spreadsheet
102 -
9:59
Passive Dividends & Options Investing
3 years agoGOOGLE FINANCE API - HOW TO MAKE A STOCK MARKET SPREADSHEET
208 -
3:18
ChartAction
3 years agoWestern Digital Corporation Stock Price Today Triple Bottom
33 -
3:41
ChartAction
3 years agoNokia Hype Stock Price Technical Analysis Crazy MOVES!
36 -
30:13
kpmooney
3 years agoRevisiting the Implied Volatility Calculation: Possible Pitfalls of Newton’s Method (Part 1)
13 -
2:43
ChartAction
3 years agoHUYA Stock Price Today Bearish Divergence On the RSI
18 -
5:42
ChartAction
3 years agoFalling wedge American Airlines Stock Price Technical Analysis AAL
25 -
18:22
kpmooney
3 years agoRevisiting the Implied Volatility Calculation: Possible Pitfalls of Newton’s Method (Part 2)
44 -
3:14
ChartAction
3 years agoMicrosoft MSFT Stock Technical Analysis With Price Target 254
60