Using XLWings, BeautifulSoup, Python 3.9 and Microsoft Excel 365 VBA To Web Scrape Market Index Data

In this book, we will use Python to retrieve market index data and historical company earnings We will use Microsoft Excel 365 to report the market index and company earnings. We will use a Python library called Xlwings so Excel 365 can communicate with Python.

The target audience for this book is for people who are interested in getting Dow Jones Industrial Average, S&P 500, Nasdaq and historical company earnings data from the internet. People who read this book will need a good working knowledge of Microsoft Excel, Excel VBA and Python. This book will use the case study approach. This book will not explain Microsoft Excel or Python; instead, readers will study the spreadsheet or Python examples. Like experience Microsoft Excel or Python users, the reader will google any Microsoft Excel or Python concept that they need more clarification.