Skip to content

Instantly share code, notes, and snippets.

@vb100
Last active July 11, 2017 19:52
Show Gist options
  • Save vb100/8e73b86dbf2c754b9f28abe2fd7b883d to your computer and use it in GitHub Desktop.
Save vb100/8e73b86dbf2c754b9f28abe2fd7b883d to your computer and use it in GitHub Desktop.
This Python application read Finance stock data from Google API and represent it in HTML file.
from pandas_datareader import data
import datetime
from bokeh.plotting import figure, show, output_file
x
start = datetime.datetime(2016,11,1)
end = datetime.datetime(2017,2,10)
df = data.DataReader(name="GOOG", data_source="google", start=start, end=end)
#date_increase = df.index[df.Close > df.Open]
#date_decrease = df.index[df.Close < df.Open]
def inc_dec(c, o):
if c > o:
value = "Increase"
elif c < o:
value = "Decrease"
else:
value = "Equal"
return value
df["Status"] = [inc_dec(c, o) for c, o in zip(df.Close, df.Open)]
df["Middle"] = (df.Open+df.Close)/2
df["Height"] = abs(df.Close - df.Open)
#print(df)
p = figure(x_axis_type='datetime', width=1000, height=300, responsive=True)
#p.title = "Candlestick Chart"
p.grid.grid_line_alpha=0.9
hours_12 = 12*60*60*1000
p.segment(df.index, df.High, df.index, df.Low, color="Black")
p.rect(df.index[df.Status == "Increase"],
df.Middle[df.Status=="Increase"],
hours_12,
df.Height[df.Status =="Increase"],
fill_color="#CCFFFF",
line_color = "black")
p.rect(df.index[df.Status == "Decrease"],
df.Middle[df.Status == "Decrease"],
hours_12,
df.Height[df.Status == "Decrease"],
fill_color="#FF3333",
line_color = "black")
output_file("CS.html")
show(p)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment