Candlestick graphs are based on data which includes: Date, Open, High, Low, Close for each candle.
My data includes also additional parameter: color which can have the values: 'blue', 'yellow' or 'gray' .
Based on this value I would like to color the candle.
I don’t know how to use the color data in the update_traces .
How can I achieve this setting?
The code I used:
# Imports that you are going to need to read a file
import pandas as pd
# Import the library you need to create the chart
import plotly.graph_objs as go
# Read the file using pandas - so much easier than writing your own file I/O!
df_symbol_bar_Data = pd.read_csv("d:/spy.csv")
# Show some of the data you read
print(df_symbol_bar_Data.head())
data=[go.Candlestick(x=df_symbol_bar_Data['Date'],
open=df_symbol_bar_Data['Open'],
high=df_symbol_bar_Data['High'],
low=df_symbol_bar_Data['Low'],
close=df_symbol_bar_Data['Close'])]
fig = go.Figure(data=data)
fig.update_traces(increasing_fillcolor='green', selector=dict(type='candlestick'))
fig.update_traces(increasing_line_color='green', selector=dict(type='candlestick'))
fig.update_traces(decreasing_line_color='red', selector=dict(type='candlestick'))
fig.update_traces(decreasing_fillcolor='red', selector=dict(type='candlestick'))
fig.show()
Date Open High ... Adj Close Volume Color
0 23/12/2019 321.589996 321.649994 ... 315.331268 52990000 blue
1 24/12/2019 321.470001 321.519989 ... 315.341095 20270000 yellow
2 26/12/2019 321.649994 322.950012 ... 317.019714 30911200 yellow
3 27/12/2019 323.739990 323.799988 ... 316.941162 42528800 yellow
4 30/12/2019 322.950012 323.100006 ... 315.193817 49729100 gray
[5 rows x 8 columns]
Example:
