[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [EquisMetaStock Group] Re: Value in explorer is not equal with those in chart


  • To: <equismetastock@xxxxxxxxxxxxxxx>
  • Subject: Re: [EquisMetaStock Group] Re: Value in explorer is not equal with those in chart
  • From: "Roy Larsen" <rlarsen@xxxxxxxxxx>
  • Date: Thu, 20 Sep 2007 11:50:59 +1200
  • Ironport-content-filter: send-to-smtp

PureBytes Links

Trading Reference Links

Hi Jeff


Here's my take on "improving" your formula.

X:=LinearReg(C,13);
Y:=X-ATR(13)*2;
If(X>PREV,Max(Y,PREV),X);

Reducing the PREV count to 2 with this construction makes it a little more efficient (Approx 15% faster exploring 1000 bars). I think that's about as good as you'll get. 

I don't think sufficient information has been given for anyone to do better than guess at the cause of your problem. For what it's worth my guess would be on insufficient bars being loaded. Selecting "Load Minimum Records" (which loads 18 bars - includes MS calculated overhead) will give incorrect results. Loading 75 bars will give results that are generally correct to 3 decimal places. Loading 150 bars will give results that are generally correct to 4 decimal places.

I've explained numerous times over the years that any function using an Exponential Moving Average internally requires at least 5 times the "Periods" parameter number of bars loaded to produce reasonably accurate exploration results. Here are some facts that every MS user should know.

ATR() uses Wilders Smoothing.
Wilders Smoothing is a form of Exponential Moving Average.
Formulas using ATR() require many more bars loaded than that specified by the Periods parameter before they will return accurate results.
There are over 20 other standard MS functions that can cause "errors" in exploration results, though not all for the same reason.

On this and other forums there are often complaints about what MetaStock does wrongly. In my experience these are almost always user mistakes or misunderstandings of one sort or another. I can only think of two known problems with the Explorer. Equis fixed one these (MS10.1) and hasn't acknowledged the other. Neither had or have anything to do with the commonly reported "errors" that appear in MS forums. My point is that most claimed errors have a logical explanation and can be eliminated once the cause is known and understood by the user. Getting to that point can be a painful process for everyone concerned when information is drip-fed.

Here are some suggestions for anyone wanting help to isolate the cause of MetaStock variations between chart and exploration.

Provide a formula (or be prepared to provide to individuals trying to help on request).
Specify the periodicity of chart.
Specify a security that exhibits the problem (2 or 3 would be even better).
Specify the periodicity of exploration.
State the exploration column value returned.
State the different chart value plotted on the last data bar.
Confirm that the exploration option is set to Most Recent Date.
Specify the Explorer Data Loading option settings.

Well that should be something to think about anyway.


Regards

Roy
www.metastocktips.co.nz




  ----- Original Message ----- 
  From: jwlcfp 
  To: equismetastock@xxxxxxxxxxxxxxx 
  Sent: Thursday, September 20, 2007 6:01 AM
  Subject: [EquisMetaStock Group] Re: Value in explorer is not equal with those in chart



  Preston,

  Here is the indicator:

  If(LinearReg(C,13)>PREV,If(LinearReg(C,13)-(ATR(13)*2)
  >PREV,LinearReg(C,13)-(ATR(13)*2),PREV),LinearReg(C,13));

  In addition, I am trying to revise the formula without the PREV
  function. I have tried the Ref(ind, -1) but I have been unsuccessful to
  date.

  Jeff

  --- In equismetastock@xxxxxxxxxxxxxxx, pumrysh <no_reply@xxx> wrote:
  >
  > Jeff,
  >
  > As I have pointed out to jao, the exploration problems usually
  > relate to calculations of the exponential or Wilders based
  > indicators and having an adequate amount of time for the
  > calculations to take place.
  >
  > I can duplicate jao's problems but only if I use an exploration data
  > period that is too short.
  >
  > In your case I don't know what indicators you are using but I would
  > bet there are some exponential based indicators in there. If you
  > want us to take a look we would be happy to.
  >
  > Double checking your exploration against the chart value is
  > certainly a good idea and should be part of a standard operating
  > procedure. It just makes good sense.
  >
  >
  > Preston
  >
  >
  >
  >
  > --- In equismetastock@xxxxxxxxxxxxxxx, "jwlcfp" jeff@ wrote:
  > >
  > >
  > > I have experienced this problem also. I have been working with
  > Equis on
  > > it off and on for the past 6 months and I have not been able to
  > resolve
  > > the issue. I have sent them my "holy grail" formulas and they
  > have not
  > > been able to solve the issue. They had me try the things that
  > have been
  > > suggested here and they had me remove my program and start with a
  > new
  > > version of metastock. I had numerous updates. They said they
  > > periodically change the way formulas are calculated in different
  > > versions. They could not tell me what formulas were changed with
  > the
  > > various versions to see if my "holy grail" formulas were impacted.
  > > Never the less, this did not fix the problem.
  > >
  > > I noticed the problem in a custom formulas- a binary wave that
  > would
  > > produce a 1 for buy, 0 for hold and -1 for sell. In addition I
  > will
  > > sometimes receive different answers using the same data on
  > different
  > > computers. Daily I double check the daily, weekly and monthly
  > > explorer results with the graph results on my current holdings -
  > approx
  > > 20 investments. The errors are not consistent- by investment, time
  > > period or frequency. Out of approximately 60 data points (20
  > > investments x 3 time periods per exploration) there will be
  > between zero
  > > to 6 errors on a daily basis. The average is 2. I make it a
  > standard
  > > procedure to double check my exploration.
  > >
  > > I love Metastock, but this problem does concern me. I wish I could
  > > resolve it!
  > >
  > > Jeff
  > > --- In equismetastock@xxxxxxxxxxxxxxx, "strade_hn" <strade_hn@>
  > > wrote:
  > > >
  > > > Hi all,
  > > > I used explored to scan my stock, but value return in explorer is
  > > > quite different with one in chart. I use RSI(C,14) in explorer
  > returns
  > > 50
  > > > while in chart it's 63.
  > > > Can anyone help me with this problem?????
  > > >
  > >
  >



   

  __________ NOD32 2540 (20070919) Information __________

  This message was checked by NOD32 antivirus system.
  http://www.eset.com


[Non-text portions of this message have been removed]



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/equismetastock/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:equismetastock-digest@xxxxxxxxxxxxxxx 
    mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/