def createHistogramOfJongmok(Jongmokhan) : ''' 종목의 종가를 histogram을 그린다. :param Jongmokhan: :return: ''' coll주식종목Data = pymongo.MongoClient('localhost', 27017).get_database("xadb").get_collection("주식종목Data") dictcondi = {'종목명':Jongmokhan } dictproj = { "주식차트_일주월.종가":1, "_id":0 } objret = coll주식종목Data.find_one(dictcondi, dictproj) listdictdatestrprice = objret["주식차트_일주월"] listprice = [] for dictdatestrprice in listdictdatestrprice : listprice.append(dictdatestrprice["종가"]) plotjongmok.plotHistogram([listprice ], [Jongmokhan]) # 전날 종가대비 가격 변동율의 histogram listdiffrate =[] priceprev = listprice[0] for price in listprice : listdiffrate.append((price- priceprev)/priceprev) priceprev = price plotjongmok.plotHistogram([listdiffrate ], ["price diff rate of " + Jongmokhan])
def createHistogramOfJongmok(Jongmokhan): ''' 종목의 종가를 histogram을 그린다. :param Jongmokhan: :return: ''' coll주식종목Data = pymongo.MongoClient( 'localhost', 27017).get_database("xadb").get_collection("주식종목Data") dictcondi = {'종목명': Jongmokhan} dictproj = {"주식차트_일주월.종가": 1, "_id": 0} objret = coll주식종목Data.find_one(dictcondi, dictproj) listdictdatestrprice = objret["주식차트_일주월"] listprice = [] for dictdatestrprice in listdictdatestrprice: listprice.append(dictdatestrprice["종가"]) plotjongmok.plotHistogram([listprice], [Jongmokhan]) # 전날 종가대비 가격 변동율의 histogram listdiffrate = [] priceprev = listprice[0] for price in listprice: listdiffrate.append((price - priceprev) / priceprev) priceprev = price plotjongmok.plotHistogram([listdiffrate], ["price diff rate of " + Jongmokhan])
def createHistorgramOfPERPBRByMarket(): ''' purpose : 코스피, 코스탁, 전체시장에 대해 PER, PBR의 histogram을 그린다. :return: ''' coll주식종목Data = pymongo.MongoClient( 'localhost', 27017).get_database("xadb").get_collection("주식종목Data") listKOSPIPER = [] listKOSPIPBR = [] # 코스피 종목구성. dictcondi = {'시장구분': "1"} dictproj = {"PER": 1, "PBR": 1, "_id": 0} objret = coll주식종목Data.find(dictcondi, dictproj) for obj in objret: per = obj["PER"] if per > -10 and per <= 100: listKOSPIPER.append(per) pbr = obj["PBR"] if pbr > -10 and pbr <= 40: listKOSPIPBR.append(pbr) listKOSDACPER = [] listKOSDACPBR = [] # 코스피 종목구성. dictcondi = {'시장구분': "2"} dictproj = {"PER": 1, "PBR": 1, "_id": 0} objret = coll주식종목Data.find(dictcondi, dictproj) for obj in objret: per = obj["PER"] if per > -10 and per <= 100: listKOSDACPER.append(per) pbr = obj["PBR"] if pbr > -10 and pbr <= 40: listKOSDACPBR.append(pbr) plotjongmok.plotHistogram([listKOSPIPBR, listKOSDACPBR], ["PBR_KOSPI", "PBR_KOSDAC"]) plotjongmok.plotHistogram([listKOSPIPER, listKOSDACPER], ["PER_KOSPI", "PER_KOSDAC"]) chi2, p = stats.chisquare(listKOSPIPER) print('chisquare output') print('Z-score = ' + str(chi2)) print('P-value = ' + str(p))
def createHistorgramOfPERPBRByMarket(): ''' purpose : 코스피, 코스탁, 전체시장에 대해 PER, PBR의 histogram을 그린다. :return: ''' coll주식종목Data = pymongo.MongoClient('localhost', 27017).get_database("xadb").get_collection("주식종목Data") listKOSPIPER = [] listKOSPIPBR = [] # 코스피 종목구성. dictcondi = {'시장구분':"1" } dictproj = {"PER":1, "PBR":1, "_id":0} objret = coll주식종목Data.find(dictcondi, dictproj) for obj in objret : per = obj["PER"] if per > -10 and per <= 100 : listKOSPIPER.append(per) pbr = obj["PBR"] if pbr > -10 and pbr <= 40: listKOSPIPBR.append(pbr) listKOSDACPER = [] listKOSDACPBR = [] # 코스피 종목구성. dictcondi = {'시장구분':"2" } dictproj = {"PER":1, "PBR":1, "_id":0} objret = coll주식종목Data.find(dictcondi, dictproj) for obj in objret : per = obj["PER"] if per > -10 and per <= 100 : listKOSDACPER.append(per) pbr = obj["PBR"] if pbr > -10 and pbr <= 40: listKOSDACPBR.append(pbr) plotjongmok.plotHistogram([listKOSPIPBR,listKOSDACPBR ], ["PBR_KOSPI", "PBR_KOSDAC"]) plotjongmok.plotHistogram([listKOSPIPER,listKOSDACPER ], ["PER_KOSPI", "PER_KOSDAC"]) chi2, p = stats.chisquare(listKOSPIPER) print('chisquare output') print('Z-score = ' + str(chi2)) print('P-value = ' + str(p))