dow-jones-by-president

For blog posts

• Some Dow Jones Industrial Average statistics, by United States President
• President Trump tweets about the stock market

Update Dow Jones statistics

1. Download Dow Jones data from https://stooq.com/q/d/?s=^dji
2. Copy it over dow-jones-industrial-average.csv
3. If necessary, update the list of presidents in presidents.csv
4. From PowerShell, run calculate-statistics.ps1
5. Copy the resulting HTML into the blog post

Update tweets

1. Download Trump tweet data from http://trumptwitterarchive.com/
2. Save it in trump-twitter-archive.json
3. If necessary, update trump-twitter-exceptions.csv
4. From PowerShell, run extract-tweets.ps1 which writes to tweets.csv
5. Run format-tweets.ps1
6. Copy the resulting HTML into the blog post