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