Rob's Handy Fibonacci Tool

[Rob]

Folks, because I'm such a nice guy, I'm giving you a copy of my handy-dandy Fibonacci Retracement Tool.

You need Microsoft Excel on your computer in order to run it. It's not the greatest thing since bottled beer, but it is kind of handy. If you try it and like it, let me know by leaving a little note here.

Here's a screenshot ...

http://img151.imageshack.us/img151/1493/akt5.jpg (http://imageshack.us)


Update: 4:03 p.m., I just added more functionality to this spreadsheet. I added a button (not shown in screenshot) to easily create a text file that has the important info from the spreadsheet.http://www.mrmarketishuge.com/images/icons/icon14.gif

[Lyehopper]

Folks, because I'm such a nice guy, I'm giving you a copy of my handy-dandy Fibonacci Retracement Tool.

You need Microsoft Excel on your computer in order to run it. It's not the greatest thing since bottled beer, but it is kind of handy. If you try it and like it, let me know by leaving a little note here.

Here's a screenshot ...

http://img151.imageshack.us/img151/1493/akt5.jpg (http://imageshack.us)



Update: 4:03 p.m., I just added more functionality to this spreadsheet. I added a button (not shown in screenshot) to easily create a text file that has the important info from the spreadsheet.http://www.mrmarketishuge.com/images/icons/icon14.gif

Pretty cool Rockin'Rob.... Thanks for sharing!

[skiracer]

Pretty cool Rockin'Rob.... Thanks for sharing!

Ditto and groovy too Rob.

[StkyTreat]

Hi Rob I didn’t know you were a fan of Fibonacci. Are you a math major or an engineer?
I understand the fundamental of Fibonacci and familiar with the retracement. The retracement takes the high and low of the stock and dividing by the vertical distance by the Fibonacci ratios.

I’m not sure how to use you spreadsheet. I was trying to see your formulas but the spread sheet is writing protected. Anyway give me a few more days to think about this and will have more to add. Thanks

[StkyTreat]

Hi Rob

Never mind, I got it...sorry it took my dumb ass so long to figure it out. Thanks

[Rob]

I didn’t know you were a fan of Fibonacci. Are you a math major or an engineer?No, but maybe I should have been as much as I love numbers.

I understand the fundamental of Fibonacci and familiar with the retracement. The retracement takes the high and low of the stock and dividing by the vertical distance by the Fibonacci ratios.When I first heard about people applying Fibonacci ratios to stock prices, my first impression was that it was a lot of hooey. But I did some reading on the subject and how these retracement percentages seem to be often observed in nature, and I began to understand that there may be something to this theory. At any rate, like so many other things in life, if enough people put faith in it, it will become a self-fulfilling prophecy regardless of whether there is any validity to it. Here is an interesting article (http://www.bsu.edu/libraries/ahafner/awh-th-fibonacci-num.html) on using Fibonacci numbers in trend analysis, which also has a little background info.

I was trying to see your formulas but the spread sheet is writing protected.I always do that. In this case the formulas shouldn't be too hard to figure out.

. . . will have more to add.I would like to read what you have to say.

Never mind, I got it...sorry it took [me] so long to figure it out. ThanksYou're welcome.