Skip to content

Instantly share code, notes, and snippets.

@ader1990
Created January 30, 2020 12:28
Show Gist options
  • Save ader1990/7311143f84ffa73b9fa38e449ab06eb2 to your computer and use it in GitHub Desktop.
Save ader1990/7311143f84ffa73b9fa38e449ab06eb2 to your computer and use it in GitHub Desktop.
Main focus: insert in a database the information about NASDAQ listed companies.
Steps:
1. Create a program that downloads a file from the internet with the companies info: ftp://ftp.nasdaqtrader.com/symboldirectory/nasdaqlisted.txt
2. Create a program that reads line by line the file
3. Create a program that parses each line (split by the separator |)
4. Create a database table with the required fields
5. Insert the companies into the DB
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment