|
PureBytes Links
Trading Reference Links
|
Actually, gang, the "answer" was already posted.
Prior to providing the details, please remember that this is used for
backtesting, not for future prediction, OK?? Ok...
Let's say that a simple MA cross is a buy signal and you want to know
what the close was 5 and 10 days after the cross to see how well the buy
signal performs. You would simply set a specific date exploration for
10 periods after the date in question, and filter for ref(cross(MA1,
MA2),-10) and put the following formulas in the columns:
A: Signal day's close ref(c,-10)
B: 5 days later close (ref(c,-5)
C: 10 days later close c
This is an OK workaround for the problem. As many of you know, the
manual says ref(c,5) is SUPPOSED to give you the close 5 days in the
future, and it does indeed work if you build a customer indicator and
place it on a chart. But it only provides a "N/A" in an exploration -
most aggravating.
Thank you to the list member who provided the date shifting idea (I am
sorry I deleted the mail and cannot give you proper credit - thank you
though!)
----Original Message Follows----
From: "A.J. Maas" <anthmaas@xxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Subject: Re: Future REF() function
Date: Fri, 5 Jun 1998 23:43:35 +0200
Reply-To: metastock@xxxxxxxxxxxxx
Future data records are generally not yet recorded by a record in a
data-file.
Logically, as future trading days' data cannot, at the present, ever be
available.
The bourses must be open up first, for any of the prices,volume etc. to
be "recorded".
In the Dowloader any security's data-file will have the last "known"
trading-date
stored & recorded(=record) and is displayed in the last line before the
blanc line.
Usage:
Using Ref() function should not reference to any data in the future,
therefore only be
used by adding a minus( "-" ) upfront, left of the particular required
amount of days
back in history( one day counting as 1 and is 1 "record")
Thus:
By not adding the minus( "-") upfront/left of the required amount of
days, the program
cannot find these days ( N/A : Not Available, Not Aplicable), as they
are not present
using the Data-sheet, not stored , and therefore not accessable.
IF , Then :
In the Downloader open any securities' data-file and check on the Date
coloms' lowest
"recorded" date. If this is for instance for yesterday's close(980605)
and in a formula
ref(C,2)
is mentioned, then the Close for tomorrow(C,1 is todays' Close) will be
required but
is never to be found or accesable by the program, giving the not
available N/A in
a Scan-exploration.
WorkAround:
A workaround for using future or other estimate data, could be
esthablished by
OLE linking with an Excel spreadsheet(Paste special, see MS65 manual
p.12 ).
Using Excels formulas, one can get estimates in a particular coloms.
Regards,
Ton Maas
Ms-IRB@xxxxxxxxx
-----Oorspronkelijk bericht-----
Van: Forrest Ho <forrest2@xxxxxxxxxxxx>
Aan: metastock@xxxxxxxxxxxxx <metastock@xxxxxxxxxxxxx>
Datum: vrijdag 5 juni 1998 11:59
Onderwerp: Re: Future REF() function
> From: "David Walton" <davidwalton@xxxxxxxxxxx>
> To: metastock@xxxxxxxxxxxxx
> Subject: Future REF() function
> Date: Thu, 04 Jun 1998 01:06:23 EDT
> Reply-to: metastock@xxxxxxxxxxxxx
Dear David Walton :
I had this problem before but I am afraid there
is not any answer ! I email this question to
Equis but it seemed that I only got shit !
I tried to write a formula and test its power on
a past date and wanted to know whether the stocks
sorted out from explorer have rise or drawdown
after several days . The conditons was same as
you . I found this function in the manual that
they claimed it can refer "future" data by
setting the ref (X, +days).
No solution !! I even forgot how Euqis replied me
!!
If you find solution , please tell me too !Thanks
!
Forrest Ho
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
|