Here is this month's selection of Traders' Tips, contributed by various developers of technical analysis software to help readers more easily implement some of the strategies presented in this issue.You can copy these formulas and programs for easy use in your spreadsheet or analysis software. Simply "select" the desired text by highlighting as you would in any word processing program, then use your standard key command for copy or choose "copy" from the browser menu. The copied text can then be "pasted" into any open spreadsheet or other software by selecting an insertion point and executing a paste command. By toggling back and forth between an application window and the open Web page, data can be transferred with ease.
This month's tips include formulas and programs for:
TRADESTATION / SUPERCHARTS
METASTOCK
TECHNIFILTER PLUS
WAVEWI$E MARKET SPREADSHEET
SMARTRADERor return to August 1998 Contents
Here's the Easy Language code for my article "From technical terms to technical tools."
Function Name: FearPobcOscInputs: Price(Numeric), Length(Numeric), Level(Numeric);Vars: AvgAvgs(0), HiPrice(0), LoPrice(0), AvgVal(0);Array: MPAvg[10](0);AvgAvgs = 0;MPAvg[1] = MidPoint(Price,Length);MPAvg[2] = MidPoint(MPAvg[1],Length);MPAvg[3] = MidPoint(MPAvg[2],Length);MPAvg[4] = MidPoint(MPAvg[3],Length);MPAvg[5] = MidPoint(MPAvg[4],Length);MPAvg[6] = MidPoint(MPAvg[5],Length);MPAvg[7] = MidPoint(MPAvg[6],Length);MPAvg[8] = MidPoint(MPAvg[7],Length);MPAvg[9] = MidPoint(MPAvg[8],Length);MPAvg[10] = MidPoint(MPAvg[9],Length);HiPrice = Highest(Price,Level);LoPrice = Lowest(Price,Level);For value1 = 1 to Level beginAvgAvgs = AvgAvgs + MPAvg[value1];End;AvgVal = AvgAvgs/Level;IF HiPrice - LoPrice <> 0 ThenFearPobcOsc = 100*((Close - AvgVal) / (HiPrice - LoPrice));Indicator Name: Point of Balance CloseInputs: Price(close),Len(12), Level(10);Vars: PosNeg(0);If CurrentBar > Len*Level Then BeginPosNeg = FearPobcOsc(Price,Len,Level);If PosNeg > 0 ThenPlot1(PosNeg,"FearOsc")ElsePlot2(PosNeg,"FearOsc");End;GO BACK--Walter Downs, Internet: https://cistrader.com
E-mail: knight@cyberspy.com
In Walter Downs's article "From technical terms to technical tools," he introduces the point of balance oscillator, two conditions to color bars and two system tests. All of these can be created quite easily in MetaStock 6.5. To create the point of balance oscillator, choose Indicator Builder from the Tools menu, click on the New button, and enter the following formula:Point of Balance Oscillator
n := Input("Time Periods",1,100,12)/2;
POBC1 := (HHV(CLOSE, n) + LLV(CLOSE,n))/2;
POBC2 := (HHV(POBC1, n) + LLV(POBC1,n))/2;
POBC3 := (HHV(POBC2, n) + LLV(POBC2,n))/2;
POBC4 := (HHV(POBC3, n) + LLV(POBC3,n))/2;
POBC5 := (HHV(POBC4, n) + LLV(POBC4,n))/2;
POBC6 := (HHV(POBC5, n) + LLV(POBC5,n))/2;
POBC7 := (HHV(POBC6, n) + LLV(POBC6,n))/2;
POBC8 := (HHV(POBC7, n) + LLV(POBC7,n))/2;
POBC9 := (HHV(POBC8, n) + LLV(POBC8,n))/2;
POBC10 := (HHV(POBC1, 9) + LLV(POBC1,9))/2;
AV: = (POBC1 + POBC2 + POBC3 + POBC4 + POBC5 + POBC6 + POBC7 + POBC8 + POBC9 + POBC10) / 10;
POBCOsc := 100 * ((CLOSE - AV) / (HHV(CLOSE, 10)-LLV(CLOSE, 10)));
POBCOsc
To highlight bars based on the bull fear and bear fear conditions discussed in the article, choose Expert Advisor from the Tools menu, click on the New button and enter the following expert:
Bull Fear and Bear Fear Expert
BullFear := (HHV(HIGH,n) - LLV(HIGH,n))/2 + LLV(HIGH,n);HightlightsName: Bull Fear
Condition:
n := 12 {Time periods};
CLOSE > BullFear
BearFear := (HHV(LOW,n) - LLV(LOW,n))/2 + LLV(LOW,n);Color: BlueName: Bear Fear
Condition:
n := 12 {Time periods};
CLOSE < BearFear
Color: Red
To test the two systems discussed, choose System Tester from the Tools menu and enter both of the following systems:
Bull and Bear Fear System Test
Signal Formulas
--------------
Enter Long:
n := 12 {Time periods};
BullFear := (HHV(HIGH,n) - LLV(HIGH,n))/2 + LLV(HIGH,n);
Cross(CLOSE,BullFear)
Enter Short:
n := 12 {Time periods};
BearFear := (HHV(LOW,n) - LLV(LOW,n))/2 + LLV(LOW,n);
Cross(BearFear,CLOSE)
Four-Bar Fear System Test
Signal Formulas
--------------
Enter Long:
n := 12 {Time periods};
BullFear := (HHV(HIGH,n) - LLV(HIGH,n))/2 + LLV(HIGH,n);
BearFear := (HHV(LOW,n) - LLV(LOW,n))/2 + LLV(LOW,n);
Cross(CLOSE,BullFear) AND Ref(Sum(CLOSE < BullFear AND CLOSE > BearFear,4),-1) = 4
Close Long: LOW < Ref(LLV(LOW,3),-1)
Enter Short:
n := 12 {Time periods};
BullFear := (HHV(HIGH,n) - LLV(HIGH,n))/2 + LLV(HIGH,n);
BearFear := (HHV(LOW,n) - LLV(LOW,n))/2 + LLV(LOW,n);
Cross(BearFear,CLOSE) AND Ref(Sum(CLOSE < BullFear AND CLOSE > BearFear,4),-1) = 4
Close Short: HIGH < Ref(HHV(HIGH,3),-1)
After entering the systems, click on the Options button in the System Tester dialog, go to the Testing tab and change the trade price to open and set the trade delay to 1.
GO BACK--Allan J. McNichol, EQUIS International
800 882-3040, 801 265-8886
Internet: https://www.equis.com
Here are the TechniFilter Plus formulas that implement the indicators discussed in Walter Downs's article this month, on trading using a point of balance system.The first formula, POBC_Osc, is a multiline formula that computes Downs's POBC oscillator. It successively takes the maximum and minimum of the previously computed line to compute 10 values of POBC in lines 1-10. Line 11 adds up the first 10 lines, and line 12 does the oscillator calculation. The next two formulas calculate the bull fear level (POBC_BLF) and the bear fear level (POBC_BRF). Finally, the last formula computes the point of balance, POBC_POB.
NAME: POBC_OscThis TechniFilter Plus strategy and the reports, strategies and formulas of earlier Traders' Tips can be downloaded from RTR's Web site.SWITCHES: multiline
PARAMETERS: 12
FORMULA: [1]: (CM&1 - CN&1)/2 {POBC1}
[2]: ([1]M&1+[1]N&1)/2 {POBC2}NAME: POBC_BLF[3]: ([2]M&1+[2]N&1)/2 {POBC3}
[4]: ([3]M&1+[3]N&1)/2 {POBC4}
[5]: ([4]M&1+[4]N&1)/2 {POBC5}
[6]: ([5]M&1+[5]N&1)/2 {POBC6}
[7]: ([6]M&1+[6]N&1)/2 {POBC7}
[8]: ([7]M&1+[7]N&1)/2 {POBC8}
[9]: ([8]M&1+[8]N&1)/2 {POBC9}
[10]: ([9]M&1-[9]N&1)/2 {POBC10}
[11]: ([1]+[2]+[3]+[4]+[5]+[6]+[7]+[8]+[9]+[10])/10
[12]: 100 * ((C-[11])/(CM&1-CN&1))
PARAMETERS: 12
FORMULA: (HN&1 + HM&1)/2
NAME: POBC_BRF
PARAMETERS: 12
FORMULA: (LN&1 + LM&1)/2
NAME: POBC_POB
PARAMETERS: 12
FORMULA: (POBC_BLF(&1)+POBC_BRF(&1))/2
GO BACK-- Clay Burch, RTR Software
919 510-0608, E-mail: rtrsoft@aol.com
Internet: https://www.rtrsoftware.com
These Wave Wi$e spreadsheet formulas implement Walter Downs's point of balance system.WAVE WI$E spreadsheet formulasA: DATE @TC2000(C:\TC2000\DATA,SP-500,STANDARD & POORS 500,DB)
B: HIGH
C: LOW
D: CLOSE
E: OPEN
F: VOL
G: NUMB 12 'Set to your desired lookback period
H: POBC1 (@MAX(CLOSE,NUMB+@MIN(CLOSE,NUMB)) /2
I: POBC2 (@MAX(POBC1,NUMB)+@MIN(POBC1,NUMB)) /2
J: POBC3 (@MAX(POBC2,NUMB)+@MIN(POBC2,NUMB)) /2
K: POBC4 (@MAX(POBC3,NUMB)+ @MIN(POBC3,NUMB)) /2
L: POBC5 (@MAX(POBC4,NUMB))+@MIN(POBC4,NUMB)) /2
M: POBC6 (@MAX(POBC5,NUMB) +@MIN(POBC5,NUMB)) /2
N: POBC7 (@MAX(POBC6,NUMB)+@MIN(POBC6,NUMB)) /2
O: POBC8 (@MAX(POBC7,NUMB)+@MIN(POBC7,NUMB)) /2
P: POBC9 (@MAX(POBC8,NUMB)+@MIN(POBC8,NUMB)) /2
Q: POBC10 (@MAX(POBC9,NUMB)+@MIN(POBC9,NUMB)) /2
R: Avsum (POBC1 + POBC2 + POBC3 + POBC4 + POBC5 + POBC6 + POBC7 +
POBC8 +POBC9+POBC10)/10
S: POBCosc 100*((CLOSE - AVSUM) / (@MAX(CLOSE,10) - @MIN(CLOSE,10)))
T: BLF ((@MAX(HIGH,NUMB) - @MIN(HIGH,NUMB))/2)+ @MIN(HIGH,NUMB)
U: BRF ((@MAX(LOW,NUMB) - @MIN(LOW,NUMB))/2)+ @MIN(LOW,NUMB)
V: POB ((BLF-BRF) /2) + BRF
W: Avg18 @MAVG(CLOSE,18)
X:
Y: chart @CHART(1)
Z:
==========End Formulas
GO BACK--Peter Di Girolamo, Jerome Technology
908 369-7503, E-mail: jtiware@aol.com
Internet: https://members.aol.com/jtiware
Construction of Walter Downs's point of balance system is lengthy but simple in SmarTrader.The SmarTrader specsheet showing the code is in Figure 1.
FIGURE 1: SMARTRADER. This SMARTrader SpecSheet implements Walt Downs's point of balance oscillator Data rows are omitted here for brevity. Row 9 is a coefficient containing the n value of 12, used in the article. It's used instead of a number so that various n values may be tested without the need to change the value in numerous places. Row 10 uses the highest function to determine the highest close in n periods. Row 11 uses the lowest function to determine the lowest close in n periods. Row 12 is a user row that calculates PBOC1. Rows 13 through 39 repeat this three-step process to determine PBOC2 through PBOC10.
Rows 40 and 41 are partial sums of the 10 PBOC values. This could be done in a single row but is split here for presentation. Row 42, AV, combines the partial sums into the total and divides the sum by 10.
Row 43 computes the PBOC oscillator. Rows 44 and 45 determine the highest and lowest high, respectively. Rows 46 and 47 determine the highest and lowest low. Rows 48 through 50 calculate the bull fear and bear fear and point of balance. Rows 51 and 52 are alarms to be used with the Smart bar plot to color the bull fear bars blue and bear fear bars red.
This system can also be implemented using CompuTrac SNAP. This specsheet file is available from Stratagem Software's Web site.
GO BACK--Jim Ritter, Stratagem Software International
504 885-7353, E-mail: Stratagem1@aol.com
Internet: https://members.aol.com/stratagem1