Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346
|
sunday was the last day of black powder season and it rained all dang day.... kinda bummed me out..... still a few weeks of bow season, but it ain’t the same..... bows are all right but you get more bang for your buck with rifles....
while sittin there poutin, i started wonderin just why do we use [color=darkblue:318514919d]cross(c,mov(c,10,s)) [/color] and such in explorations which only returns 1 and/or 0.... why the 1 and 0..... appears awfully arbitrary..... why not 57 and 33 or 9 and 27..... why 1 and 0 , true and false..... seems like a waste of metastocks power and data.... suppose we wanted more bang for our buck.....
suppose we wanted to in one column return results for not only [color=darkblue:318514919d]cross(c,mov(c,10,s))[/color] but also [color=darkblue:318514919d]cross(c,mov(c,20,s)), cross(c,mov(c,30,s))[/color] and maybe also [color=darkblue:318514919d]cross(mov(c,10,s),c) , cross(mov(c,20,s),c) , cross(mov(c,30,s),c) [/color] and more..... all in one column..... maybe apply the same line of thinking with stoch , rsi, willr and so on each in its on column...... using 1 and 0 ain’t gonna get it.....
could we use something like [color=darkblue:318514919d]if(cross(c,mov(c,10,s),10,0))[/color] and [color=darkblue:318514919d]if(cross(mov(c,10,s),c),-10,0)[/color] ..... yes..... could we combine those.... yes.... [color=darkblue:318514919d]If(Cross(C,Mov(C,10,S)),10,If(Cross(Mov(C,10,S),c),-10,0) [/color]..... so now we can scan and return results in one column a 10 for those securities that crossed above the 10ma and a -10 for those that crossed below the 10ma..... we would just change all the 10's to a 20's for the results concerning the 20 ma.... can we combine the 10ma with the 20ma, can't see what's stopping us.... in column b use the same line of thinking for stoch, column c rsi and so on.....
the rest should be self-evident..... the exploration below returns all the values for the s&p 600 in 36 seconds..... that exploration was a rough draft and should be improved upon....
my mind wandered to several posts by members referring to “my clients”..... what follows here will have to be for another day, but briefly, if we were to scan the metastock’s data folder ”stocks grouped by sectors” using something similar to below then export those results into excel, it would be possible to graph the entire folder broken down by not those individual results, but also by the sector and industry.... the exploration below, admittedly abit of overkill, took exactly 4 minutes to run on the 7005 securities in the MetaStock Data\\Stocks Grouped by Sector.... those with clients could prepare some pretty neat graphs of the market broken down to the industrys themselves..... the excel template could be used over and over...... will post an example later....
so what's left for the hayseed's without client's..... hey , the white perch are fixin to start bitin anyday now......h
[code:1:318514919d]
Exploration notes
Col A: mov av If(Cross(C,Mov(C,5,S)),5,If(Cross(Mov(C,5,S),C),-5,If(Cros
s(C,Mov(C,10,S)),10,If(Cross(Mov(C,10,S),C),-10,If(Cross
(C,Mov(C,20,S)),20,If(Cross(Mov(C,20,S),C),-20,If(Cross(
C,Mov(C,26,S)),26,If(Cross(Mov(C,26,S),C),-26,If(Cross(
C,Mov(C,30,S)),30,If(Cross(Mov(C,30,S),C),-30,If(Cross(
C,Mov(C,50,S)),50,If(Cross(Mov(C,50,S),C),-50,0))))))))))))
Col B: rsi If(Cross(RSI(14),10),10,If(Cross(RSI(14),20),20,If(Cross(
RSI(14),30),30,If(Cross(RSI(14),40),40,If(Cross(RSI(14),5
0),50,If(Cross(RSI(14),60),60,If(Cross(RSI(14),70),70,If(C
ross(RSI(14),80),80,If(Cross(RSI(14),90),90,If(Cross(10,R
SI(14)),-10,If(Cross(20,RSI(14)),-20,If(Cross(30,RSI(14)),-
30,If(Cross(40,RSI(14)),-40,If(Cross(50,RSI(14)),-50,If(Cr
oss(60,RSI(14)),-60,If(Cross(70,RSI(14)),-70,If(Cross(80,
RSI(14)),-80,If(Cross(90,RSI(14)),-90,0))))))))))))))))))
Col C: stoch5,3 If(Cross(Stoch(5,3),10),10,If(Cross(Stoch(5,3),20),20,If(Cr
oss(Stoch(5,3),30),30,If(Cross(Stoch(5,3),40),40,If(Cross(
Stoch(5,3),50),50,If(Cross(Stoch(5,3),60),60,If(Cross(Sto
ch(5,3),70),70,If(Cross(Stoch(5,3),80),80,If(Cross(Stoch(
5,3),90),90,If(Cross(10,Stoch(5,3)),-10,If(Cross(20,Stoch(
5,3)),-20,If(Cross(30,Stoch(5,3)),-30,If(Cross(40,Stoch(5,
3)),-40,If(Cross(50,Stoch(5,3)),-50,If(Cross(60,Stoch(5,3))
,-60,If(Cross(70,Stoch(5,3)),-70,If(Cross(80,Stoch(5,3)),-8
0,If(Cross(90,Stoch(5,3)),-90,0))))))))))))))))))
Col D: will 14 If(Cross(WillR(14),-10),-10,If(Cross(WillR(14),-20),-20,If(Cr
oss(WillR(14),-30),-30,If(Cross(WillR(14),-40),-40,If(Cross(
WillR(14),-50),-50,If(Cross(WillR(14),-60),-60,If(Cross(Will
R(14),-70),-70,If(Cross(WillR(14),-80),-80,If(Cross(WillR(1
4),-90),-90,If(Cross(-10,WillR(14)),10,If(Cross(-20,WillR(1
4)),20,If(Cross(-30,WillR(14)),30,If(Cross(-40,WillR(14)),4
0,If(Cross(-50,WillR(14)),50,If(Cross(-60,WillR(14)),60,If(C
ross(-70,WillR(14)),70,If(Cross(-80,WillR(14)),80,If(Cross(-
90,WillR(14)),90,0))))))))))))))))))
Filter colA OR colB or colc or cold
Filter enabled Yes
Periodicity Daily
Records required 4000[/code:1:318514919d]
|
