Can someone please help with Metastock formula?

[Rob_ee]

Thanks Tech, I followed your earlier advice and contacted him last week and received a couple of free samples... looks interesting.

As soon as I get stopped out of SMY I'll do just that.

At the moment to busy thinking about my two open trades. I cant afford to stuff it up.

Thanks for all your encouragement and help.

Rob

 

[yogi-in-oz]

Hi Rob_ee,

Be assured it CAN be done ... just PM me, if you still
need help and we can work through it step-by-step ...

have a great weekend

yogi

 

[Rob_ee]

Well I am chugging along, wonderful stuff this Metastock... written many formulas and done a few explorations ... however just 1 thing I am stuck on at the moment... Anyone please help

Anybody who has read my past posts may remember that I am particularly interested in all time highs OR recent highs

The formula Cross(H,Ref(HHV(H,30),-1) will give me todays high which is bigger than all in preeciding 30 days HOWEVER how would I ask for a result where that HIGH is no more than 20% higher than 30 days ago ??

I don't quite get it ?

Thanks for any replies ?

Rob

 

[tech/a]

In filter

Col A = 1 AND H < Ref (H,-30)*1.2

 

[Rob_ee]

Thanks Tech ....also for convincing me that its worth while to spend money on a quality charting package.

While Metastock isn't the dearest its in the upper range .. I love all its options and functionalities.

Before shelling out I tried many things ... Incredible charts was very good BUT you have to be connected to the net for it to work.. had some functionality but nowhere the range of MS.

I tried a 30 day trial of Amibroker .. I guess charting is a personal thing... for some reason it just didn't click with me .. don't know why ?

DONT BE EMBARASSED WITH WHAT I AM GOING TO SAY NEXT
I think the charting software companies should pay you a commision on all sales.

Your passion and enthusiasm for all things to do with charts is infectious.
I really only got interested after following all your threads here, at Reef and even the (wonderful of old) Stockcentral.

Once upon a time I pooh poohed charting as a waste of time and only a representation of what had already occured.

You changed my mind with your many lessons and examples of how charting can improve ones trading.
Its amazing the amount of time you have put in to educated new blood (like me) over the years.

Many thanks for your generosity
Rob

 

[tech/a]

Thanks Tech ....also for convincing me that its worth while to spend money on a quality charting package.

While Metastock isn't the dearest its in the upper range .. I love all its options and functionalities.

Its about functionality as you say. Most of the stuff I dont use but the Explorations and custom indicators (Which in the end I found limiting IE try to formulate a trend line and use it in a search or System).May have found some answers in other software---but another topic---still trialling.

DONT BE EMBARASSED WITH WHAT I AM GOING TO SAY NEXT
I think the charting software companies should pay you a commision on all sales.

Haha--well great equipment and people should get a wrap.

Your passion and enthusiasm for all things to do with charts is infectious.
I really only got interested after following all your threads here, at Reef and even the (wonderful of old) Stockcentral.

Your showing your age!! and mine!!

Once upon a time I pooh poohed charting as a waste of time and only a representation of what had already occured.

You changed my mind with your many lessons and examples of how charting can improve ones trading.
Its amazing the amount of time you have put in to educated new blood (like me) over the years.

I to have altered my veiw on many things I thought were fanciful.
"You cant pick tops or bottoms"
"You cant make consistent profit trading discretionarily"
To name a few.

Many thanks for your generosity
Rob

Thanks.
Every now and again a post like yours makes it worth while.
There are those who just want to pull geniune people down.
Sometimes difficult to BEAR.

 

[Rob_ee]

Well 1 month down the track and I really should know how to do this by now.

However I don't always get from metastock what I think the exploration SHOULD give me .... just one more piece of advice please..

At the moment my exploration gives me .....
Todays close which is higher than open AND the close is higher than 10 days ago AND the volume averages >1Mil over the last 10 days AND the C >.3 AND the Bar is higher than 50 days ago

A FINAL TOUCH I would like Toadys C is NO GREATER than 25% in the last 3 days.

I have tried all sort of combinations with the C Ref(C,-3) but don't quite get it

This to filter out to steep a rise in a few days

Thanks in advance for any help

Rob

 

[Rob_ee]

Never mind .. 2 hrs and 23 combinations later I finally got the results I needed.

Try and try again

Rob

 

[Garpal Gumnut]

Its about functionality as you say. Most of the stuff I dont use but the Explorations and custom indicators (Which in the end I found limiting IE try to formulate a trend line and use it in a search or System).May have found some answers in other software---but another topic---still trialling.

Dear Tech/a,

Some time ago, within last 2 months you posted on how to do quick searches and explorations on MS data A-Z as delivered by Parietch.

I've mislaid that post which I had saved, due to a computer crash and am unable to find it again in search of ASF.

Could you please repost it.

Garpal

 

[Rob_ee]

Well, I have been researching and experimenting without asking for help all the time , however I am stuck at the moment, perhaps some kindred soul might care to suggest .....

I have tried many variations to get the answer BUT it doesn't quite come out right..

In Filter how would I word it to get

Where the C > O over the last 10 periods.

Rob

 

[coyotte]

After a MS -stockscreen : >$1.00, < $10.00, 7 day RSI recently hit 30.


Help!

 

[tech/a]

Col A If(RSI(C,7)<=30,1,0)
Col B C>1.00 AND C<10.00

In Filter Col A=1 and Col B=1

 

[sdearle]

I hope someone can help me with my Metastock scan.

I want to run a basic RSI scan ''RSI(C,7)<=30" however I get results for RSI values greater than 30 when I open the chart and apply a RSI(C,7) on the stock, eg. It does not equal the same result as my explorer.

What am I doing wrong?

 

[tech/a]

Col A codes in the above should do it.

 

[sdearle]

Thanks,

I did try "If(RSI(C,7)<=30,1,0)" with a filter of ColA=1. The scan works fine however when I chart the results and put a RSI(C,7) indicator on the chart, the value is much different.

I put in a column B with RSI(C,7) so I could see the value in the filter output.

For example my scan picked up sock MOL with a RSI of 19.2118, when I open the chart and apply a RSI as an indicator I get a result of 44.4374.

 

[tech/a]

Go to your search
Click on the search
Go to options.
I'll bet you have the date for the search in correct.
Set it to the most recient date.

I ran the search on mine and MOL is rejected.
There it is at the top of the screen shot.
Silly duffa!
I'll bet its set around 7/4/08 ish

 

[sdearle]

I thought you had it, however the settings were correct.

I have attached a picture of the scan and the resulting chart with the RSI indicator attached, as you can see I have a problem!

Thanks for your advice.

 

[wayneL]

I used to get the same thing on all sorts of different expos when I ran metastock... could never explain it.

No such problem with Amibroker fwiw

 

[wabbit]

These sort of problems usually stem from having "load minimum bars" in the explorer options. RSI uses Wilders smoothing which is an exponential function, so load AT LEAST 5 times as much data as you think you should need for the exploration, i.e. for the RSI(C,7) makes sure to load at 35 bars of data; if you looking for a Mov(C, 20, E) function you'd have to load at least 100 bars etc.

To be even safer, load as much data as you have loaded when you open the chart. If you load 500 bars on opening the chart, you should load at least 500 bars in the exploration too.

Just for info: the maximum amount of data that can loaded on a chart is 65500 and the maximum load for exploration is 32767 bars. Of course, if you don't have that much data, it isn't loaded!


Hope this helps

wabbit

 

[wabbit]

I should have added that after you have run an exploration, it is really good practice to review ALL of the results report; for the "results", the "rejects" and the "exploration".

The "results" tab will tell you which stock met the criteria, the "rejects" will tell you which stocks failed to meet the criteria (either through normal filter rejection, or some sort of error) and the "exploration" will tell you how MS interpreted the exploration and also tell you how many bars were actually loaded!

On my machine, when I run a RSI(C,7) exploration with "load minimum records" selected, MS uses 9 bars of data. Obviously this is not enough.


wabbit