-
Notifications
You must be signed in to change notification settings - Fork 0
/
app.py
150 lines (109 loc) · 4.6 KB
/
app.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
from flask import Flask, render_template, request, redirect, url_for
import requests
import pandas
from bokeh.plotting import figure, output_file, save
from bokeh._legacy_charts import TimeSeries
from datetime import datetime
from dateutil.relativedelta import relativedelta
#some helper functions
def determineStartDate():
current_time = datetime.today()
earlier_time = current_time + relativedelta(months=-int(app.vars['timespan']))
return earlier_time.strftime('%Y-%m-%d'), current_time.strftime('%Y-%m-%d')
def checkRequest(stockname):
urlname = 'https://www.quandl.com/api/v3/datasets/WIKI/'
urlname = urlname + stockname + '.json'
urlname = urlname + '?order=asc&exclude_headers=true&column_index='+app.vars['button']
if app.vars['timespan'] != '-1':
starttime, endtime = determineStartDate()
urlname = urlname + '&start_date=' + starttime + '&end_date=' + endtime
urlname = urlname + '&collapse=' + app.vars['timeres'] + '&transformation=rdiff'
urlname = urlname + '?api_key=8zAwUeJsnmGaDrJgEHrr'
print urlname
r = requests.get(urlname)
return urlname, r.status_code
def requestData(urlname):
df = pandas.read_json(urlname)
df = df['dataset']
return df
def plotData(df):
dates = list(zip(*df['data'])[0])
for i in range(0,len(dates)):
dates[i] = datetime.strptime(dates[i],'%Y-%m-%d')
values = list(zip(*df['data'])[1])
output_file("templates/datetime.html")
#data = dict(somevalue=values, Date=dates)
#p = TimeSeries(data, index='Date', title=app.vars['name_stock'], ylabel=app.vars[app.vars['button']])
p = figure(width=800, height=500, x_axis_type="datetime", title="Stock Ticker Information")
p.xaxis.axis_label = 'date'
p.yaxis.axis_label = app.vars[app.vars['button']]
p.line(dates, values, color='navy', alpha=0.5)
p.circle(dates, values, color='navy', alpha=0.5, legend=app.vars['name_stock'])
save(p)
def plotData2(df, df2):
dates = list(zip(*df['data'])[0])
for i in range(0,len(dates)):
dates[i] = datetime.strptime(dates[i],'%Y-%m-%d')
values = list(zip(*df['data'])[1])
dates2 = list(zip(*df2['data'])[0])
for i in range(0,len(dates2)):
dates2[i] = datetime.strptime(dates2[i],'%Y-%m-%d')
values2 = list(zip(*df2['data'])[1])
output_file("templates/datetime.html")
# data = pandas.DataFrame(dict(stock1=values, Date=dates, stock2=values2))
# col_names = [app.vars['name_stock'], 'Date', app.vars['name_stock_second']]
# data.columns[0] = app.vars['name_stock']
# data.columns[2] = app.vars['names_stock_second']
# p = TimeSeries(data, index='Date', title=app.vars['name_stock']+' and '+app.vars['name_stock_second'], ylabel=app.vars[app.vars['button']], legend=True, xlabel='date', width=800, height=400)
p = figure(width=800, height=500, x_axis_type="datetime", title="Stock Ticker Information")
p.xaxis.axis_label = 'date'
p.yaxis.axis_label = app.vars[app.vars['button']]
p.line(dates, values, color='navy', alpha=0.5)
p.circle(dates, values, color='navy', alpha=0.5, legend=app.vars['name_stock'])
p.line(dates2, values2, color='red', alpha=0.5)
p.circle(dates2, values2, color='red', alpha=0.5, legend=app.vars['name_stock_second'])
# p.circle(dates2, values2, color='red', alpha=0.5)
save(p)
# now the flask app
app = Flask(__name__)
app.vars = {}
app.vars['4'] = 'closing price'
app.vars['5'] = 'volume'
app.vars['11'] = 'adjusted closing price'
@app.route('/')
def main():
return redirect('/index')
@app.route('/index', methods=['GET','POST'])
def index():
if request.method == 'GET':
return render_template('index.html')
else:
app.vars['name_stock'] = request.form['name_stock']
app.vars['button'] = request.form['button']
app.vars['timespan'] = request.form['timespan']
app.vars['timeres'] = request.form['timeres']
app.vars['name_stock_second'] = request.form['name_stock_second']
urlname, status = checkRequest(app.vars['name_stock'])
if status == 200:
df = requestData(urlname)
if app.vars['name_stock_second'] == '':
plotData(df)
# if the user selected a second stock, then show that too
else:
urlname2, status2 = checkRequest(app.vars['name_stock_second'])
if status2 == 200:
df2 = requestData(urlname2)
plotData2(df, df2)
else:
render_template('error.html')
return render_template('datetime.html')
else:
return render_template('error.html')
#@app.errorhandler(404)
#def page_not_found(e):
# return render_template('404.html'), 404
#@app.errorhandler(500)
#def page_not_found(e):
# return render_template('500.html'), 500
if __name__ == '__main__':
app.run(port=33507)