def populate_name_db(self):
self.nameArray = []
for ix1 in self.smaArray:
symbol = ix1[0]
name = yahoostock.get_name(symbol)
self.nameArray.append([symbol,name])
writer = db_util.open_writer_fixed('names')
writer.writerows(self.nameArray)
def populate_name_db(self):
self.nameArray = []
for ix1 in self.smaArray:
symbol = ix1[0]
name = yahoostock.get_name(symbol)
self.nameArray.append([symbol, name])
writer = db_util.open_writer_fixed('names')
writer.writerows(self.nameArray)
def _add_to_sma_db(self, smalist):
for ix1 in smalist:
if self._find_price_list(ix1) == 0:
print "Adding ", ix1
[smaVal, priceVal] = self._calc_historical_200_day_sma(ix1)
name = yahoostock.get_name(ix1)
self.smaArray.append(smaVal)
self.priceArray.append(priceVal)
self.nameArray.append([ix1, name])
writer = db_util.open_writer("sma")
writer.writerows(self.smaArray)
writer = db_util.open_writer("price")
writer.writerows(self.priceArray)
writer = db_util.open_writer_fixed("names")
writer.writerows(self.nameArray)
def _add_to_sma_db(self, smalist):
for ix1 in smalist:
if self._find_price_list(ix1) == 0:
print 'Adding ', ix1
[smaVal, priceVal] = self._calc_historical_200_day_sma(ix1)
name = yahoostock.get_name(ix1)
self.smaArray.append(smaVal)
self.priceArray.append(priceVal)
self.nameArray.append([ix1, name])
writer = db_util.open_writer('sma')
writer.writerows(self.smaArray)
writer = db_util.open_writer('price')
writer.writerows(self.priceArray)
writer = db_util.open_writer_fixed('names')
writer.writerows(self.nameArray)
def _populate_all_dbs_for_symbols(self,symbolList):
sql_db_util.open_writer();
for ix1 in symbolList:
if self._find_price_list(ix1) == 0:
print 'Adding ',ix1
[smaVal,priceVal] = self._calc_historical_200_day_sma(ix1);
name = yahoostock.get_name(ix1)
self.smaArray.append(smaVal)
self.priceArray.append(priceVal)
self.nameArray.append([ix1,name])
sma50arr = self._gen_sma50_array_for_40_days(priceVal);
self.sma50Array.append(sma50arr);
sql_db_util.write_historical_prices('stock_sma',[smaVal]);
sql_db_util.write_historical_prices('stock_prices',[priceVal]);
sql_db_util.write_historical_prices('stock_sma50',[sma50arr]);
sql_db_util.write_names(self.nameArray);
def _add_to_sma_db(self,smalist):
for ix1 in smalist:
print ix1
if self._find_price_list(ix1) == 0:
print 'Adding ',ix1
[smaVal,priceVal] = self._calc_historical_200_day_sma(ix1);
name = yahoostock.get_name(ix1)
self.smaArray.append(smaVal)
self.priceArray.append(priceVal)
self.nameArray.append([ix1,name])
self.sma50Array.append(self._gen_sma50_array_for_40_days(priceVal))
writer = db_util.open_writer('sma');
writer.writerows(self.smaArray);
writer = db_util.open_writer('price');
writer.writerows(self.priceArray);
writer = db_util.open_writer_fixed('names')
writer.writerows(self.nameArray)
writer = db_util.open_writer_fixed('sma50')
writer.writerows(self.sma50Array)
def populate_name_db(self):
self.nameArray = []
for ix1 in self.smaArray:
symbol = ix1[0]
name = yahoostock.get_name(symbol)
self.nameArray.append([symbol,name])
