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…




A publication dedicated to providing concise and practical coding solutions to various problems in finance.

Recommended from Medium

Food for Agile Thought #264

Simple MVVM To Improve coding


Common Python Coding Interview Questions: Part 7

Agile Methodology used in Software Engineering

New Test Automation Feature to Follow

The rise, death and rebirth of hard skills on project management

My experience with Flutter Web (Performance, Advantages, Disadvantages)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Bee Guan Teo

Bee Guan Teo

Data Scientist. Like problem solving with Python

More from Medium

How to use Python to Create Financial Chart in Excel

FRED API: Get US Economic Data using Python

How to get stock price data and draw charts like yahoo finance

Calculate Annualized Expected Stock Returns Using Python