tdavidge
commented
1 year ago So, I am making progress albeit with great difficulty. With the help of this I have managed to get the first attachement by show and then manually saving. However, when using savefig I get the second attachement.
My questions now are a) how to get the short date (no year) to appear horizontally centered below each of the 5 days time bars b) why the difference between showing and saving the output ? c) why is the show result offset to the right ? in the display window I cannot see the full price, not is there a ylabel
code:
import sys, os, datetime, time, warnings #csv
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import mplfinance as mpf
from datetime import datetime
import pyodbc #database connectivity
cnxn = pyodbc.connect(database connection)
sym = sys.argv[1] #symbol name
act_dt = sys.argv[2] #active date of the required process no quotes
act_int = sys.argv[2].replace('/', '-')#this converts the incoming dates into values that can be used in the savefig filename
df=pd.read_sql_query(" \
database query
",cnxn, )
df.columns = ['Date', 'Open', 'High', 'Low', 'Close', 'Volume']
df.set_index('Date')
df.index = pd.to_datetime(df.Date)
print(df)
start_date = df['Date'].iloc[0]
end_date = df['Date'].iloc[-1]
print(start_date)
print(end_date)
fig, axlist= mpf.plot(df,
style='yahoo',
type='line',
title='\n'+sym+' '+act_int,
volume=False,
xrotation=90,
ylabel='Price',
figsize=(15,7),
figscale=1,
returnfig=True,
tight_layout=True,
show_nontrading=False,
#savefig=dict(fname='ohlc_wide_'+sym+'_'+act_int+'.jpg',dpi=125, quality=95, bbox_inches='tight')
)
#idx = pd.date_range(start_date, end_date, freq='30T')
idx = pd.date_range(start_date, end_date, freq='1H')
df_label_idx = pd.DataFrame(index=idx)
df_label = pd.merge(df_label_idx, df, how='inner', left_index=True, right_index=True )
# Tick labels are generated based on df_label
tick_labels = list(df_label.index.strftime('%H:%M'))
ticklocations = [df.index.get_loc(tick) for tick in df_label.index ]
axlist[-2].xaxis.set_ticks(ticklocations)
axlist[-2].set_xticklabels(tick_labels)
mpf.show()
DanielGoldfarb
I am trying to create a 5 day chart of Intraday Stock data using mplfinance. From Open to Close only, no data gaps. I can get a chart to save and/or show but am struggling with formatting the grid spacing and the x-axis interval/labels. I have been trying to get this working in matplotlib for what seems like an age now and I just cannot get it work. At least with mplfinance I was able to get a chart to work. I'm simply not good enough at python coding to understand how to format the xaxis I am afraid.
My question obviously is how to format grid and x-axis to line the grid with at least the open of the day (as in on change of date) so I can see the overnight GAP, and say a frequency of hourly between 09:30am and 4:00pm. I apologize in advance for my ignorance but this is all kinda new to me and having been trying all manner of examples that I do not understand, this is my last resort.
Any assistance would be very much appreciated. Using python 3.7 and mplfinance v0.12.9b5 on windows 11 pro.
This gives me the attached chart.