def data_tracker(self):
        
        try:
            self.coin_list
        except:            
            self.coin_list=[]

        self.average=sma.SimpleMovingAverage()
        self.average.set(len(self.coin_list), self.coin_list)
                
        try:
            self.coin_list, temp=zip(*csql.get_prices())
        except:
            print ("unable to process prices from SQL Database")
        
        

        if self.tick['ask']!=self.last:
            csql.update_prices(self.tick['ask'], datetime.datetime.fromtimestamp(int(self.tick['timestamp'])).strftime("%Y-%m-%d %H:%M:%S"))
    def faux_trader(self):
    #creating variables
        self.first_avg=sma.SimpleMovingAverage()
        self.second_avg=sma.SimpleMovingAverage()
        try:
            self.trade_coins, temp=zip(*csql.get_prices())
        except:
            pass

        self.first_avg.set(11, self.trade_coins)
        self.second_avg.set(25, self.trade_coins)

        try:
            self.cash, self.bitcoin
        except:
            self.cash, self.bitcoin=0.0, 0.0       

        
        self.cash, self.bitcoin=bsql.get_balance()
        asql.clean_sql_every_x_hours(48)