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
