def update_sma_db(self): stocks = db_util.open_reader('sma') self.smaArray = [] for arr2 in stocks: newarr = [] symbol = arr2[0] sma = self._calc_200_day_sma(symbol) newarr.append(symbol) newarr.append(sma) newarr.extend(arr2[1:self.numSma]) self.smaArray.append(newarr) writer = db_util.open_writer('sma') writer.writerows(self.smaArray) stocks = db_util.open_reader('sma50') self.sma50Array = [] for arr2 in stocks: newarr50 = [] symbol = arr2[0] sma50 = self._calc_50_day_sma(symbol) newarr50.append(symbol) newarr50.append(sma50) newarr50.extend(arr2[1:self.numSma]) self.sma50Array.append(newarr50) writer = db_util.open_writer('sma50') writer.writerows(self.sma50Array)
def update_sma_db(self): stocks = db_util.open_reader('sma') self.smaArray = []; for arr2 in stocks: newarr = []; symbol = arr2[0] sma = self._calc_200_day_sma(symbol) newarr.append(symbol) newarr.append(sma) newarr.extend(arr2[1:self.numSma]) self.smaArray.append(newarr) writer = db_util.open_writer('sma'); writer.writerows(self.smaArray); stocks = db_util.open_reader('sma50') self.sma50Array = []; for arr2 in stocks: newarr50 = []; symbol = arr2[0] sma50 = self._calc_50_day_sma(symbol) newarr50.append(symbol) newarr50.append(sma50) newarr50.extend(arr2[1:self.numSma]) self.sma50Array.append(newarr50) writer = db_util.open_writer('sma50'); writer.writerows(self.sma50Array);
def _populate_sma_db(smalist): priceArray = []; for ix1 in smalist: [smaVal,priceVal] = _calc_historical_200_day_sma(ix1); smaArray.append(smaVal) priceArray.append(priceVal) writer = db_util.open_writer('sma'); writer.writerows(smaArray); writer = db_util.open_writer('price'); writer.writerows(priceArray);
def populate_sma_db(self, smalist): self.priceArray = [] for ix1 in smalist: [smaVal, priceVal] = self._calc_historical_200_day_sma(ix1) self.smaArray.append(smaVal) self.priceArray.append(priceVal) writer = db_util.open_writer('sma') writer.writerows(self.smaArray) writer = db_util.open_writer('price') writer.writerows(self.priceArray)
def populate_sma_db(self, smalist): self.priceArray = [] for ix1 in smalist: [smaVal, priceVal] = self._calc_historical_200_day_sma(ix1) self.smaArray.append(smaVal) self.priceArray.append(priceVal) writer = db_util.open_writer("sma") writer.writerows(self.smaArray) writer = db_util.open_writer("price") writer.writerows(self.priceArray)
def re_order_based_on_names(self): self._open_db() newPriceArray = [] newSmaArray = [] for ix1 in self.nameArray: newPriceArray.append(self._find_price_list(ix1[0])) newSmaArray.append(self._find_sma_list(ix1[0])) writer = db_util.open_writer('sma') writer.writerows(newSmaArray) writer = db_util.open_writer('price') writer.writerows(newPriceArray)
def _add_to_sma_db(smalist): for ix1 in smalist: if _find_price_list(symbol): else: [smaVal,priceVal] = _calc_historical_200_day_sma(ix1); smaArray.append(smaVal) priceArray.append(priceVal) writer = db_util.open_writer('sma'); writer.writerows(smaArray); writer = db_util.open_writer('price'); writer.writerows(priceArray);
def re_order_based_on_names(self): self._open_db(); newPriceArray = [] newSmaArray = [] for ix1 in self.nameArray: newPriceArray.append(self._find_price_list(ix1[0])) newSmaArray.append(self._find_sma_list(ix1[0])) writer = db_util.open_writer('sma'); writer.writerows(newSmaArray) writer = db_util.open_writer('price'); writer.writerows(newPriceArray)
def run_price_check(self, priceRow): symbol = priceRow[0] curPrice = float(priceRow[1]) for i in range(2, len(priceRow)): newPrice = float(priceRow[i]) if (((abs(curPrice - newPrice)) / newPrice) > 0.3): print "Found Break %s %s %s" % (symbol, curPrice, newPrice) curPrice = newPrice writer = db_util.open_writer('sma') writer.writerows(self.smaArray) writer = db_util.open_writer('price') writer.writerows(self.priceArray)
def run_price_check(self, priceRow): symbol = priceRow[0] curPrice = float(priceRow[1]) for i in range(2, len(priceRow)): newPrice = float(priceRow[i]) if ((abs(curPrice - newPrice)) / newPrice) > 0.3: print "Found Break %s %s %s" % (symbol, curPrice, newPrice) curPrice = newPrice writer = db_util.open_writer("sma") writer.writerows(self.smaArray) writer = db_util.open_writer("price") writer.writerows(self.priceArray)
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 run_fix_split_checks(self): self._open_db() newPriceArray = [] for ix1 in self.priceArray: newPriceArray.append(self.run_price_check(ix1)) writer = db_util.open_writer('price') writer.writerows(newPriceArray) self._update_sma_array_to_40_days()
def run_fix_split_checks(self): self._open_db(); newPriceArray = [] for ix1 in self.priceArray: newPriceArray.append(self.run_price_check(ix1)) writer = db_util.open_writer('price'); writer.writerows(newPriceArray); self._update_sma_array_to_40_days()
def run_fix_split_checks(self): self.update_and_open_db() newPriceArray = [] self._read_split_file() for ix1 in self.priceArray: newPriceArray.append(self.adj_row_price(ix1)) writer = db_util.open_writer('price'); writer.writerows(newPriceArray); self._update_sma_array_to_40_days()
def _update_sma50_array_to_40_days(self): self._open_db() self.sma50Array = []; for arr2 in self.priceArray: self.sma50Array.append(_gen_sma50_array_for_40_days(arr2)) writer = db_util.open_writer('sma50'); writer.writerows(self.sma50Array);
def run_fix_split_checks(self): self.update_and_open_db() newPriceArray = [] self._read_split_file() for ix1 in self.priceArray: newPriceArray.append(self.adj_row_price(ix1)) writer = db_util.open_writer('price') writer.writerows(newPriceArray) self._update_sma_array_to_40_days()
def _update_sma50_array_to_40_days(self): self._open_db() self.sma50Array = [] for arr2 in self.priceArray: self.sma50Array.append(_gen_sma50_array_for_40_days(arr2)) writer = db_util.open_writer('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 update_price_db(self): stocks = db_util.open_reader('price') self.priceArray = [] for arr2 in stocks: newarr = [] symbol = arr2[0] price = self._fetch_price(symbol) print symbol, price newarr.append(symbol) newarr.append(price) newarr.extend(arr2[1:240]) self.priceArray.append(newarr) writer = db_util.open_writer('price') writer.writerows(self.priceArray)
def update_price_db(): stocks = db_util.open_reader('price') priceArray = [] for arr2 in stocks: newarr = []; symbol = arr2[0] price = _fetch_price(symbol) newarr.append(symbol) newarr.append(price) for i in range(1,239): newarr.append(arr2[i]) priceArray.append(newarr) writer = db_util.open_writer('price'); writer.writerows(priceArray);
def update_sma_db(self): stocks = db_util.open_reader("sma") self.smaArray = [] for arr2 in stocks: newarr = [] symbol = arr2[0] sma = self._calc_200_day_sma(symbol) newarr.append(symbol) newarr.append(sma) newarr.extend(arr2[1 : self.numSma]) self.smaArray.append(newarr) writer = db_util.open_writer("sma") writer.writerows(self.smaArray)
def update_price_db(self): stocks = db_util.open_reader("price") self.priceArray = [] for arr2 in stocks: newarr = [] symbol = arr2[0] price = self._fetch_price(symbol) print symbol, price newarr.append(symbol) newarr.append(price) newarr.extend(arr2[1:240]) self.priceArray.append(newarr) writer = db_util.open_writer("price") writer.writerows(self.priceArray)
def update_price_db(): stocks = db_util.open_reader('price') priceArray = [] for arr2 in stocks: newarr = [] symbol = arr2[0] price = _fetch_price(symbol) newarr.append(symbol) newarr.append(price) for i in range(1, 239): newarr.append(arr2[i]) priceArray.append(newarr) writer = db_util.open_writer('price') writer.writerows(priceArray)
def _update_sma_array_to_40_days(self): self._open_db() self.smaArray = []; for arr2 in self.priceArray: retArray = []; retArray.append(arr2[0]) for i in range (1,self.numSma+1): sma = 0.0 for mm in range (i,i+200): sma += float(arr2[mm]); sma = sma / 200.0 retArray.append(sma) self.smaArray.append(retArray) writer = db_util.open_writer('sma'); writer.writerows(self.smaArray);
def _update_sma_array_to_40_days(self): self._open_db() self.smaArray = [] for arr2 in self.priceArray: retArray = [] retArray.append(arr2[0]) for i in range(1, self.numSma + 1): sma = 0.0 for mm in range(i, i + 200): sma += float(arr2[mm]) sma = sma / 200.0 retArray.append(sma) self.smaArray.append(retArray) writer = db_util.open_writer('sma') writer.writerows(self.smaArray)
def update_price_db(self): self.priceArray = [] updatedPriceArray = self._fetch_updated_prices(); stocks = db_util.open_reader('price') lIndex = 0; for arr2 in stocks: newarr = []; symbol = arr2[0] price = updatedPriceArray[lIndex]; #print symbol,price newarr.append(symbol) newarr.append(price) newarr.extend(arr2[1:240]) self.priceArray.append(newarr) lIndex = lIndex + 1; writer = db_util.open_writer('price'); writer.writerows(self.priceArray);
def update_price_db(self): self.priceArray = [] updatedPriceArray = self._fetch_updated_prices() stocks = db_util.open_reader('price') lIndex = 0 for arr2 in stocks: newarr = [] symbol = arr2[0] price = updatedPriceArray[lIndex] #print symbol,price newarr.append(symbol) newarr.append(price) newarr.extend(arr2[1:240]) self.priceArray.append(newarr) lIndex = lIndex + 1 writer = db_util.open_writer('price') writer.writerows(self.priceArray)
def update_sma_db(): stocks = db_util.open_reader('sma') writeArray = [] if len(priceArray) == 0: update_price_db() for arr2 in stocks: newarr = [] symbol = arr2[0] sma = _calc_200_day_sma(symbol) newarr.append(symbol) newarr.append(sma) for i in range(1, 29): newarr.append(arr2[i]) writeArray.append(newarr) writer = db_util.open_writer('sma') writer.writerows(writeArray)
def update_sma_db(): stocks = db_util.open_reader('sma') writeArray = []; if len(priceArray) == 0: update_price_db() for arr2 in stocks: newarr = []; symbol = arr2[0] sma = _calc_200_day_sma(symbol) newarr.append(symbol) newarr.append(sma) for i in range(1,29): newarr.append(arr2[i]) writeArray.append(newarr) writer = db_util.open_writer('sma'); writer.writerows(writeArray);
def _populate_price_db(): someArray = [] for ix1 in emalist: someArray.append(_fetch_historical_200_day_ema(ix1)) writer = db_util.open_writer('ema') writer.writerows(someArray)
def _populate_price_db(): someArray = []; for ix1 in emalist: someArray.append(_fetch_historical_200_day_ema(ix1)) writer = db_util.open_writer('ema'); writer.writerows(someArray);