Excel WorkSheet - Computes Pivot Levels - Classic Formula

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

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

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

    Murray Ruggiero ET Sponsor

    ' 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
     
  3. 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">
     
  4. Murray Ruggiero

    Murray Ruggiero ET Sponsor

    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. excuse my ignorance, but how do you use thcode with the excel spreadsheet???
     
  6. 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">
     
  7. Murray Ruggiero

    Murray Ruggiero ET Sponsor

    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
     
  8. "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. ..................... :D

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