Excel WorkSheet - Computes Pivot Levels - Classic Formula

Quote from efficiency:

Up to date? Naw, numbers are numbers.

(HLOO) would be Woodie's, but that's unconsequential.

What I'm suggesting is that the close and the open, both contrived by the ax, serve different purposes for him.

The close, the most watched number by the majority of participants, is used to influence. To me, a bookkeeping entry. Strong close closes imply strong opens. From there, it's in accordance with the ax's agenda. Some gap up's carry through. Some fade.

The open, is not to influence, but........to maneuver. True movement. Not noise. And, anyone without a position, misses that movement. In some cases, in too late. Mouse takes the cheese.

HLOO, eliminates the close and double weights the maneuever. Make sense?

That aside, do pivots "work"? Wouldn't call it probability. More like expectation. IMO, they don't. Particularly on those coveted trend days. But, it's always good to have a guideline.
More...
When you mention The AX... i would gather we are probably talking stocks...

I have never used pivots on stocks... only liquid index markets...

and i agree i only watch Pivots with a confluence of other aspects to exit, enter or hold a trade...

I wonder what percentage of traders use pivots on liquid stocks... I hope some stock traders will comment on that...


<img src="http://www.enflow.com/p.gif">
 
Updated Excel Sheet...

Includes Overnight Globex Pivot Only Calculation

Includes Yearly Floating Pivot Only Calculation...

<img src="http://www.enflow.com/p.gif">
 

Attachments

If you don't have Excel...........


http://www.nationalfutures.com/pivotcalculator.htm



also, I have an excel spreadsheet (can't remember where I got it, but I didnt create it)

that uses the Excel function, "CEILING" to
round the results to the nearest .25 for ES prices.


For example, in your cell B6 you have the formula:
=B7+(B3-B4) which returns the value, 1487.33

I change this to
=CEILING(B7+(B3-B4),0.25)

which returns the value 1487.5
 
Quote from Jaxon:

that uses the Excel function, "CEILING" to round the results to the nearest .25 for ES prices.

For example, in your cell B6 you have the formula:
=B7+(B3-B4) which returns the value, 1487.33

I change this to
=CEILING(B7+(B3-B4),0.25)

which returns the value 1487.5
More...

That's a very good point...

I manually round all my own pivot point calc results from .25 lower to even...as in 1444.25 goes to 1444.00...

and anything between 1444.25 and 1444.75 goes in as a pivot value of 1444.50...

and anything greater than xxxx.75 as the next round number up pivot... as in 1444.81 goes to 1445.00 rounded up...

I have done this for years and have noticed the floor and majority of traders use these xxxx.00 and xxxx.50 numbers more commonly and aggressively than the xxxx.25 and xxxx.75 pivot figures...

To make a long story short... i do not use xxxx.25 pivot values or xxxx.75 pivot values... only the xxxx.00 and xxxx.50 values...

works quite well...


<img src="http://www.enflow.com/p.gif">
 
You must log in or register to reply here.
Back
Top