Stock (Gann) Swing charts?

Has anybody had experience with using excel to make stock market (Gann) swing charts.
If so I'd lke to know how to create them, preferrably overlaid on candlestick charts??
Bernie

Is this a stock chart (candlestick or whatever) with an added series,
based on some formula? I have instructions for adding such a series to
a stock chart on this web page:

http://www.geocities.com/jonpeltier/...ChartPlus.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Bummers wrote:

Has anybody had experience with using excel to make stock market
(Gann) swing charts.
If so I'd lke to know how to create them, preferrably overlaid on
candlestick charts??
Bernie

Jon,
See - http://www.afsd.com.au/article/hottrader/solomana.htm

or
http://www.paritech.com/products/sof..._lesson_4m.asp

I want to create the "squarish" style swing charts from the daily stock
data.
Bernie
"Jon Peltier" wrote in message
...
Is this a stock chart (candlestick or whatever) with an added series,
based on some formula? I have instructions for adding such a series to
a stock chart on this web page:

http://www.geocities.com/jonpeltier/...ChartPlus.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Bummers wrote:

Has anybody had experience with using excel to make stock market
(Gann) swing charts.
If so I'd lke to know how to create them, preferrably overlaid on
candlestick charts??
Bernie

Bernie -

Well, since the X axis isn't a time axis, but just a count of the
accumulated selling points, you wouldn't really overlay it on the
candlestick chart. You could, but then your bars would all be different
widths.

You would need to place formulas in your worksheet, or maybe a macro,
that would calculate the points at which you need to indicate a high or
low point. You could write your own algorithms, or steal, I mean copy,
other ones you think work well.

I'd suggest making a Step Chart, as described by Tushar Mehta on his web
site (http://tushar-mehta.com). It uses error bars to connect the
points in this type of chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Bummers wrote:
Jon,
See - http://www.afsd.com.au/article/hottrader/solomana.htm

or
http://www.paritech.com/products/sof..._lesson_4m.asp

I want to create the "squarish" style swing charts from the daily stock
data.
Bernie
"Jon Peltier" wrote in message
...

Is this a stock chart (candlestick or whatever) with an added series,
based on some formula? I have instructions for adding such a series to
a stock chart on this web page:

http://www.geocities.com/jonpeltier/...ChartPlus.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Bummers wrote:


Has anybody had experience with using excel to make stock market
(Gann) swing charts.
If so I'd lke to know how to create them, preferrably overlaid on
candlestick charts??
Bernie

GOOD POST ! I'll br eatching for answers ...

Would you mind if I widened this to make a call for resources [URLs] to help
with stock market work,
from charting to downloading data ?

Frank


"Bummers" wrote ...
Has anybody had experience with using excel to make stock market (Gann)
swing charts.
If so I'd lke to know how to create them, preferrably overlaid on
candlestick charts??
Bernie

Thanks Jon,
I'm not too worried about the width of the bars being different widths but
I'll give Tushar Mehta's step chart a go.
Thanks,
Bernie
"Jon Peltier" wrote in message
...
Bernie -

Well, since the X axis isn't a time axis, but just a count of the
accumulated selling points, you wouldn't really overlay it on the
candlestick chart. You could, but then your bars would all be different
widths.

You would need to place formulas in your worksheet, or maybe a macro,
that would calculate the points at which you need to indicate a high or
low point. You could write your own algorithms, or steal, I mean copy,
other ones you think work well.

I'd suggest making a Step Chart, as described by Tushar Mehta on his web
site (http://tushar-mehta.com). It uses error bars to connect the
points in this type of chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Bummers wrote:
Jon,
See - http://www.afsd.com.au/article/hottrader/solomana.htm

or

http://www.paritech.com/products/sof..._lesson_4m.asp

I want to create the "squarish" style swing charts from the daily stock
data.
Bernie
"Jon Peltier" wrote in message
...

Is this a stock chart (candlestick or whatever) with an added series,
based on some formula? I have instructions for adding such a series to
a stock chart on this web page:

http://www.geocities.com/jonpeltier/...ChartPlus.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Bummers wrote:


Has anybody had experience with using excel to make stock market
(Gann) swing charts.
If so I'd lke to know how to create them, preferrably overlaid on
candlestick charts??
Bernie

Frank,
There seems to be plenty of such resources but most seem to want to be paid
for their efforts. (Understandably - I guess.)
Search for "gann swing charts" & you'll find out.
Let me know if you find otherwise - or of a newsgroup that covers such
topics?
Bernie
"1 ½" wrote in message ...
GOOD POST ! I'll br eatching for answers ...

Would you mind if I widened this to make a call for resources [URLs] to
help
with stock market work,
from charting to downloading data ?

Frank


"Bummers" wrote ...
Has anybody had experience with using excel to make stock market (Gann)
swing charts.
If so I'd lke to know how to create them, preferrably overlaid on
candlestick charts??
Bernie