def get_all_companies_volume(self):
result = self.db.query("select symbol, Volume from company_info;")
if result:
l = []
for i in range(len(result)):
c = Active_company()
c.set_symbol(result[i]['symbol'])
c.set_volume(result[i]['Volume'])
l.append(c)
return l
def get_all_companies_averagedailyvolume(
self
): #NOT TO SELF: fix the averagedailyvolume and avg_daily_volume difference
result = self.db.query(
"select symbol, AverageDailyVolume from company_info;")
if result:
l = []
for i in range(len(result)):
c = Active_company()
c.set_symbol(result[i]['symbol'])
c.set_avg_daily_volume(result[i]['AverageDailyVolume'])
l.append(c)
return l
def get_all_companies_percentchange(self):
result = self.db.query(
"select symbol, PercentChange from company_info WHERE PercentChange IS NOT NULL AND PercentChange!='None';"
)
if result:
l = []
for i in range(len(result)):
c = Active_company()
c.set_symbol(result[i]['symbol'])
#r = result[i]['PercentChange'].translate(None, '+%')
#c.set_percent_change(r)
c.set_percent_change(
result[i]['PercentChange']) #.translate(None, '+%'))
#c.set_volume(result[i]['Volume'])
#c.set_avg_daily_volume(result[i]['AverageDailyVolume'])
l.append(c)
return l
