Thursday, September 1, 2011

Making of a Spreadsheet








Note - 948pm EST an error was fixed on the code below. All good to go now


STEPS TO MAKE THE SPREADSHEET BELOW:


-Insert Data. Date in column A Open, High, Low and Close in C,D,E,F for 100 periods. If you have them together then you can move one over or cut and paste as needed


COLUMN L1 - "MINIMUM"

COLUMN L2 - "MAXIMUM"

COLUMN L4 - "MAN LOW"

COLUMN L5 - "MAN HIGH"

COLUMN M1 - =IF((M4=0);MIN(C1:F100);M4)

COLUMN M2 - =IF((M5=0);MAX(C1:F100);M5)

COLUMN I1 - =(D1-E1)/E1

COPY AND PASTE I1 TO I100

COLUMN J18 - =(I18*18+I17*17+I16*16+I15*15+I14*14+I13*13+I12*12+I11*11+I10*10+I9*9+I8*8+I7*7+I6*6+I5*5+I4*4+I3*3+I2*2+I1)/171*3

OOLUMN K18 - =-((1*J18+1)-1)/(1*J18+1)

COLUMN N18 - =(F18*18+F17*17+F16*16+F15*15+F14*14+F13*13+F12*12+F11*11+F10*10+F9*9+F8*8+F7*7+F6*6+F5*5+F4*4+F3*3+F2*2+F1)/171

COLUMN O18 - =(E18*18+E17*17+E16*16+E15*15+E14*14+E13*13+E12*12+E11*11+E10*10+E9*9+E8*8+E7*7+E6*6+E5*5+E4*4+E3*3+E2*2+E1)/171

COLUMN P18 - =(D18*18+D17*17+D16*16+D15*15+D14*14+D13*13+D12*12+D11*11+D10*10+D9*9+D8*8+D7*7+D6*6+D5*5+D4*4+D3*3+D2*2+D1)/171

COLUMN L18 - =O18*K18+O18

COLUMN M18 - =P18*J18+P18

COLUMN Q18 - =(M2/M1)^0.382*M1

COLUMN R18 - =(M2/M1)^0.618*M1

COLUMN Q19 - =Q18

COLUMN R19 - =R18


Copy and Paste Q19.R20 down to 100

Copy and Paste L18.P18 down to 100


You are done and can make the spreadsheet with the candle being C18.F100 and the indicators being L18.R100

No comments:

Post a Comment