Fibonacci Sequence Spreadsheet and the 0.61803 Golden Ratio

Fibonacci Sequence Video
I often talk about the 61.8% retracement. I said in previous videos that I wanted to know more, and I found it. The logic on the 61.8, 38.2, 76.4 and 23.6 are explained in this video. The 50% is self explanatory, but the 23.6% number is shown in this video.

To make this spreadsheet do the following
A1 = 0
A2 = 1
A3 = A1+A2
Copy A4 down to your target area

The spreadsheet I used is called Open Office and is free for download on the internet

Category:

Education

Tags:

• fibonacci
• sequence
• retracement
• stock
• market
• graphs
• golden
• ratio
• number
• numb3r
• math
• How To
• calculate
• education
• spreadsheet
• algerbra
• calculus
• science
• universe
• spiral
• galaxy
• flower

[artdeco101010]

That's pretty cool man, I love open office. I realized recently that you can generate random numbers from any probability distribution as well and use them to build simulations inside the spreadsheet.

[endlessmountain]

OH man, why did you have to tell me that :)

Im kidding, but as a kid I was so obsessed with computer programming a random number generator and now im going to do some again here. LOL

It is =randnumber(x;y)

[endlessmountain]

Cont

Sorry it is =RandBetween(x;y)

x= lower interger

y=highest interger for the random number difference you want.

Therefore a random number from 40 to 120 would be =randbetween(40;120)

[rodneywar]

0.61803 is a chord factor constant for a 2 frequency geodesic dome.

[rodneywar]

0.61803 is a chord factor contant for a 2 frequency geodesic dome.

[ytgv3fc7]

with -0.8x (x=trading days) since the december peak, you can add 146.82 to trend the 80day rate of change% then compute the prices

monday 1117.87 - next monday = $1115.83 - next monday 1121.8 next monday 1132.76

apr 1st 1080.57

Past this I think the model drops lower than longer term trends (exponential) & is invalid

[ytgv3fc7]

so what I would suggest is learning how to spot real trends that are reliable over long periods of data (behaviour) and testing them to ensure you get good answers. This includes discarding models that are tested and fail too many times. Trends also change: the trend I mentioned will expire. I don't know when. I hope to learn how to find that answer by looking at past similar trends. I also hope to start charting using inflation-adjusted numbers to relate to real value, not "nominal" ($ we see)

[ytgv3fc7]

depends which charts you are looking at, and what time-frame. Some timings are psychological but even so, adhere to physical limits. The money invested won't exceed income + credit-leverage and some people will use asset/income only (much wiser). Many such assets acquired, profits earned, income paid, follow schedules and so the cycles we see collectively can connect to those cycles, so that's no longer psychological, it's spending money only once you have it, for example. Trends can change...

[NicosMind]

So would you think it would be worth my time learning technical analysis?

What it looks like to me is more psychological than technical. We like patterns, we like round numbers(like gold hitting $1000) So if we have all these people drawing wedge shapes in graphs, and then waiting for an item to hit a level before buying thats what drives it.

But thats just how it seems to me. Oh and of course interest rates are important.

Im wanting to learn more but i need guidance

[lizadfuel]

Great video... Can you do a fibonaci video on the historical silver/gold ratio? Would be nice... Peace

[ytgv3fc7]

I really don't know why the Fibonacci sequence is so useful (as I apply it, not always as I see others attempt to do so). I do know that phi 0.6180339887 (or 1.6180339887, the inverse) is tied into EVERYTHING in nature, a nature we can't escape. In any case if I do plan to plot predicted fib-lines past today's date I'll need to trend the moving average(s) I'm using as well to anchor it.

[ytgv3fc7]

I'm good with math. That's also why I don't like a lot of the technical analysis I see because it's too visual, too short-term, too lacking in the use of real math. I don't buy into any "head and shoulders" or whatever patterns - it's predicting weather based on imaginary cloud-pictures. Not accurate. The 65-day rate of change% is trending down, and when it hits -6% the 65 day prior price is 1129, meaning the new price would trend to 1061 us$ for gold. It's the high cdn$ holding the price up