I am trying to take candlesticks graph here but it has became an mess please help

importing the necesury packages

import pandas as pd

import matplotlib.pyplot as plt

import mpl_finance as mpf

from mpl_finance import candlestick_ohlc

from bokeh.plotting import figure, show, output_file   

from math import pi



#reading data

df = pd.read_csv("C:/Users/jnnim/Downloads/IDEABO.csv")

df.head()



#indexing

w = 12 * 60 * 60 * 1000 # half day in ms



df.index = pd.to_datetime(df.index)



inc = df.Close > df.Open

dec = df.Open > df.Close


The various 'interactions' we want in our candlestick graph. This is an argument to be passed in figure () from bokeh.plotting

TOOLS = "pan, wheel_zoom, box_zoom, reset, save"


Pan: It helps you pan/move the plot


# Wheel Zoom: You can zoom in using the wheel of your mouse

# Box Zoom: You can zoom in by creating a box on the specific area of the plot. Use the mouse, click and drag to create the box

# Reset: If you want to reset the visualisation of the plot

# Save: Saving the plot (entire or the part which you want) as an image file



# Passing the arguments of our bokeh plot
p = figure(x_axis_type = "datetime", tools = TOOLS, plot_width = 1000, title = "spy candelsticks")


# The orientation of major tick labels can be controlled with the major_label_orientation property.
# This property accepts the values "horizontal" or "vertical" or a floating point number that gives
# the angle (in radians) to rotate from the horizontal.
p.axis.major_label_orientation = pi / 4


# Alpha signifies the floating point between 0 (transparent) and 1 (opaque).
# The line specifies the alpha for the grid lines in the plot.
p.grid.grid_line_alpha = 0.3


# Configure and add segment glyphs to the figure
p.segment(df.index, df.High, df.index, df.Low, color = "red")

# Adds vbar glyphs to the Figure
p.vbar(df.index[inc], df.Open[inc], df.Close[inc], fill_color = "#1ED837", line_color = "black")
p.vbar(df.index[dec], df.Open[dec], df.Close[dec], fill_color = "#F2583E", line_color = "black")

# Generates simple standalone HTML documents for Bokeh visualization
output_file("candlestick.html", title = "candlestick.py example")
# The graph will open in another tab of the browser
show(p)




 

Hello Nimesh,



Can you elaborate on where you are facing issues in the code?

 

I am unable to plot candle stick after writing exact code shown in course i am not able to uplod screen shot because here some sot of URL format is needed so i don't know how i can do it 

Hello Nimesh,



Try running the cell with the show(p) function a couple of times. This is a open-ended issue with matplotlib running on jupyter. 

sir i am working on anaconda spyder 

Hi Nimesh,



In Spyder, the candlestick plots are a bit messy. Could you please try running on the Jupyter notebook.



Also, you can read the documentation of mplfinance which helps you in plotting candlestick.

https://pypi.org/project/mplfinance/