Skip to content
This is my snipit of code that I made for cs506 at UW-Madison
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Type Name Latest commit message Commit time
Failed to load latest commit information.

CS 506 Crypto Counter - CRON

This is a python program designed to gather economic and social data from various APIs for the Crypto Counter project found here.

What is this repository for?

I created this for CS 506 Software Engineering at UW - Madison as a way to help my team on the group project. We were a team of 6 guys which broke up into teams of 2. I was on the backend API team whose job it was to collect data and add it to the database. My partner, Kedi Cui, helped me do the research while I created and wrote the code. The live site can be found here.

How do I get set up?

  • This code will not work as a stand alone codebase and will need the addition of either the rest of the CryptoCounter code or changing the code to add your own databse.

  • Python version 3.6.x

  • PostgreSQL

    • You may encounter some initial problems with setting up the database for the first time, this may be because the default user can not be found.
    • Also, look at the CryptoCounter code to see how to set up the database.
  • Install the following libraries using pip install:

    •   $ pip install requests
        $ pip install apscheduler
        $ pip install TwitterAPI
        $ pip install pytrends
        $ pip install praw
        $ pip install tweepy
  • Add the following info to both and

    •   Twitter API info ->[10:13]
        database settings ->[5,60:67]
        newsapi keys - >[40], This is a string array of keys, add as many as you want.
        Reddit API ->[254:258]
        Facebook API access_token - >[312]		
  • Run cron my using:

    •   $ python
  • Cron can also take arguments when ran

    •   $ python -h
        long argument   short argument  definition
        --help             -h             Show this help message and exit
        --cron             -c             Enable cron mode
        --reset            -r             Truncate all tables that cron interacts with
        --test             -t             Start xUnit tests
        --history [days]   -p             Sets the number of days to go back in history
                                            Default: 184 days (6 months)
        --debug            -d             Debug mode of testing as we code                                    
  • When running cron for the first time, it may take over an hour or more to load in data. If it looks like the program is hanging, do not worry, this is just cron handling data. Twitter is also disabled for overall social and ICO social data on the backend, due to the time it takes to record the info. Instead it is recorded as a -1.

  • The default for cron is 184 days of historical prices. To speed up cron, set historical days to a smaller number like 3 for an example.

    •   $ python -p 3


  • Like mentioned before, Twitter has been disabled for general and ICOs due to time it took to count the tweets.
  • Facebook API stopped working due to a change on their end
  • Remember to update the code before using it.
  • You will need to add the tables in yourself if you are not using the CryptoCounter code
  • I have 13 tests but should have more, I ran out of time during the class to implement them.

Contribution guidelines

  • If you would like to make edits, please create a pull request or make an new issue.

Who do I talk to?

You can’t perform that action at this time.