This is a python script that utilizes selenium automation framework.
With this script, I am able to load my target website that contains a list of personal investments and its details such as how many units I know, current book value, current market value etc. I utilize the script to access the website and automate all the task such as:
- create a database if it doesn't already exist,
- create required tables if they don't already exist,
- type username and password,
- click on the submit button to login,
- log into hotmail (Since the website uses Multi-factor Authentication (MFA) and it send a 6 digit code to my email (hotmail)),
- filter for unread email,
- filter all unread email based on a subject line,
- retrieve the body of the email,
- utilize beautifulsoup4 to parse the code from the body of the email
- insert the code into the field to complete MFA,
- extract a list of investments,
- extract details from investments such as the name, type, units, book value, market value etc and
- store the data into a SQLite database.
Technologies Used:
- Python
- Selenium
- BeautifulSoup4
- SQLite3