Welcome Guest

### NetConnect

#### Internet Domains, simple and cheap

##### Find a domain name:

Home

The time is now 10:23 am
You last visited July 28, 2014, 10:20 am
All times shown are
Eastern Time (GMT-5:00)

• JADELottery's Blog has 3,245 entries (81 private) and has been viewed 7,304,532 times.
• JADELottery is a Platinum member

## July 26, 2014, 2:47 pmRelativistic Market Regression Excel Examination

You can download our Excel sheet with the Relativistic Market Data and Regression measurements at our FTP site.

If you don't want to run the Macro Enabled file, here are the two functions we added to get the job done.

______________________________________________________________________________________________________________

Function LineSlope(theRange As Range) As Double

Dim n, y_sum, y_avg, xy_sum, xy_avg As Double

n = theRange.Rows.Count: y_sum = 0: xy_sum = 0

On Error GoTo errorexit

If (n < 2) Or (theRange.Columns.Count > 1) Then

LineSlope = -4.94065645841247E-324

Else

For a = 1 To n

y_sum = y_sum + theRange.Cells(a, 1)
xy_sum = xy_sum + a * theRange.Cells(a, 1)

Next a

y_avg = y_sum / n: xy_avg = xy_sum / n

LineSlope = (12 * xy_avg - 6 * (n + 1) * y_avg) / ((n - 1) * (n + 1))

End If

Exit Function

errorexit:

LineSlope = -4.94065645841247E-324

End Function

______________________________________________________________________________________________________________

Function LineCorr(theRange As Range) As Double

Dim n, y_sum, y_avg, yy_sum, yy_avg, xy_sum, xy_avg As Double

n = theRange.Rows.Count: y_sum = 0: yy_sum = 0: xy_sum = 0

On Error GoTo errorexit

If (n < 2) Or (theRange.Columns.Count > 1) Then

LineCorr = -4.94065645841247E-324

Else

For a = 1 To n

y_sum = y_sum + theRange.Cells(a, 1)
yy_sum = yy_sum + theRange.Cells(a, 1) * theRange.Cells(a, 1)
xy_sum = xy_sum + a * theRange.Cells(a, 1)

Next a

y_avg = y_sum / n: yy_avg = yy_sum / n: xy_avg = xy_sum / n

LineCorr = 3 * (2 * xy_avg - (n + 1) * y_avg) * (2 * xy_avg - (n + 1) * y_avg) / ((n - 1) * (n + 1) * (yy_avg - y_avg * y_avg))

End If

Exit Function

errorexit:

LineCorr = -4.94065645841247E-324

End Function
______________________________________________________________________________________________________________

Last Edited: July 26, 2014, 2:47 pm

Entry #3,245

## July 26, 2014, 2:17 pmCalm Chaos in Market Madness.

Below are the Relativistic Market Data, One Market Year Slope and One Market Year Chaos charts for the S&P 500, NASDAQ and DOW.

One Market Year is about 271 market days and is used to calculate the previous one year of linear regression at each point in time.

As we can see, the slope and chaos tend to move above and below the Zero Line in a fairly regular pattern.

In the 1987 Crash, we see the green slope dove beyond zero and chaos spiked in the positive.

However, after the 1987 Crash, the slope rose and chaos spiked again.

Not a bad thing, it just means growth took over again.

Notice how before the 1987 Crash that chaos was negative throughout 1985, 1986 and most of 1987.

Something similar happened in the 1990 market correction.

The green slope and blue chaos lines work together in showing the one year market state at each point in time.

Now, let's look at where we were at in 2013 and through 2014.

Given the market slope is positive and chaos has been dancing around at low levels for nearly a year, the market is set explode.

It could be for the better, but if you don't even entertain the thought it could be for the worse, then there is an 'I told you so.' in your future.

Keep a Very Close Eye on the Markets.

We are.

Last Edited: July 26, 2014, 2:20 pm

Entry #3,244

## July 26, 2014, 11:51 amRegression a Matter of Chaos

When we talk about R-Squared Correlation, we're really looking at the level of chaos in the system.

How well the data fits a calculated line is important in understanding what's going on with the data.

Below is an example of data that fits very close to the line and will have an R2 value close to 1.

In terms of a chaos reading of 1 - 2R2, this makes it close to 1 - 2 (1)2 or 1 - 2 and is -1.

When the chaos reading is near +1, then the data can be though of as being very chaotic.

Below is an example of data not very close to the regression line.

Last Edited: July 26, 2014, 2:35 pm

Entry #3,243

## July 26, 2014, 11:19 amRegression Roller Coaster

The way we applied Linear Regression to our Relativistic Market data is kind of like a Roller Coaster ride.

The cars on the ride are connected in sequence and are only on a portion of the roller coaster at one point in time.

Instead of getting a regression reading of the whole ride, we just get the regression reading of the cars on the track.

We can make a running regression measurement of the cars as it moves along the tracks.

This allows us to see what's happening on the tracks for a small section of the ride at a certain point in time.

Below is a simple example.

Entry #3,242

## July 26, 2014, 10:25 amRendition on Regression

We posted the Linear Regression so we can explain the use on our Relativistic Market data.

The two parts we used are the: Slope and R-Squared Correlation.

These help in understanding the direction and chaos in the data.

The Slope is a measure of how slanted the data is on average.

If the Slope is +, then the overall data is sloping up from left to right, like this:  /

If the Slope is -, then the overall data is sloping down from left to right, like this:  \

Slope values close to 0 are an indication the overall data is flat, like this:  _

Keep in mind, it's on average, because the next measure, R-Squared Correlation, is actually a chaos reading; with a little massage of the value.

R-Squared Correlation tells us how close the data is to the regression line.

The closer the data is to the line, the closer to 1 the R-Squared value is.

Values closer to 0 means chaos.

Since we need a good measure of chaos that is positive and negative, we find a chaos measure with this expression: 1 - 2R2

Now, you'd think chaos would be a bad thing, but that's not the case here.

All this does is tells us how closely the data follows the line.

To get the goodness and badness of the data, you have to use both of these values together and place them in to proper context before making that determination.

In the Relative Market data case, positive slope and positive chaos is market growth.

With negative slope and positive chaos, it could be an indication of market decline.

Relativistic Market data that has a slope near zero and any positive/negative chaos is an indication the market is not going anywhere fast.

We'll see how this works in another post and see why we are concerned about what is happening in the market.

Entry #3,241

## July 26, 2014, 1:52 amInside the Eye of the Market Hurricane...

Inside the Eye of the Market Hurricane since about the end of 2012 and clear inside at about 2013 June time frame.

This is a very strange and calmed chaos.

It almost looks like the market is being heavily controlled.

Like there's a delay in the crash or something... weird.

It was a Category 5 when we entered, but it's building up before we hit the Storm Wall again.

Indications are it'll be a Category 10 when it's done with US.

Watch carefully.

It will be quick, sudden; without warning and most of all, by design.

The Linear Regression we posted... ah, yes... there is something... hmm.

Last Edited: July 26, 2014, 2:05 am

Entry #3,240

## July 25, 2014, 11:58 pmWe Regress Before the Post

Linear Regression

Data

Data Averages

Linear Equation

Slope

Intercept

R-Squared Correlation

For Regular Interval Data

Slope

Intercept

R-Squared Correlation

Entry #3,239

## July 22, 2014, 7:31 amSnagged a Hamm's Last Night

Picked up a very nice old Hamm's Beer sign yesterday for my bar.

It's that water ripply one I remember as a kid.

Some photos from the person that sold it to me.

Entry #3,238

## July 13, 2014, 4:12 pmI Noticed Something on My Forehead Yesterday.

It appears to be a Third EYE.

Looks more defined in the mirror than in the picture and in better lighting.

Entry #3,237

## July 13, 2014, 12:49 pmRun! The Truth is Coming!

http://www.infowars.com/global-warming-coldest-antarctic-june-ever-recorded/

And it's going to get even colder.

Wait till this winter.

We have a chilling surprise in store for you CO2 Bigots.

Entry #3,236

## July 3, 2014, 11:32 amPictures from Our Trip to Lac du Flambeau, WI and The Chequamegon National Forest

Pictures from Our Trip to Lac du Flambeau, WI and The Chequamegon National Forest

The Bear River near the Old Indian Village.
On the left, back in the woods, are the Lac du Flambeau Pow-Wow grounds.
Picture taken on what we call 1st Bridge.
It's one of 3 bridges that cross over the Bear River.

A marshy water area further down the road past 2nd Bridge.

The Bear River out at 3rd Bridge.

A marshy area heading back from 3rd Bridge to Hwy 47.

Big Thunder Rd. looking E.
On the left side from where I'm standing to a little past our Trailblazer on the road is our property.

We went to check on the pine tree we planted way back in the forest several years ago.

Some interesting mushrooms grown on a tree nearby.

There's a black bug living on the mushroom.

An old logging trail back on our land.

Some pictures of the forest.

Big Thunder Rd. looking W and property on the right.

On the left side of the road is a large ditch line with patch of wild flowers growing.

Ooo! Purdee!

Some boulders along side the road marks our property line to the left.
Ann likes the colors on the rock.

Covered Bridge in the Chequamegon National Forest on Smith Rapids Rd.

Covered Walk Bridge in Stone Lake, WI

Entry #3,235

## June 28, 2014, 5:33 pmAt the Casino.

Gonna hit the Blackjack tables soon.

Maybe a little Craps and/or Roulette later.

Entry #3,234

Entry #3,233

Entry #3,232

## June 25, 2014, 4:42 pmBeen telling Ann about My Childhood.

Told her about the time I was hospitalized because my dad thought is was crazy.

I remember being at Milwaukee Children's Hospital, I think.

My mother would come and visit me in the room with all the other children.

I remember being given what I think was Electric Shock Treatments.

They would lay me down some kind of padded table and put something in my mouth with a tube so I could breath.

Then they wet my head with something and placed a thing on both sides of my head.

Bzzzzz.... It would go blank for a while.

The only thing I got out of it was IT - PISSED - ME - OFF!!!

Later on after I was released, I had to visit with a school psychiatrist.

I remember him giving me a series of tests.

One of those tests I've thought about since then.

The guy filled a glass with some water and asked me, "How much is in the glass?"

Puzzled, he asked, "What do you mean it's full? There's only so much water in the glass."

I replied back, "It's full."

I explained, "It's full of water and it's full of air."

The guy asked, "How do you know it's air?"

I grabbed his hand and blew on it and said, "Feel that? That's Air."

Not sure how old I was, must have been less then 10 years old.

Last Edited: June 25, 2014, 5:01 pm

Entry #3,231