StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POIntraday candlestick charts using Matplotlib
text
Body
copied!<p>I've been having some difficulty with Matplotlib's finance charting. It seems like their candlestick charts work best with daily data, and I am having a hard time making them work with intraday (every 5 minutes, between 9:30 and 4 pm) data.</p> <p>I have pasted sample data in pastebin. The top is what I get from the database, and the bottom is tupled with the date formatted into an ordinal float for use in Matplotlib.</p> <p><a href="http://pastebin.com/JWG0idDG" rel="nofollow noreferrer">Link to sample data</a></p> <p>When I draw my charts there are huge gaps in it, the axes suck, and the zoom is equally horrible. <a href="https://imgur.com/y7O8A" rel="nofollow noreferrer">http://imgur.com/y7O8A</a></p> <p><a href="https://i.stack.imgur.com/csdrS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/csdrS.png" alt="Enter image description here"></a></p> <p>How do I make a nice readable graph out of this data? My ultimate goal is to get a chart that looks remotely like this:</p> <p><a href="https://i.stack.imgur.com/3oUS7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3oUS7.png" alt="Enter image description here"></a></p> <p><a href="https://i.imgur.com/EnrTW.jpg" rel="nofollow noreferrer">http://i.imgur.com/EnrTW.jpg</a> </p> <p>The data points can be in various increments from 5 minutes to 30 minutes.</p> <hr> <p>I have also made a Pandas dataframe of the data, but I am not sure if pandas has candlestick functionality.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload