I don't know a whole lot about this topic, but I would imagine that you would have an easier time using Python and some machine learning or neural networks to do these kind of predictions because of all the libraries that are available, rather than trying to do it from scratch using Excel.