InvestorsHub Logo

JLS

Followers 62
Posts 7863
Boards Moderated 0
Alias Born 12/14/2004

JLS

Re: SoundGuy post# 35016

Monday, 10/07/2019 12:06:27 PM

Monday, October 07, 2019 12:06:27 PM

Post# of 36850
Your chart appears as I thought.

Just candlestick bodies and no shadows.

However, looking more closely, I see that there probably are shadows in there but you've set their color to black. Fix that. Yellow works for me. Also, you should be able to set the width of the candlestick bodies and also the width of the shadows ... make the shadows fine, not thick.

I've also figured out why your candlestick bodies look like they have a vertical line down the middle: you've put a relatively thick border on the bodies. Eliminate those borders, then set the width you want for the candlestick bodies.

Also, put grid lines on your chart -- brighter lines for monthly, and dimmer lines for weekly (or every fifth day since many months are not evenly divisible by weeks). Then only put labels on the thick lines (not on the thin lines). Yes, Excel lets you do that, and that will eliminate all your date label clutter.

Also, since it's best to have the chart fully adjustable by using values from the list to the left of the chart, You'll need to use formulas for the items in the chart. I'll probably have to give those to you; and I will, cheerfully. The function that will be used is called Offset(). Excel offers Help on all functions, so read up on Offset so you know how it works.

The data for the chart should come from the data table on the SR_CP sheet, and that data should come from the Excel sheet which holds the data for the selected symbol.
Volume:
Day Range:
Bid:
Ask:
Last Trade Time:
Total Trades:
  • 1D
  • 1M
  • 3M
  • 6M
  • 1Y
  • 5Y
Recent AAL News