def get_histPcsv(symbol, startdate ='', enddate=''): """ get_histPcsv - get historical prices .csv Rationale - EY : YQL doesn't get all the historical prices-very strange """ HistPurl = urlparts( HISTORICAL_URL ) if (startdate == '' and enddate == ''): HistPurl.qs = {'s': symbol } HistPurl.mkquery() else: qdict = {'s':symbol} qstartdate = dict(zip(['c','a','b'],startdate.split('-'))) qstartdate['a'] = '0'+str(int(qstartdate['a'])-1) qenddate = dict(zip(['f','d','e'],enddate.split('-'))) qenddate['d'] = '0'+str(int(qenddate['d'])-1) qdict.update(qstartdate) qdict.update(qenddate) HistPurl.qs = qdict HistPurl.mkquery() f = urlopen( HistPurl.urlout() ) data = [ row for row in csv.reader(f) ] return data
def get_histPcsv(symbol, startdate='', enddate=''): """ get_histPcsv - get historical prices .csv Rationale - EY : YQL doesn't get all the historical prices-very strange """ HistPurl = urlparts(HISTORICAL_URL) if (startdate == '' and enddate == ''): HistPurl.qs = {'s': symbol} HistPurl.mkquery() else: qdict = {'s': symbol} qstartdate = dict(zip(['c', 'a', 'b'], startdate.split('-'))) qstartdate['a'] = '0' + str(int(qstartdate['a']) - 1) qenddate = dict(zip(['f', 'd', 'e'], enddate.split('-'))) qenddate['d'] = '0' + str(int(qenddate['d']) - 1) qdict.update(qstartdate) qdict.update(qenddate) HistPurl.qs = qdict HistPurl.mkquery() f = urlopen(HistPurl.urlout()) data = [row for row in csv.reader(f)] return data
def execute(self,yql): qdict = {'q' : yql , 'format' : 'json', 'env': DATATABLES_URL} xparts = urlparts( PUBLIC_API_URL ) xparts.qs = qdict xparts.mkquery() self.rqstrespone = requests.get( xparts.urlout() )
def executeYQLQuery(yql): yqldict = {'q': yql, 'format': 'json', 'env': DATATABLES_URL } url = urlparts(PUBLIC_API_URL) url.qs = yqldict url.mkquery() return requests.get( url.urlout() ).json
def execute(self, yql): qdict = {'q': yql, 'format': 'json', 'env': DATATABLES_URL} xparts = urlparts(PUBLIC_API_URL) xparts.qs = qdict xparts.mkquery() self.rqstrespone = requests.get(xparts.urlout())
def executeYQLQuery(yql): yqldict = {'q': yql, 'format': 'json', 'env': DATATABLES_URL} url = urlparts(PUBLIC_API_URL) url.qs = yqldict url.mkquery() return requests.get(url.urlout()).json