search:
Sharetradingeducation.com: Stock & Share Market Educational Options For Investing Online & Online Trading, Home Based Business Opportunity
Become a Member of the Investing & Online Trading stock market newsletter.

We invite you to register for free membership of our exclusive stock market club for online education.
As an online member you'll receive free downloads access, information on product launches, seminars, special promotions & more for investing online.
Register Now Or Login below...

Member Login

Email Address

Password

Forgot Password?


Metastock Software Formulae
Metastock Software Formulae

The following Metastock formulae are provided to our readers as a service and form a selection of a more extensive list from which we have copied, with our thanks to Daryl Guppy, from his website www.guppytraders.com. These formulae in turn were posted on his site by some of his readers, as named below.

 

The formulae included here are not designed to produce buy or sell signals in any form or context, nor are they intended to replace your stock broker or licensed financial advisor. The formulae are included here as general comment only so that you are aware of what is possible with the MetaStock program.

 

Sharetradingeducation.com do not necessarily use or endorse these and expressly disclaims any responsibility to the accuracy or effectiveness of the following formulae. The decision to trade and the method used to trade are up the individual. If you spot any errors, please contact us.

Additional formulae also appear at http://www.equis.com/customer/support with new free Metastock formulae being added regularly.

Those readers wanting to understand how to use Metastock further may wish to visit our Stock Market Home Study Course module 'Metastock In a Nutshell', based on the book by the same name by Simon Sherwood, NOW AVAILABLE on this site.  

 

 

Common Metastock Bar Patterns

(from Walter Lake}

BAR - 3 Higher Highs
H>Ref(H,-1) AND Ref(H,-1)>Ref(H,-2) AND Ref(H,-2)>Ref(H,-3)

 

(from Walter Lake}

BAR - Gap Up
GapUp()

BAR - 3 Lower Lows & Reversal H
L>Ref(L,-1) AND Ref(L,-1)<Ref(L,-2) AND Ref(L,-2)<Ref(L,-3) AND Ref(L,-3)<Ref(L,-4)

 

BAR - Gap Down
GapDown()

BAR - 3 Lower Lows
L<Ref(L,-1) AND Ref(L,-1)<Ref(L,-2) AND Ref(L,-2)<Ref(L,-3)

 

BAR - H > Yesterday's H
H>Ref(H,-1)

BAR - 5 Lower Lows
L<Ref(L,-1) AND Ref(L,-1)<Ref(L,-2) AND Ref(L,-2)<Ref(L,-3) AND
Ref(L,-3)<Ref(L,-4) AND Ref(L,-4)<Ref(L,-5)

 

BAR - Inside Day
HIGH < Ref(HIGH,-1) AND LOW > Ref(LOW,-1)

 

Price and Volume Breakout

Shows stocks where the price increased 5% and the volume is 50% above a 50-day moving average. Rank results by % change in price, then check the volume.

·         CLOSE

·         Ref(CLOSE,-1)

·         ROC(CLOSE,1,percent)

·         VOLUME

·         Mov(VOLUME,50,EXPONENTIAL)

·         ((VOLUME - Mov(VOLUME,50,EXPONENTIAL)) /Mov(VOLUME,50,EXPONENTIAL)) * 100

·         **When(colC >= 5) AND When(colD >= colE*1.5)

 

 

Moving Average Crossover---Bullish

This is a 10 and 30 day moving average crossover search. Results close to 0 pinpoint the crossover.

  • CLOSE
  • Mov(CLOSE,30,EXPONENTIAL)
  • ((CLOSE-Mov(CLOSE,30,EXPONENTIAL)) /Mov(CLOSE,30,EXPONENTIAL)) * 100
  • ((CLOSE-Mov(CLOSE,10,EXPONENTIAL)) /Mov(CLOSE,10,EXPONENTIAL)) * 100
  • **When(colA > colB)
Higher Closes

Shows stocks which have closed higher on successive days.

·         CLOSE

·         CLOSE -1

·         CLOSE -2

·         **When(colA,>,colB) AND When(colB,>,colC)

MACD Crossover Buy Signal

Shows those stocks where an MACD crossover has been signalled. The search returns 1 for Ok and 0 for not ok.

·         CLOSE

·         MACD()

·         Ref(MACD(),-1)

·         Mov(MACD(),9,EXPONENTIAL)

·         Ref(Mov(MACD(),9,EXPONENTIAL),-1)

·         ((MACD() - Mov(MACD(),9,EXPONENTIAL)) /Mov(MACD(),9,EXPONENTIAL)) * 100

·         **Cross( MACD(), Mov(MACD(),9,EXPONENTIAL))

 

 

Three Inside Days

Inside days suggest a volatility compression and often precede strong breakouts. Search returns 1 for ok and 0 for not ok

  • Inside()
  • Inside()-1
  • Inside()-2

Performance Daily

Stocks sorted on % gains over 1, 2, 3, 4, and 5 days. Rank results for the selected day. Good for finding breakout stocks.

·         CLOSE

·         ROC(CLOSE,1,percent)

·         ROC(CLOSE,2,percent)

·         ROC(CLOSE,3,percent)

·         ROC(CLOSE,4,percent)

·         ROC(CLOSE,5,percent)

 

Rally Gap and Inside Day

Finds stocks which have rallied, gapped upwards, and then had an inside day.

Usually leads to a resumption of the rally. The search returns 1 for Ok and 0 for not ok.

·         RallyWithVol()

·         Inside()

·         GapUp()

 

 

Range High

Looks for out of range move where the close equals the high. Suggests more buying pressure.

The search returns 1 for Ok and 0 for not ok.

·         BigWhite()

·         CLOSE

 

High Volume

Displays those where volume is above the 100 day moving average.

The search returns 1 for Ok and 0 for not ok.

  • VOLUME
  • Mov(VOLUME,100,EXPONENTIAL)
  • ((VOLUME - Mov(VOLUME,100,EXPONENTIAL))
  • /Mov(VOLUME,100,EXPONENTIAL)) * 100
  • When(colA,>,colB)

 

 

2.5 * ATR Trailing Stop Loss

For Long:
HHV(H - 2.5*ATR(5),10)

For Short:
LLV(L + 2.5*ATR(5),10)

Furthermore, it may be beneficial to dynamically adjust the number of lookback periods in the HHV() or the LLV() function.
from Yngvi Hardarson

Bullish Engulfing Pattern

ColA: CLOSE

Filter BarsSince(EngulfingBear())<=5 AND BarsSince(ROC(C,60,%)>15)<=5 AND BarsSince(Stoch(9,1)>90)<=5

Filter enabled Yes

Periodicity Daily

Records required 1300

 

Bearish Engulfing Pattern

Col A: CLOSE

Filter BarsSince(EngulfingBull())<=5 AND BarsSince(ROC(C,60,%)<-15)<=5 ANDBarsSince(Stoch(9,1)<10)<=5

Filter enabled Yes


Periodicity Daily. Records required 1300

Up 20% on Double Average Volume

Col A: CLOSE

Col B:ROC(C,5,%)

Filter ROC(C,5,%)>=20 AND Mov(V,5,S)>=(2*Ref(Mov(V,60,S),-5))

Filter enabled Yes

Periodicity Daily

Records required 1300

 

Down 20% on Double Average Volume

Col A: CLOSE

Col B: ROC(C,5,%)

Filter ROC(C,5,%)<=-20 AND Mov(V,5,S)>=(2*Ref(Mov(V,60,S),-5))

Filter enabled Yes

Periodicity Daily

Records required 1300

Cross Above 200 MA on Twice Average Volume

Filter (C>Mov(C,200,S) AND Ref(C,-5)<Ref(Mov(C,200,S),-5)) AND C>5 AND V>Mov(V,200,S)*2

 

Crossing Below 200 Day MA on Double Average Volume

Filter (C<Mov(C,200,S) AND Ref(C,-5)>Ref(Mov(C,200,S),-5)) AND C>5 AND V>Mov(V,200,S)*2

Gain By %

Col A: CLOSE

Col B: ROC(C,5,%)

Filter: (ROC(C,5,%)>10 OR ROC(C,5,%)<-10) AND C>5

Filter enabled: Yes

 

Biggest Losers

Col A: CLOSE

Col B: ROC(C,5,%)

Filter: (ROC(C,5,%)>10 OR ROC(C,5,%)<-10) AND C>5

Filter enabled: Yes

RSI Divergence

{RSI(9) DIVERGENCE BUY:}
If(RSI(9) >= HHV(RSI(9),19) AND CLOSE <HHV(CLOSE,19), 1,0) OR
If(CLOSE <= LLV(CLOSE,19) AND RSI(9) > LLV(RSI(9),19), 1,0)

{RSI(9) DIVERGENCE SELL:}
If(CLOSE >= HHV(CLOSE,19) AND RSI(9)<HHV(RSI(9),19),1,0) OR
If(RSI(9) <= LLV(RSI(9),19) AND CLOSE > LLV(CLOSE,19),1,0)

{You can substitute any formula for the "RSI(9)"}

{from Mike Arnoldi}

 

Another RSI Divergence Exploration

{A simple exploration filter formula for finding a bullish divergence
between the RSI and the price is shown below. To find a bearish divergence,
replace > with <. The differences in the trough function was found through
an optimization routine and they may not be the best values for your
application.}

Ref(RSI(14),-1)>Trough(1,RSI(14),.8)
AND
Ref(CLOSE,-1)<Trough(1,CLOSE,.2)

{from Dan in
Pocatello, ID}

 

52 Week Hi-Lo Exploration

ColA: {Close}C;
ColB: {52-week High} HighestSince(1, (DayOfMonth()=08 AND Month()=05
AND Year()=1998), H);
ColC: {52-week Low} LowestSince(1, (DayOfMonth()=08 AND Month()=05 AND
Year()=1998), L);

{Choose one of these filters}
{Filter 1:} ColA >= (0.9*(ColB))
{Filter 2:} ColB >= 2*ColC

{If you want both the conditions to be satisfied in the same query, just
join the two filters by the AND operator:}

Filter: (ColA >= (0.9*(ColB)) AND ColB >= ColC)

{One problem with the 52-wk High and 52-wk Low formula--every day you've got
to change the values for dayofmonth(), Month() and Year() functions. The
formula given above assumes that you would be running the query on May 07,
1998. Change the values of the above functions accordingly.}

{from Rajat Bose}

 

FIND RSI ABOVE 80

Col A: RSI(14)

Filter colA>=80

Filter enabled Yes

Periodicity Daily

Records required 18

 

Advertising and Links to Other Web Sites

This web site contains links to third party sites, third party advertisements and other information ("Third Party Material").

Disclaimer - Sharetradingeducation.com is not making recommendations on such Third Party Material.  We provide a convenient way to access web sites that our clients may access on a regular basis, some of which may be helpful resources to you. You should always do your own due diligence when choosing a product or newsletter to assist in your trading and investment activities. 

This Third Party Material is not under the control of Sharetradingeducation.com and Sharetradingeducation.com is not responsible for its content. Inclusion of an advertisement or a link to another site does not imply any endorsement of that third party (or its products or services), information or linked web site by Sharetradingeducation.com. You link to any such web site or use such information entirely at your own risk.

In some instances, the Third Party Material will contain representations or offers by the third party which you can accept by linking to the third party's web site and executing the relevant transaction. Such offers are not made by Sharetradingeducation.com and the third party is solely responsible to you for the delivery of any goods or services you purchase on the third party web site.

Sharetradingeducation.com does not give any representation or warranty as to the reliability, accuracy or completeness of any Third Party Material nor does Sharetradingeducation.com accept any responsibility arising in anyway (including negligence) for errors in, or omissions from such Third Party Material. Sharetradingeducation.com and its associates will not accept liability for any loss, damage or expense incurred or suffered by you if you rely on any information provided in making investment decisions.

Your use of this site is an implicit acknowledgement that you have read, understood, and agreed to the Terms of Use below. Purchase of any item from this site requires your formal agreement to these Terms as part of the registration process. No Liability accepted. All data linked to this site is copyright to their individual publishers and we disclaim any liability for the accuracy of the information they provide. This is an education and information site, so listing on this site should not be taken as an endorsement of any product or service.

ShareTradingEducation.com is a Corporate Authorised Representative of Novus Capital Limited AFSL 238168 ACN 006 711 995. Authorised Representative No 322726

ShareTradingEducation.com Pty Ltd (STE) and Novus Capital Limited (Novus) , their associates and respective Directors and staff each declare that they, from time to time, may hold interests in securities and/or earn brokerage, fees, interest, or other benefits from products and services mentioned in this website.

This website might contain unsolicited general information, without regard to any investor's individual objectives, financial situation or needs. It is not specific advice for any particular investor. Before making any decision about the information provided, you must consider the appropriateness of the information in this website or the product disclosure statement or Financial Services Guide, having regard to your objectives, financial situation and needs and consult your adviser. Any indicative information and assumptions used here are summarised and also may change without notice to you, particularly if based on past performance.

STE and Novus believes that any information or advice (including any securities recommendation) contained in this website is accurate when issued but does not warrant its accuracy or reliability. STE and Novus is not obliged to update you if the information or its advice changes. STE and Novus and each of their respective officers, agents and employees exclude to the full extent permitted by law, all liability of any kind, in negligence, contract, under fiduciary duties or otherwise, for any loss or damage, whether direct, indirect, consequential or otherwise, whether foreseeable or not, to the extent arising from or in connection with this website.

This website and any sites linked to this site are not designed to replace your Licensed Financial Consultant or your Stockbroker. You should seek appropriate advice from your broker, or licensed investment or financial advisor, or contact one of the stock brokers listed on this site, before taking any action. Direct investing in the Stock Market can result in financial loss. The decision to trade and the method of trading is for the reader alone to decide.

STE and Novus and their associates expressly disclaim all and any liability to any person, whether a purchaser of any items available from this or linked sites or not, in respect of anything and of the consequences of anything done or omitted to be done by any such person in reliance, whether whole or partial, upon the whole or any part of the contents or information obtained. STE and Novus and their associates will not accept liability for any loss, damage or expense incurred or suffered by you if you rely on any information provided in making investment decisions.