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

Re: [EquisMetaStock Group] backtest using Explorer..and Reference Function Problem



PureBytes Links

Trading Reference Links

Hi hml
 
 
Have you looked at using the Trade Equity indicators and explorations for basic systems testing?
 
 
Regards
 
Roy
 
 
----- Original Message -----
From: hml_nyc
Sent: Thursday, October 06, 2005 7:50 AM
Subject: Re: [EquisMetaStock Group] backtest using Explorer..and Reference Function Problem

Hi Roy,

You have the answer before i got a reply from Metastock.  Here is
what Mr. Golson from Metastock wrote:

The explorer tool of MetaStock was not intended to provide back
testing capability.  It was intended to look for securities meeting
a given set of conditions.  Usually, it runs on only the most recent
data, however, as you know, this date can be shifted to an earlier
value.  Regardless of what the date is, the explorer does not load
any data after that date.  So if you had data from the current date
back to 1980 but set the exploration to calculate on the data
6/15/2004, then no data after 6/15/2004 would be loaded.  Since this
data is not loaded, the reference function with a positive value is
undefined.  As far as the explorer is concerned, there is no data
after 6/15/2004.

If you are trying to back test with the explorer then you will need
to change all formulas.  Use a negative reference on the buy signal
and no reference for the current price.  This would equate to
saying, if I bought this security x days ago, what would it be worth
now."


Although not intended as a backtesting tool, the Explorer can
certainly can be used to backtest data.  "Specific date" in the
Explorer Option is used for that specific purpose (unless one is
using the most recent date)

As suggested to change my formula by using negative reference and no
reference for the current date, this will work..but it is not the
most efficient way.  This will require me to count backward to find
out which date was the signal trigger date for the sole purpose
forcing an answer for current date. I would be better off to
manually getting the closing price from another source.

Equis can certainly improve its functionality and make Metastock a
real backtesting software if this feature was available.

HML








--- In equismetastock@xxxxxxxxxxxxxxx, "Roy Larsen" <rlarsen@xxxx>
wrote:
> Hi hml
>
>
> This is not a fault with MetaStock. When you set an exploration
date, all data following that date is excluded from the exploration.
You'll also find that running an exploration on current data and
using a positive Ref() function also returns an N/A result. The
simple reason is that you're trying to access data that doesn't
exist, or in the case of 1/2/04, data that you have stipulated must
be ignored.
>
> A positive reference is only acceptable in the Explorer if it is
offset by an equal or greater negative reference. In other words if
your overall formula is delayed (negative Ref()) by 20 bars from
2/1/04 then you can include in that formula a positive reference
that allows you to look forward by up to 20 bars. You cannot access
data that occurs after what you define as the current bar.
>
>
> Regards
>
> Roy
> www.metastocktips.co.nz
>

> ----- Original Message -----
> From: hml_nyc
> To: equismetastock@xxxxxxxxxxxxxxx
> Sent: Wednesday, October 05, 2005 10:19 AM
> Subject: [EquisMetaStock Group] backtest using Explorer..and
Reference Function Problem
>
>
> I am using the Explorer to do backtest to earlier period.
>
> Eg.  In my Exploration, I use a "specific date" to test my
Explorer
> on all my stocks from A-Z.
>
> I use 1/2/04 as my Specific Date to test my Explorer to see which
> stocks are selected as of 1/2/04.
>
> I would like to use the Reference function in the same Explorer to
> tell me what is the Closing price of the stock let say exactly 10
> days later from 1/2/04
>
> Metastock Help said to use          Reference(C,+10)
>
> But that does not give me the answer.  It tell me N/A
>
> Does anyone experience the same problem?
>
> hml
>
>
>
>
>
>
>
> -------------------------------------------------------------------
-------------
> YAHOO! GROUPS LINKS
>
>   a..  Visit your group "equismetastock" on the web.
>    
>   b..  To unsubscribe from this group, send an email to:
>    equismetastock-unsubscribe@xxxxxxxxxxxxxxx
>    
>   c..  Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
> -------------------------------------------------------------------
-------------






YAHOO! GROUPS LINKS