Love your sugestions... same price when there is no sales, and barchart for the volume!
Thanks! I want to clarify since "same price when there is no sales" sounds to me like filling the missing price values with the last market price. I was thinking something slightly different, which was to not have a price point at all.
For example, imagine the following price data:
- Day 1: $5
- Day 2: NA (missing since there were no sales)
- Day 3: $3
Currently, Day 2 will be plotted with a price of $0. Under your proposal (as I understand it), Day 2 will be plotted with a price of $5 (filled from Day 1). Under my proposal, Day 2 will not be plotted, in that there will be no point drawn for it. The line would still go through Day 2 at $4, as it decreases from $5 to $3. But there wouldn't be a point at $4, so its clear that no sales occurred and the slope reflects a multi day price change.
@dalz does that make sense? Either way would be a big improvement over $0.
Oh, so you are suggesting connecting the dots between the sales, but with empty dot so to speak to indicate there is no sale. That might be better, cause otherwise we will see this spikes when a trade occurs, rather than a line chart.
Yes. Imagine the current price plot above if you deleted the zero-sale points. The line would then connect the closest days with sale.
Rather than draw an empty dot (a circle with a white interior), I think you can just omit the point entirely. Whether there is a point would be a bit more clear if the point size were increased.
Yeah, if you fill prices with the last-sale price, you'd get more of a plot that looked like it had steps. I sometime use "step" plots, but it really depends on what we think is the most accurate reflection of the data.