|
PureBytes Links
Trading Reference Links
|
<x-html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.3825.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>
<DIV><STRONG><FONT size=2>MSK <EM><U>Formula</U> </EM>FAQ's +
Tips</FONT></STRONG></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT color=#0000ff size=2><STRONG>Q5. </STRONG></FONT><FONT
color=#0000ff><FONT color=#000000 size=2>Are there formulas/separate
formulas that measure </FONT></FONT><FONT color=#0000ff><FONT color=#000000
size=2>price movement for:</FONT></FONT></DIV>
<DIV><FONT color=#0000ff><FONT color=#000000
size=2> each trade day of the week, each
trading week of the month and each trading month of the year
?</FONT></FONT></DIV>
<DIV><FONT color=#0000ff><FONT color=#000000 size=2></FONT></FONT> </DIV>
<DIV><FONT color=#0000ff><FONT color=#000000
size=2> The intention here is to measure reative
trading activity as it relates to time intervals</FONT></FONT></DIV>
<DIV><FONT color=#0000ff><FONT color=#000000
size=2> (specific days,weeks,and months of the
year). Doesn't really matter what the activity criteria
is</FONT></FONT></DIV>
<DIV><FONT color=#0000ff><FONT color=#000000 size=2>
as I want to simply use the framework of whatever has been built as a
base from which to build a<BR> series of
composite indicators.</FONT></FONT><FONT size=2></DIV></DIV></FONT>
<DIV><FONT
size=2>=================================================<BR><STRONG>Performance,
1 Year's ROC - Ton Maas</STRONG></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Eploration Editor Notes:<BR>{ROC last 250 days period -
Exploration of Relative Strength or also known as the
period's<BR> Performance, incl. a ranking comparising}</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>FORMULA:<BR>ROC(C,250,%)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>SCAN<BR>in Metastocks' Explorer configure the Scan as
follows:<BR>column A formula : C<BR>column B formula : Ref(C,-250)<BR>column C
formula : ROC(C,250,%)<BR>column A name= Close<BR>column B name=
C1yr-ago<BR>column C name= Volatil<BR>Filter : ROC(C,250,%)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>USE ALSO<BR>-Above mentioned Scan-configure
options<BR>-Explorer's main window, choose: OPTIONS / LOAD min. 300
periods<BR>-Explorer's Editor's main window, choose: OPTIONS / most recent date
/ daily data<BR>-Explorer Report's Ranking Ability, done by using the
SORT-button (or column-bar at the top)<BR>-Explorer Report, Copy Results : right
click to Copy report to Excel or Word(Wordpad/NotePad) <BR>-Explorer Report,
Save Results : right click to Save report to file on disk<BR>-Explorer Report,
Print Results, click the
Print-button:<BR>
-print to file(Win95-Text-generic printer/Win95-PowerToys95-HTML-printer)
or<BR> -print to
plain paper(Default-printer)</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>NOTE<BR>-250 is the approx. "Exchange-working" days in a one
year time period<BR>-Data errors and folder's "dead" stock will appear as
rejects and lowest performers.<BR>-If you had a crash before or did an
incomplete programs' shutdown , then anoying 'no-access'<BR> files are
beiing put in your sec-folders(4x files, all starting with the ~ digit)
which<BR> files will have to be deleted first!!!!!!<BR>-Composites held in
the to be scanned folders disrupt the reliability of reports' outputs;<BR>and
while scanning can cause the program to
crash.<BR>=================================================<BR><STRONG>Performance,
statistical - Ton Maas</STRONG></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Eploration Editor Notes:<BR>{ROC of a full month's period -
Exploration of a period's Relative Strength or Performance,<BR> incl. a
ranking comparising}<BR> <BR>FORMULA:<BR>{a Period's statistical
performance. The default<BR>month for the 'measured period' is set to<BR>January
2000. Default can always be manualy<BR>changed, f.e. nescessary when first
and/or last<BR>dates in a Calander-month do not match Exchange<BR>data present
in MSK Data Files. Use the Scan in<BR>the Explorer for a list of Outperformers
in that<BR>month, ranked by Performance(in %).}<BR>Day1:=Input("Start
Day",1,31,30);<BR>Month1:=Input("Start Month",1,12,12);<BR>Year1:=Input("Start
Year",1900,2200,1999);<BR>Day2:=Input("End Day",1,31,31);<BR>Month2:=Input("End
Month",1,12,1);<BR>Year2:=Input("End
Year",1900,2200,2000);<BR>PdsStart:=(DayOfMonth()=Day1)+(Month()=Month1)+<BR>
(Year()=Year1);<BR>PdsEnd:=(DayOfMonth()=Day2)+(Month()=Month2)+<BR>
(Year()=Year2);<BR>ValStart:=ValueWhen(1,PdsStart=3,C);<BR>ValEnd:=ValueWhen(1,PdsEnd=3,C);<BR>PerfChange:=(ValEnd-ValStart)/(ValStart*0.01);<BR>PerfChange</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>SCAN<BR><U>column A formula :<BR></U>Day1:=Input("Start
Day",1,31,30);<BR>Month1:=Input("Start Month",1,12,12);<BR>Year1:=Input("Start
Year",1900,2200,1999);<BR>PdsStart:=(DayOfMonth()=Day1)+(Month()=Month1)+<BR>
(Year()=Year1);<BR>ValueWhen(1,PdsStart=3,C)<BR><U>column B formula
:</U><BR>Day2:=Input("End Day",1,31,31);<BR>Month2:=Input("End
Month",1,12,1);<BR>Year2:=Input("End
Year",1900,2200,2000);<BR>PdsEnd:=(DayOfMonth()=Day2)+(Month()=Month2)+<BR>
(Year()=Year2);<BR>ValueWhen(1,PdsEnd=3,C)<BR><U>column C formula
:<BR></U>Day1:=Input("Start Day",1,31,30);<BR>Month1:=Input("Start
Month",1,12,12);<BR>Year1:=Input("Start
Year",1900,2200,1999);<BR>Day2:=Input("End Day",1,31,31);<BR>Month2:=Input("End
Month",1,12,1);<BR>Year2:=Input("End
Year",1900,2200,2000);<BR>PdsStart:=(DayOfMonth()=Day1)+(Month()=Month1)+<BR>
(Year()=Year1);<BR>PdsEnd:=(DayOfMonth()=Day2)+(Month()=Month2)+<BR>
(Year()=Year2);<BR>ValStart:=ValueWhen(1,PdsStart=3,C);<BR>ValEnd:=ValueWhen(1,PdsEnd=3,C);<BR>(ValEnd-ValStart)/(ValStart*0.01)<BR><U>column
D formula :</U><BR>Day1:=Input("Start Day",1,31,30);<BR>Month1:=Input("Start
Month",1,12,12);<BR>Year1:=Input("Start
Year",1900,2200,1999);<BR>Day2:=Input("End Day",1,31,31);<BR>Month2:=Input("End
Month",1,12,1);<BR>Year2:=Input("End
Year",1900,2200,2000);<BR>PdsStart:=(DayOfMonth()=Day1)+(Month()=Month1)+<BR>
(Year()=Year1);<BR>PdsEnd:=(DayOfMonth()=Day2)+(Month()=Month2)+<BR>
(Year()=Year2);<BR>ValStart:=ValueWhen(1,PdsStart=3,C);<BR>ValEnd:=ValueWhen(1,PdsEnd=3,C);<BR>(ValEnd-ValStart)<BR><U>column
A name</U>= Start-C<BR><U>column B name</U>= End-C<BR><U>column C name</U>=
Perf-%<BR><U>column D name</U>= Perf-$<BR>Filter :
(ValEnd-ValStart)/(ValStart*0.01)<BR>=================================================</FONT></DIV>
<DIV><BR><FONT size=2>Regards,<BR>Ton Maas<BR></FONT><A
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";><FONT
size=2>ms-irb@xxxxxxxxxxxxxxxx</FONT></A><BR><FONT size=2>Dismiss the ".nospam"
bit (including the dot) when replying.<BR>Homepage </FONT><A
href="http://home.planet.nl/~anthmaas";><FONT
size=2>http://home.planet.nl/~anthmaas</FONT></A></DIV></BODY></HTML>
</x-html>
|