Metastock Formulas - A
Strona 1
Metastock Formulas - L
Click here to go back to Metastock Formula In
ex
Home
These formulas aren't my complete
IMPORTANT:
MetaStock Secrets
collectlon. For my complete collectlon of lnstantly usable,
Free MS Newsletter
profltable and powerful MetaStock formulas Cllck Here
Free MS Formula
Buy MetaStock
Buy MS Formulas
Would You Llke To Use MetaStock To Its Full Potentlal? Dlscover the
Amazlngly Slmple Secret to Master Metastock Step-By-Step - click here
FREE Vldeos
MS Back Testlng
A | A 1 | B | B 1 | C | C 1 | D | D 1 | E | F | G | H | I | J | K | L | M | M 1 | N
Tradlng Systems
| O | P | R | S | S 1 | T | U | V | W | Z |
Nlcolas Darvas
Linear Regression Slope LookBack
MetaStock Llnks
Linking Metastock Updates to Excel Files LRS-ROC Indicator--another one
Lone Ranger LSS Oscillator & Pivot Point
Rave Revlews
Linear Regression Trendline Last Date Exploration
About Us
Linear Regression Slope
Contact Us
{The basIc "programmIng" In MetaStock of the LRS-ROC IndIcator Is IIke thIs: NIO Is the _
SlteMap
basIc_ number of poInts taken to caIcuIate the ROCs. The four ROCs _per day_ used for
InterpoIatIon are:}
rII:=ROC(O,nIo-1,%)/(nIo-1);
rI:=ROC(O,nIo,%)/nIo;
rh:=ROC(O,nIo+1,%)/(nIo+1);
rhh:=ROC(O,nIo+2,%)/(nIo+2);
{Now, InterpoIatIon Is done at a poInt XIO (0<=xIo<=1), I.e., between the poInts NIO and
NIO+1, usIng a sImpIe InterpoIatIon formuIa weIghtIng wIth the _dIstances_ of the four ROCs
from the InterpoIatIon poInt XIO:}
rIt:=(rII/(1+xIo)+rI/(xIo+.0001)+rh/(1-xIo)+rhh/(2-xIo))/(1/(1+xIo)+1/(xIo+.
0001)+1/(1-xIo)+1/(2-xIo));
{Then the LInearRegressIonSIope Is taken _twIce_ (for numerIcaI reasons) from the
InterpoIated ROC, usIng the basIc number of poInts; I.e., NIO. That Is where we get our
LRS-ROC IndIcator, named RO here:}
ro:=LInRegSIope(LInRegSIope(rIt,nIo),nIo);
{NIO+XIO together represent the _reaI_ (not Integer!) number of poInts or days, the LRS-
ROC IndIcator Is caIcuIated for, e.g. 4.57 days. UnfortunateIy, MetaStock Is not abIe to use _
one_ reaI number (e.g., 4.57) as Input to be spIItted Into NIO and XIO and to be used In the
formuIas above. So NIO and XIO have to be provIded separateIy, because of the restrIctIons
In MetaStock, and both are subjected to some "optImIzatIon" In accordance to the hIstorIcaI
prIces.
To be cIear: ThIs LRS-ROC IndIcator trIggers _onIy the tImIng_ for enterIng/cIosIng a
posItIon, usIng an approprIate crIterIon. AddItIonaI (aIso ROC-based) crIterIons are used to
stay out/In durIng extreme bearIsh/buIIIsh sItuatIons.
AddItIonaIIy: ThIs "TA" Is onIy one basIc eIement of my optIon tradIng system, prImarIIy to
catch some "specIaI reaIIty effects" that cannot be modeIed by exampIe-based know-how
recycIIng from hIstorIcaI data. But probabIy thIs TA system may aIso be used as a "stand-
aIone" system.
(Go Top)
Linking Metastock Updates to Excel Files
As I understand your desIre, It's to take data from a MetaStock fIIe and use It to update an
ExceI fIIe. The way to have thIs update-process automatIcaIIy done requIres for you to have
http://www.meta-formula.com/Metastock-Formulas-A
.html 2014-10-14 14:04:15
Metastock Formulas - A
Strona 2
an OLE-IInk capabIe object (chart or IndIcator) to be present. In MetaStock thIs can be easy
estabIIshed by creatIng separate Charts for each securIty. FoIIow and execute these steps
beIow. Here I am usIng a sIngIe daIIy cIosIng prIce as object, for a sImpIIfIed use of the WIn
95's OLE program.
1. FIrst make a new IndIcator CIose OnIy :
Start MetaStock and cIIck the button for the IndIcator BuIIder
In IndIcator BuIIder create a custom IndIcator named "CIose OnIy" (wIthout the
quotatIons) and In the formuIa fIeId type CLOSE and cIIck OK
2. To create a CIose OnIy TempIate :
Start the WIn95-ExpIorer and create a new foIder named OLE(whIch foIder wIII hoId
your TempIate and Charts used for thIs OLE) beIow your workIng foIder(that Is
hoIdIng your metastock fIIes dat/dop/master/emaster etc.)
Then swItch back to MetaStock
Open the by you desIred securIty usIng Smart Charts as type
DeIete aII other charts and aII Inner wIndows and aII IndIcators that are open In the
current screen(=Iayout) except for the base securItIes' PrIce IndIcator
(the bar, IIne, stIcks)
Drag the newIy created CIose OnIy IndIcator down from the IB-QuIck LIst (from the
smaII wIndow In the mIddIe at the top) and reIease It to have the newIy created
IndIcator dIspIayed In Its own Inner-wIndow
Now SAVE AS the current screen (wIth TempIate as the fIIe type) usIng the
CIoseOnIy name(wIthout a space) as the TempIate's name("CIoseOnIy.mwt")
CIose down MetaStock + WIn95-ExpIorer
3. To create the separate Charts used for OLE :
Start MetaStock (fresh agaIn) and cIIck New|Chart or cIIck Open
CIIck AppIy TempIate (thIs actIon Is aIways requIred prIor to seIectIng a securIty)
and scroII to the OLE foIder to appIy the newIy created CIoseOnIy TempIate
On OpenIng of thIs New Chart the above mentIoned TempIate's Iayout contaInIng the
PrIce and the CIose OnIy IndIcators wIII be dIspIayed
Now SAVE AS the current screen (wIth Chart as the fIIe type) usIng the securIty's
name as the Charts' poInter name("SecurItyX.mwc") to the newIy created OLE-foIder
CIose Metastock
4. To create the OLE IInk from Metastock to an ExceI spreadsheet :
Start MetaStock (fresh agaIn) and cIIck Open
Open the requIred securIty In the newIy created OLE-foIder
RIght-cIIck to SeIect and cIIck Copy to have the securIty's CIoseOnIy IndIcator copIed
to the CIIpboard
Start ExceI and check that the fIrst ceII at the top-Ieft Is been seIected(=bIack IIne
bordered rectangIe)
SeIect the requIred ceIIs by pIacIng the mouse-poInter at the rIght corner of the
seIected rectangIe and cIIck and press down the Left-mouse button and whIIst at the
same tIme hoIdIng the mouse-button down, drag down thIs fIrst coIumn(A) and
reIease button untII you have reached record row #999 and aII of the seIected ceIIs
wIII be coIered bIack(Note that thIs seIectIon made, has to be done In one(1)
straIght fIrm move down the coIumn, eg a one sIngIe seIectIon has been made)
Now Iet the mouse-poInter fIoat on thIs bIackened seIectIon and RIght-cIIck to
choose Paste SpecIaI
In the Paste SpecIaI's DIaIog WIndow cIIck the Paste LInk radIo-button and choose
CSV as fIIe-type
WIth pIenty of system memory on board It wIII not take that Iong before the SpecIaI
LInked data Is caIcuIated and dIspIayed (as the ceII's contents), and
that the LInk has been made
CIose and Save As the ExceI fIIe to the OLE foIder(wIth standard XLS as fIIe type)
wIth the securIty's name as the poInter name
Each tIme now, that you Open thIs XLS-fIIe agaIn, automatIcaIIy the ExceI program
wIII have you prompted If you wouId to update the LInk. WIthIn the ExceI program's
optIons (TooIs|OptIons|CaIcuIatIons or EdIt|LInk|ManuaI) you can pre-set thIs to
"manuaI" as weII, but then you wIII have to cIIck EdIt|LInk|Update Now to update
once the spreadsheet's above LInked ceII seIectIon entIreIy
A.
Note here that the more hIstory Is stored In your 'orIgInaI' Metastock fIIes, eg the fIIes the
Chart uses as Its base, the Ionger the coIumn contents(dIspIayed ceIIs), the Ionger It wIII
take to caIcuIate and aIso the more memory Is beIng used, so you wIII have to keep thIs
'hIstory' as short as what can be possIbIe for any fast resuIts.
B.
Note here too that you can then appIy the specIaI InstructIons (maIIed In a prevIous maII to
the LIst) to have the LInked ceIIs' contents SPLIT UP over more ceIIs In the spreadsheet(s),
so as to enabIe you to make caIcuIatIons In ExceI, eg usIng ExceI's ceII IInkIng(referencIng)
and formuIa Ianguage(the tIny edItor) capabIIItIes and/or appIy any of the other ExceI
program's features.
C.
Note here aIso that the above appIIes for MS6.x and ExceI8.0(OffIcePro97).
http://www.meta-formula.com/Metastock-Formulas-A
.html 2014-10-14 14:04:15
Metastock Formulas - A
Strona 3
D.
To reverse thIs OLE IInkage back Into MetaStock , do not forget to create an empty Inner
WIndow fIrst, prIor to creatIng the LInk. In MS cIIck WIndow|New Inner WIndow and then
RIght-cIIck In thIs Inner WIndow and choose Paste SpecIaI|Paste LInk (wIth CSV as fIIe type)
. See MS-HeIp or MS-ManuaI
or EquIs' Customer|Support WebsIte for more detaIIed InstructIons.
(Go Top)
Lone Ranger
ThIs Is the caIcuIatIon:
There are 2 caIcuIatIons needed for thIs.
For the fIrst, just take the hIghest vaIue of the cIose In the past 3 days (IncIudIng todays
cIose) and take thIs away from the Iowest vaIue of the cose In the past 3 days. CaII the
resuIt of thIs a.
Then dIvIde a by voIume. Subtract the resuIt of thIs by the vaIue of a dIvIded by voIume 5
days ago.
FInaIIy, muItIpIy thIs number by -1.
SImpIe InterpretatIon:
ThIs Is a short term IndIcator whIch wIII show short term dIvergences agaInst the market
Instrument. You can aIso use It to compare Its rate of change agaInst that of the market.
Extreme Iows or hIghs In the IndIcator may be a sIgnaI of sImIIar Instances In the market,
however you wouId want to defIne a tIme perIod to make use of thIs functIon.
Metastock code for Lone Ranger:
(( FmI( "Z Range" ) / V) - Ref((FmI( "Z Range" ) / V),-5)) * -1
Where FmI( "Z Range" ) = (HHV(c,3) - LLV(c,3))
(Go Top)
LRS-ROC Indicator--another one
Lb:=Input("Look-Back PerIods?",3,100,13);
ROC( LInRegSIope(C,Lb),Lb,$)
(Go Top)
LSS Oscillator & Pivot Point
Here are a few formula's that I picked up from a
mailing from George Angell
LSS 5 day Osc
X:=HHV(H,5)-Ref(O,-5);
Y:=C-LLV(L,5);
LSS:=100*(X+Y)/(HHV(H,5)-LLV(L,5))*2;
LSS;
LLS 5 DAY Osc DIff from 3 day osc
X:=HHV(H,5)-Ref(O,-5);
Y:=C-LLV(L,5);
LSS:=100*(X+Y)/(HHV(H,5)-LLV(L,5))*2;
DIff:=LSS-Ref(LSS,-3);
DIff;
LLS Strength Index(1 day)
100*(Ref(C,-1)-Ref(L,-1))/(Ref(H,-1)-Ref(L,-1))
LLS PIvot Breakout Buy Number
X:=(H+L+C)/3;
BBN:=2*X-L;
BSN:=2*X-H;
BBN;
BSN;
(Go Top)
LookBack
FormuIa: X := Stdev(C, 30);
Y := Ref(X, -1);
Z := 1+((X-Y)/X);
If(Cum(1)=1, 20, MIn(Max(Prev*Z, 20), 60))
Name: BuyBreak
FormuIa: HHV(H, LastVaIue(FmI("LookBack")+Prev-Prev))
Name: BuyExit
http://www.meta-formula.com/Metastock-Formulas-A
.html 2014-10-14 14:04:15
Metastock Formulas - A
Strona 4
FormuIa: LLV(L, LastVaIue(FmI("LookBack")/2+Prev-Prev))
Name: SellBreak
FormuIa: LLV(L, LastVaIue(FmI("LookBack")+Prev-Prev))
Name: SellExit
FormuIa: HHV(H, LastVaIue(FmI("LookBack")/2+Prev-Prev))
Name: BreakWhere
FormuIa: TopB := Ref(FmI("BuyBreak"), -1);
LowB := Ref(FmI("SeIIBreak"), -1);
((O+H+L+C)/4 - LowB)*100/(TopB-LowB);
Name: DBS-System
Enter Long: H > Ref(FmI("BuyBreak"), -1)
CIose Long: L < Ref(FmI("BuyExIt"), -1)
Enter Short: L < Ref(FmI("SeIIBreak"), -1)
CIose Short: H > Ref(FmI("SeIIExIt"), -1)
ThIs Is George PruItt's ("Futures Truth") basIc system. It Is aIso the basIc system used as the
basIs for Thomas StrIdsman's year-Iong serIes of artIcIes about system deveIopment and
tweakIng.
(Go Top)
Last Date Exploration
ThIs set of coIumn formuIae aIIows you to eIther scan the resuIts of a prevIous MetaStock
expIoratIon or the whoIe market to vIew the Iast tradIng date of each code.
To deIete aII securItIes that have been non-tradIng sInce a user specIfIed date, you wIII need
to use a program such as StockDeIete.
MetaStock Column Formula
{Day} Column A: Dayofmonth()
{Month} Column B: Month()
{Year} Column C: Year()
No fIIter Is requIred for thIs formuIa. Text In {} IndIcates the coIumn name (not requIred)
DownIoad the Last Date FormuIa for use In your MetaStock software by cIIckIng here.
(Go Top)
Linear Regression Trendline
{ LInear RegressIon TrendIIne ChanneI v2.0 }{ ©CopyrIght 2004 Jose SIIva }{ josesIIva22@
yahoo.com }
EnDay:=Input("end Day",1,31,31);
EnMnth:=Input("end Month",1,12,12);
EnYear:=Input("end Year",1800,2200,2006);
pds:=Input("LInear RegressIon TrendIIne perIods",2,2520,63);
muItI:=Input("ChanneI Standard DevIatIons",
0,100,2);
x:=Input("use Open=1 HIgh=2 Low=3 CIose=4 VoIume=5 P=6",1,6,4);
x:=If(x=1,O,If(x=2,H,If(x=3,L,If(x=5,V,If(x=6,P,C)))));
end:=Year()>EnYear
OR (Year()=EnYear AND (Month()>EnMnth
OR Month()=EnMnth AND DayOfMonth()>=EnDay));
end:=end AND AIert(end=0,2);
end:=If(LastVaIue(Cum(Ref(end,pds)))=0,
LastVaIue(Cum(1))=Cum(1),end);
IastVaILRI:=LastVaIue(HIghest(
If(end,LInearReg(x,pds),0)));
IastVaILRS:=LastVaIue(HIghest(
If(end,LInRegSIope(x,pds),-10000)));
adjust:=LastVaIue(LastVaIue(Cum(1))
-HIghest(If(end,Cum(1),0)));
countback:=LastVaIue(Cum(1))-Cum(1)-adjust;
{ rem next IIne to extend pIot to end of chart }
countback:=Ref(Ref(countback,-adjust),adjust);
LR:=IastVaILRI-IastVaILRS*countback;
restrIct:=adjust-(LastVaIue(Cum(1))-pds);
LRT:=Ref(Ref(LR,-restrIct),restrIct);
upLR:=LRT+Stdev(LR,pds)*muItI;
IwLR:=LRT-Stdev(LR,pds)*muItI;
upLR;IwLR;LRT
http://www.meta-formula.com/Metastock-Formulas-A
.html 2014-10-14 14:04:15
Metastock Formulas - A
Strona 5
(Go Top)
If you have Metastock formulas you would llke to share,
Please emall to
We look forwar
to hearing from you!
To learn more about how to use Metastock and lts formula cllck here.
copyright 2003 MetaStock Website Home
Metastock® is a registered trademark of Equis International.
http://www.meta-formula.com/Metastock-Formulas-A
.html 2014-10-14 14:04:15