How to use Python to Generate Stock Report from Excel

Photo by Markus Spiske on Unsplash

Xlwings is an especially useful Python library that enables us to directly control Excel via Python script. Through xlwings, we can make use of Python as a backend analytic engine and render the result in Excel. This can result in many interesting use cases in financial analysis.

In this article we are going to look at how xlwings can be used to generate a stock report…