Python in Audit - Testing Listed Investments

Description
Listed investments testing generally starts with selecting samples in a financial year and then checking online reliable website such as yahoo finance to confirm the investment closing prices at year-end. The expectation is client investment price will match with auditor tested price.

This is repetitive process require labour work, where all samples are checked against online price copy and paste into excel for documentation, taking the difference between auditor price and client price, and if there is a difference, is it more material etc.

The attached code aims to create a working paper for you, all you need is to provide client provided schedule that lists all investments, prices at year-end etc. and it will create a working paper including differences, and highlight if the difference is above materiality.

A detailed explanatory video is attached it is highly recommended to view this video to see how to use the template. If you don't have local python installation you can use jupyter notebook, you can use any cloud-based notebooks such as google Colab to copy and paste first in the notebook cell and then run.

Disclaimer:
The code is provided for educational purposes, the author will not accept any liabilities, express or implied for any loss or adverse consequences, financial or non-financial.