BankofAmerica-Web-Scraper

Selenium web scraper used to pull personal financial data from bankofamerica.com

About

This web scraper will pull account balances and all transactions from credit and checking accounts. This is meant to be used with a node.js server which will re-categorize and insert into a google sheet.

Installing

To install dependencies and do local development, run

pip install requirements.txt

Usage

To run the program with docker (preferred):

docker run -d -p 5000:5000 erickshaffer/boa-scraper:latest

Environment variables

This project is meant to be used with a docker-compose file located in the node.js server repository.

Account File

The account credentials are stored in a json file. If you would like to login even with the security v2 security, you can provide the security answers in the file. This is not required, but the program will not work if it encounters these questions while parsing. This file need to located in the directory /app/var/account

[{
  "name": "",
  "username": "",
  "password": "",
  "security_questions": {
    "What is the name of your first employer?": "",
    "What is the street you grew up on": "",
    "What is the name of your best friend": ""
  }
}]

How it works

This service first logs in, and then start to collect the account balances and overview from the my accounts page. Next, it will visit all checking and credit cards and start collecting the transaction info. This is the following information that the program collects:

merchant_name
category
date
description
amount

Only the transactions from the current month are collected. Currently, the savings scraper isn't implemented. For my use case I did not have many important transactions in savings. The amounts are still collected in the overview and displayed in the sheet. If you would like to implement savings, just create another entry in page.py and locators in locator.py. To learn more about the page object design pattern, look at the selenium docs

Development

Testing

There is a few tests located in the test directory. These will test basic login functionality, account summary recording, and a full functional test of the scraper. Please replace the empty strings with your account information to run these tests.

Here is an example run of a full functional test run:

python test/FullTests.py