Stoxs

Scrapes market data from WSJ, exporting to .csv, graphing.

To-Do

Python Web Scraper

• Scrape closing table data from WSJ into Pandas dataframes
• Export closing table data into .csv files
• Expand for 4 markets (NASDAQ C, NASDAQ G, NYSE, AMEX)
• Scrape data directly into databases

MySQL Databases

• Create and structure MySQ databases (see Database)
• Import .csv into MySQL databases
• Deploy to AWS/cloud hosting service

Python Program

• Create main driver in Python
• Display table/query database
• Export .csv from databases
• Create graphs from dataframes

ReactJS Web App

• Create bare bone structure for React front-end
• Query MySQL
• Link back-end to front-end
• Display graphs/tables
• Improve UI

Analysis

• Run analysis on data