General Topics
Markets
Technical Topics
Brokerage Firms
Company Specific
Community Lounge
Site Support

# Excel WorkSheet - Computes Pivot Levels - Classic Formula

Discussion in 'Technical Analysis' started by EdgeHunter, Nov 22, 2007.

1. ### EdgeHunter

Excel WorkSheet - Computes Pivot Levels using the classic formula...

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

• ###### pivots.xls
File size:
17 KB
Views:
1,698

Dim YestOpen As BarArray
Dim YestHigh As BarArray
Dim YestLow As BarArray
Dim YestClose As BarArray
Dim S1 As BarArray
Dim S2 As BarArray
Dim R1 As BarArray
Dim R2 As BarArray
Dim MidPoint As BarArray
YestOpen=OpenD
YestHigh=HighD
YestLow=LowD
YestClose=CloseD
MidPoint=(YestHigh+YestLow+YestClose)/3
R1=(2*MidPoint)-YestLow
S1=(2*MidPoint)-YestHigh
R2=MidPoint+R1-S1
S2=MidPoint+S1-R1
If Time<TimeSerial(15,0, 0) And TradesToday()<2 Then Sell("S2SellBreak",1,S2-getactiveminmove,Stop,Day)
If MarketPosition=1 And TradesToday()<2 Then Sell("FailSell",1,R1-getactiveminmove(),Stop,Day)
ExitEOD("EndOfDay","",999)
End Sub

3. ### EdgeHunter

Hi Murray,

Thank you for posting the Free Code...

Could you share a little explanation of what its Pivot Point Calculation does or is it a system that works with PP's or?

thanks...

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

This is a trading system which uses the standard pivot point calculations. It includes the breakout of R2,S2 and the reversal failure trade at R1,S1. It exits all trades at the end of the day.

5. ### enochbenjamin

excuse my ignorance, but how do you use thcode with the excel spreadsheet???

6. ### EdgeHunter

Murray is pointing out another way of auto creating Pivot Points along with an auto trading strategy that his software application will provide...

His code sample is not connected with the attached sample excel spreadsheet that allows anyone to manually calculate Pivot Points on their own...

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

8. ### efficiency

"Have gun, will travel. Wire San Francisco."

Classic pivots, using (H+L+C) in the computation(s) disregards "today's" action. Namely, where the specialist/market maker opens the issue.

You might consider (H+L+O+O), thus blending yesterday with today and..........providing double weight to today's open. Why? "He" chose that price point. A synthetic point. In theory to clean out the most open orders. In reality, to manuever. Either away from his basis or to attract order flow. In the case of an ETF or derivative, a composite of a helluva lot of "opens"

Incidently, the open is the one price point that ALL participants get, if they so choose.

9. ### EdgeHunter

.....................

Right, this is the Classic formula...

There is also the Woodie Formula, the Camarilla Formula and the DeMark Formula for Pivot Point calculations...

http://www.mypivots.com/dn/?symbol=41

I left anyone with the option to change the SpreadSheet's math - if one so wishes...

Maybe your formula... the Efficiency Formula is more up to date then the Classic... have to give it some thought... interesting.

<font size =2>"I don't think you got a very good look at this gun while you had it. The balance is perfect.<br> This trigger responds to a pressure of one ounce. If you look carefully in the barrel you'll<br>see the lines of the rifling. It's a rarity in a hand weapon. This gun was handcrafted to my<br>specifications and I rarely draw it unless I mean to use it. <br><br>Would you care for a demonstration?"</font size>

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

10. ### 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.

#10     Nov 25, 2007
ET IS FREE FOR TRADERS BECAUSE OF THE FINANCIAL SUPPORT FROM THESE SPONSORS: