Swan Noir,
I get where you are coming from and I hear you. My background is a bit more analytical vs. yours, which appears to be more of a businessman type role. I've worn both hats, so I can relate.
It may look simple, but to be honest, one of the hardest things I've found through experience (and still find tough), is to actually formulate the problem before you even analyze it. You will likely not find that type of analytical candlestick body threshold sweep in any other book. It is a sensitivity analysis, and is one way to evaluate the problem within an objective framework. Someone could have countered argued that the fixed commission can be swamped out if you trade in larger size, but it is just another variable that needs to be dealt with and considered.
See, there are dozens of books on candlesticks,elliot,etc... and dozens of interpretations as well. The seminal candlestick books would probably be Nison's, yet, while he distinguishes between hammer, doji, and shooting star, Brooks takes all the distinctions and jumbles them into just one (doji); desecrating old school knowledge. Yet, Nison's work is subjective as well-- so it opens itself up to different interpretations. Although there might be wisdom buried in their ideas, it takes some thinking to translate these concepts to objective, verifiable analysis and that is likely the hardest part.
Now regarding excel or tools. I can only recommend the way I learn things, and that is-- force yourself to try to solve examples. Go get some very basic book and excel,
The visual quickstart ones are very simple and great to learn:
http://www.amazon.com/Microsoft-Off...=sr_1_1?ie=UTF8&s=books&qid=1252736121&sr=8-1
you can probably get some at the library, or the dummy books for free.
Then, find one that has financial models, so you are motivated:
two great ones come to mind:
http://www.amazon.com/Financial-Ana...=sr_1_1?ie=UTF8&s=books&qid=1252734588&sr=1-1
(I have the older edition).
http://www.amazon.com/Financial-Mod...=sr_1_4?ie=UTF8&s=books&qid=1252734561&sr=8-4
If you want one that is geared more towards trading, I recommend
http://www.amazon.com/Trading-Syste...=sr_1_1?ie=UTF8&s=books&qid=1252734679&sr=1-1
Although, be aware that he uses a combination of excel and trade-station to validate his ideas.
There is also an EXCELLENT site by a retired professor with copious excel examples for finance (minimal vba, mainly excel):
http://www.gummy-stuff.org/
I had the pleasure to inspire him to work some examples for me. He is very helpful and gives generously of his time.
I could go on with the recs, but you really need to practice, practice, practice, and think of some example you want to solve (it will inspire you to practice), then find a way to solve it.
Cheers,
dt
P.S. You can also ask for help here and there are plenty of excel forums, where they will kindly help as well.
I get where you are coming from and I hear you. My background is a bit more analytical vs. yours, which appears to be more of a businessman type role. I've worn both hats, so I can relate.
It may look simple, but to be honest, one of the hardest things I've found through experience (and still find tough), is to actually formulate the problem before you even analyze it. You will likely not find that type of analytical candlestick body threshold sweep in any other book. It is a sensitivity analysis, and is one way to evaluate the problem within an objective framework. Someone could have countered argued that the fixed commission can be swamped out if you trade in larger size, but it is just another variable that needs to be dealt with and considered.
See, there are dozens of books on candlesticks,elliot,etc... and dozens of interpretations as well. The seminal candlestick books would probably be Nison's, yet, while he distinguishes between hammer, doji, and shooting star, Brooks takes all the distinctions and jumbles them into just one (doji); desecrating old school knowledge. Yet, Nison's work is subjective as well-- so it opens itself up to different interpretations. Although there might be wisdom buried in their ideas, it takes some thinking to translate these concepts to objective, verifiable analysis and that is likely the hardest part.
Now regarding excel or tools. I can only recommend the way I learn things, and that is-- force yourself to try to solve examples. Go get some very basic book and excel,
The visual quickstart ones are very simple and great to learn:
http://www.amazon.com/Microsoft-Off...=sr_1_1?ie=UTF8&s=books&qid=1252736121&sr=8-1
you can probably get some at the library, or the dummy books for free.
Then, find one that has financial models, so you are motivated:
two great ones come to mind:
http://www.amazon.com/Financial-Ana...=sr_1_1?ie=UTF8&s=books&qid=1252734588&sr=1-1
(I have the older edition).
http://www.amazon.com/Financial-Mod...=sr_1_4?ie=UTF8&s=books&qid=1252734561&sr=8-4
If you want one that is geared more towards trading, I recommend
http://www.amazon.com/Trading-Syste...=sr_1_1?ie=UTF8&s=books&qid=1252734679&sr=1-1
Although, be aware that he uses a combination of excel and trade-station to validate his ideas.
There is also an EXCELLENT site by a retired professor with copious excel examples for finance (minimal vba, mainly excel):
http://www.gummy-stuff.org/
I had the pleasure to inspire him to work some examples for me. He is very helpful and gives generously of his time.
I could go on with the recs, but you really need to practice, practice, practice, and think of some example you want to solve (it will inspire you to practice), then find a way to solve it.
Cheers,
dt
P.S. You can also ask for help here and there are plenty of excel forums, where they will kindly help as well.