Calculating the Probability of a Stock Reaching a Given Price in a Specified Time Window in Excel

In a previous video, I showed how to calculate the probability a stock will touch a given value in a specified amount of time. We did this in Python using Monte Carlo techniques. A viewer asked if I could show how to do the same type of calculation in Excel. While Excel isn’t the ideal tool for this, it can be done, and I’ll show how it can be done.

Original Video: https://youtu.be/PRLnusDWSW0

Github: https://github.com/kpmooney/numerical_methods_youtube/tree/master/probability_of_a_touch

Tip Jar: https://paypal.me/kpmooney