def all_dbmetafrmSRC(pglmt=10000, src="YALE", authtkn=AUTHTOKEN):
"""
all_dbmetafrmSRC = all_dbmetafrmSRC(pglmt=10000,src="YALE",authtkn=AUTHTOKEN)
all_dbmetafrmSRC, i.e. all database Metadata from a Source, returns all the "metadata", the information describing a databse, for all databases from a single source, specified by a string that is the Quandl code
INPUTS:
int pglmt: (default=10000), page numberS to search
str sre: (default="YALE", chosen as an example), the Quandl code for the SOURCE or "src" to search from
str authtkn: (default="AUTHTOKEN", that's globally declared at the beginning of the .py code), your authentication code with Quandl, you should find that under API-key in your Quandl account and copy and paste that into the code
"""
metalst = []
counter = 1
while (counter <= pglmt):
resp = Quandl.search(query="*",
source=src,
page=counter,
authtoken=authtkn)
if len(resp) != 0:
metalst = metalst + resp
counter += 1
else:
break
if counter > pglmt:
print "Counter limit, pglmt, was reached; try a higher pglmt, i.e. page limit \n"
return metalst
def getDatasets(self):
print "In get datasets"
datasets = Quandl.search(query=self.symbol,
source="SEC",
prints=False,
authtoken=self.key)
self.rawData = datasets
def getDatasets(self):
print "In get datasets"
datasets = Quandl.search(query="",
source=self.datasource,
prints=False,
authtoken=self.key)
return datasets
def search_quandl(query, source="QUANDL", authtoken=None):
currPage = True
quandlAll = []
pageNo = 0
while currPage:
currPage = Quandl.search(query, source=source, prints=False, page=pageNo, authtoken=authtoken)
quandlAll.append(currPage)
pageNo += 1
return chain(*quandlAll)
def info(symbol):
query_params = request.args
trim_start = query_params.get('start_date') or '2015-12-01'
trim_end = query_params.get('end_date') or '2015-12-31'
datasets = Quandl.search(symbol, authtoken=keys['quandl'], verbose=False)
code = datasets[0][u'code']
data = Quandl.get(code,
authtoken=keys['quandl'],
collapse='daily',
trim_start=trim_start,
trim_end=trim_end)
return data.to_html()
def update_dataset_csv(token, source, filename):
dataset_info = []
for page in range(1, 6910): #7414
is_time(True);
print page
datasets = None
while datasets is None:
try:
datasets = Quandl.search(query = "*", source = source, page = page, verbose = False, authtoken=token)
except urllib2.URLError:
print 'none'
pass
for dataset in datasets:
dataset_info.append( [dataset['code'], dataset['name']] )
csv_write(filename, dataset_info)
def getStocks(symbols, trim_start="2005-01-01", trim_end="2015-12-31"):
"""
Paramters
---------
symbols: list of string symbols. eg. ['AAPL', 'KCG']
Returns
-------
a dictionary of pandas data frames containing all the close prices.
"""
print symbols
dfs = {}
for symbol in symbols:
print symbol,
flag = False
#Get data from either Yahoo or Google
for source in ['','YAHOO/', 'WIKI/', 'GOOG/NYSE_', 'GOOG/NASDAQ_', 'GOOG/AMEX_']:
try:
data = Quandl.get(source+symbol,authtoken='c2365v55yoZrWKxbVxwK',
trim_start = trim_start, trim_end = trim_end)
flag = True
break
except:
pass
if not flag:
print 'Retrieving ' + symbol + ' unsuccessful. - No symbol. Suggesting:******'
suggest = Quandl.search(symbol,authtoken='c2365v55yoZrWKxbVxwK', verbose=False)
print suggest[0]['name'], suggest[0]['code']
continue
else:
try:
data = data[['Adjusted Close']]
data.columns = ['Close']
except:
try:
data = data[['Close']]
except:
print 'Retrieving ' + symbol + ' unsuccessful. - No close data. Output whatever is returned.'
dfs[symbol] = data
return dfs
def signup():
token = "6AYaJmh1XPfLQrfWPnDP"
ticker = request.form['ticker']
print("Stock given:" + ticker)
try:
test = Quandl.get(ticker, authtoken=token)
print "Quandle Queried"
bokehscript, bokehdiv = build_plot(test, ticker)
return render_template("results.html", bokeh_script=bokehscript, bokeh_div=bokehdiv)
except Quandl.ErrorDownloading as detail:
print detail
return render_template('index.html', error="Error Downloading")
except Quandl.DatasetNotFound as detail:
search = Quandl.search(ticker, authtoken=token)
codes = [s['code'] for s in search]
error = "<div> Code not in the list. Try: <ul><li>" + "</li><li>".join(codes) + "</li></ul> </div>"
print error
return render_template("index.html", error=error)
except Quandl.CallLimitExceeded as detail:
print detail
return render_template('index.html', error="API Call limit exceeded")
return render_template('index.html', error="Unknown Error")
def all_dbmetafrmSRC(pglmt=10000,src="YALE", authtkn=AUTHTOKEN):
"""
all_dbmetafrmSRC = all_dbmetafrmSRC(pglmt=10000,src="YALE",authtkn=AUTHTOKEN)
all_dbmetafrmSRC, i.e. all database Metadata from a Source, returns all the "metadata", the information describing a databse, for all databases from a single source, specified by a string that is the Quandl code
INPUTS:
int pglmt: (default=10000), page numberS to search
str sre: (default="YALE", chosen as an example), the Quandl code for the SOURCE or "src" to search from
str authtkn: (default="AUTHTOKEN", that's globally declared at the beginning of the .py code), your authentication code with Quandl, you should find that under API-key in your Quandl account and copy and paste that into the code
"""
metalst = []
counter = 1
while (counter <= pglmt):
resp = Quandl.search(query="*",source=src,page=counter,authtoken=authtkn)
if len(resp) != 0:
metalst = metalst + resp
counter += 1
else:
break
if counter > pglmt:
print "Counter limit, pglmt, was reached; try a higher pglmt, i.e. page limit \n"
return metalst
def getDatasets(self):
print "In get datasets"
datasets = Quandl.search(query="", source=self.datasource, prints=False, authtoken=self.key)
return datasets
def quandl_search(search_element):
datasets = Quandl.search(query=search_element, page=2)
return datasets
import Quandl
datasets = Quandl.search('OIL')
print(datasets[0])
def get_code(symbol):
datasets = Quandl.search(symbol,
authtoken=auth_keys['quandl'],
verbose=False)
code = datasets[0][u'code']
return code
import Quandl
# print help(Quandl.search)
# Quandl.search(query = 'G-20', page = +5, prints = True)
# Quandl.search(query = 'oil', source = "Source you wish to search", page = 1, prints = True)
datasets = Quandl.search('gdp',page = 1)
print datasets.Name
def getDatasets(self):
print "In get datasets"
datasets = Quandl.search(query = self.symbol, source = "SEC", prints = False, authtoken=self.key)
self.rawData = datasets
def quandl_search(search_element):
datasets = Quandl.search(query = search_element, page = 2)
return datasets
