Python plotly go line and bar graphs together

📊 Plotly Python
1

Hello,

I m working on a python project with yfinance library, there is no problem with one x-y axis, but when I try to add secondary y axis I get this error:

ValueError:
Invalid value of type ‘builtins.str’ received for the ‘x’ property of scatter
Received value: ‘Date’

The 'x' property is an array that may be specified as a tuple,
list, numpy array, or pandas Series

Any help? thanks from advance

Here is my code:
import yfinance as yf
import plotly.graph_objects as go

colors = {
‘background’: ‘#f5f5f5’,
‘text’: ‘#000000’
}

def get_stock_price_fig(df):
fig = make_subplots(specs=[[{“secondary_y”: True}]])
fig.add_trace(
go.Line(df, x=‘Date’, y=‘Close’,template=“plotly_white”),
secondary_y=True
)
fig.add_trace(
go.Bar(df, x=‘Date’, y=‘Volume’),
secondary_y=True
)

fig.update_layout(
    plot_bgcolor=colors['background'],
    paper_bgcolor=colors['background'],
    font_color=colors['text']
)
fig.update_xaxes(
    rangeslider_visible=False,

    rangeselector=dict(
        buttons=
            list([
            dict(count=14, label="2w", step="day", stepmode="backward"),
            dict(count=30, label="1m", step="day", stepmode="backward"),
            #dict(count=1, label="1m", step="month", stepmode="backward"),
            dict(count=6, label="6m", step="month", stepmode="backward"),
            dict(count=1, label="1y", step="year", stepmode="backward"),
            dict(step="all",stepmode="backward"),
            dict(count=1, label="YTD", step="year", stepmode="todate")

            ]

            )

    ))

fig.update_xaxes(showgrid=True)
#fig.update_xaxes(showgrid=True, tickfont_family="Arial Black")
fig.update_yaxes()

return fig
2

The data frames obtained from Yahoo Finance are indexed by date, so your code should de-index them. Also, for the graph object, the xy axis needs to be specified for the data frame and column. For line graphs, the second axis must be set to not be used. Finally, the style of the graph must be specified in the layout update.

import yfinance as yf
from plotly.subplots import make_subplots
import plotly.graph_objects as go

colors = {
    "background": "#f5f5f5",
    "text": "#000000"
}

df = yf.download("AAPL", start="2021-01-01", end="2022-07-01")
df.reset_index(inplace=True)

def get_stock_price_fig(df):
    
    fig = make_subplots(specs=[[{"secondary_y": True}]])
    
    
    fig.add_trace(go.Bar(
        x=df["Date"],
        y=df["Volume"],
        name='Volume',
    ), secondary_y=False)

    fig.add_trace(go.Line(
        x=df["Date"],
        y=df["Close"],
        name='Close',
    ), secondary_y=True)

    fig.update_layout(
        plot_bgcolor=colors['background'],
        paper_bgcolor=colors['background'],
        font_color=colors['text']
    )
    fig.update_xaxes(
        rangeslider_visible=False,

        rangeselector=dict(
            buttons=
                list([
                dict(count=14, label="2w", step="day", stepmode="backward"),
                dict(count=30, label="1m", step="day", stepmode="backward"),
                dict(count=6, label="6m", step="month", stepmode="backward"),
                dict(count=1, label="1y", step="year", stepmode="backward"),
                dict(count=1, label="YTD", step="year", stepmode="todate"),
                dict(step="all",stepmode="backward"),
                #dict(count=1, label="1m", step="month", stepmode="backward"),
                ]

                )

        ))

    fig.update_xaxes(showgrid=True)
    #fig.update_xaxes(showgrid=True, tickfont_family="Arial Black")
    fig.update_yaxes()
    fig.update_layout(template="plotly_white")

    return fig

get_stock_price_fig(df)

newplot(164)
newplot(164)1169×360 37.2 KB

2 Likes
3

Thank you, this works quite well.

fig = make_subplots(specs=[[{“secondary_y”: True}]])

fig.add_trace(
    go.Scatter(x=df['Date'], y=df['Close'], name="Price", mode="lines"),
    secondary_y=False
)

fig.add_trace(
    go.Bar(x=df['Date'], y=df['Volume'],name="Volume"),
    secondary_y=True
)