Python for Audit Testing (Valuation)

Description
Test of Details of Investment Valuations at year end by using Python script to save time, effort and improve audit quality.

Testing list of stock's prices at year-end is a time-consuming exercise and could be frustrating if there are internet and website issues. In this tool by amending few details, and by pressing just one click you could have hundreds of stocks’ year-end prices in a minute. This could not only save your time but at the firm level, it could have significant time savings. Yahoo Finance is one of the most used website auditors used to check year-end prices.

The end result is that you will have all stocks prices in excel!

In this tool, we are using Yahoo Finance API to obtain year-end values of stocks. Yahoo Finance API is not stable, and some time does not work so there are chances that the template will not work is there are changes in the API.

There are 2 videos would help you guide how to use this template:

1. https://youtu.be/mViZ5JkCrVc
2. https://youtu.be/3YMOyehlO9w

If you like it please share this with your other team members to also make their life easy in busy periods. I am also preparing for another tool that would help you to test dividend income.

Happy Auditing!

Thanks
Rizwan