Excel WorkSheet - Computes Pivot Levels using the classic formula... <img src="http://www.enflow.com/p.gif">

' TradersStudio(r) (C) 2004-2007 All Rights Reserved Sub IntraDayPivotSys() 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 Buy("R2BuyBreak",1,R2+getactiveminmove,Stop,Day) 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) If MarketPosition=-1 And TradesToday()<2 Then Buy("FailBuy",1,S1+getactiveminmove(),Stop,Day) ExitEOD("EndOfDay","",999) End Sub

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.

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">

The code is for TradersStudio. This is one of the demo with 5 minute S&P500 data we ship. If you want to find out more about TradersStudio http://www.tradersstudio.com/Overview/tabid/68/Default.aspx

"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.

..................... 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. Paladin... <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" >

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.