Excel Overview

Raw Excel Data

Sample Benchmark

Sample Compco

Result: Mass conversion of files in the folder to macro-enabled workbook. Loops through the folder and perform a series of analyses that (1) Benchmarks the company relative to its peers (2) Pulls Rev, EBITDA, and PE Next Twelve Month (NTM) estimates and earning multiples (3) Performs a relative company valuation on the target company using those metrics and the average percentile ranking of itself vs. its peers.

Implementation

Excel Flowchart

For more details, please check out the code here (opens in a new tab).

Sources

[XLWING]
https://www.geeksforgeeks.org/working-with-excel-files-in-python-using-xlwings/
https://docs.xlwings.org/en/stable/quickstart.html#macros-call-python-from-excel
http://www.et.byu.edu/~treedoug/_pages/teaching/ChEn263/Lectures/Lec23-XLWings_handout.pdf
https://www.dataquest.io/blog/python-excel-xlwings-tutorial/ 

[ASPOSE]
https://products.aspose.com/cells/python-net/conversion/xls-to-xlsm/

Selenium Overview