Asks for company name, autocompletes ticker
Writes report of all annual EPS and dividend payouts since 1989
Takes 36 minutes to run on all 2019 Fortune 500 companies
Can run 12 tests total

I. I. = An abbreviation for the Intelligent Investor
Net Working Capital = Current Assets - Current Liabilities
Current Ratio = Current Assets / Current Liabilities
Shareholder Equity = Total assets - Total Liabilities
EPS = Earnings per Share (Graham always refers to diluted EPS rather than basic EPS)
P/E (Ratio) = Current Price / EPS of a certain number of years
P/B (Ratio) = Current Price / Most recently reported book value per share
TTM = Trailing Twelve Month (Average)

All of these tests come from either the original 1949 version or the revised 1972 version of the Intelligent Investor.

1. Diluted EPS increase by 1.33 in the past 10 years using three year averages at the beginning and end
2. Positive earnings over the past 10 years
3. Dividend record should be uninterrupted for 20 years

4. Shareholder Equity / Total Assets > 0.5 (I. I. 1949)
5. Long-term debt should be less than Net Working Capital (I. I. 1972)
6. (For industrial firms) Current ratio should be greater than 2.
7. (For public utilities) Long term debt should not exceed 2x the Shareholder Equity (I. I. 1972)

8. Trailing Twelve Month Average P/E < 20 (I. I. 1972 Chapter 5)
9. 7 year P/E < 25 (I. I. 1972 Chapter 5)
   
10. Price should not be more than 15 times the average earnings of the past 3 years (I. I. 1972 Chapter 14)
11. Price to book ratio should be no more than 1.5 (Intelligent Investor 1972 Chapter 14)
12. A low PE ratio (below 15) can justify a high P/B so, PE ratio x PB ratio should be less than or equal to 22.5 (The text from which the Graham Number was deduced) (I. I. 1972 Chapter 14)

os
pandas
scrapy
datetime
importlib
crochet
time

run through each f500 company and write ordered output (use linked list) make ordered output, with highest number of tests passed at the top, and lowest at the bottom. only run certain test 'categories' on certain list using settings file (yaml config file + configparser)
allow selection of fortune 500 list year
allow importing of lists to run on
save output using python rename
solve ticker lookup problems
   Looking up Jabil gives you AAPL as the ticker for some reason, make it confirm that the text found corresponds with the company
   Other known ticker errors are: oshkosh (not at top), Cintas (not at top), intuit(not at top), zoetis(not at top)
Make GUI

Make it only run ticker spider init once
write reports in html or csv to allow for line breaks and overall pretty formatting.
scrape the fortune500 website to get most up to date f500 lists independently, and compile into csv
create schema_df to explain each criterion
move everything from grahamBot project dir to top level grahamBot package

I will be using macrotrends for historical data since 2005, and marketwatch for ticker lookup
ycharts seems to have data from earlier but I need an account.
guru focus also has 30 year financials but you need an account