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: 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 _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 _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)