|
PureBytes Links
Trading Reference Links
|
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
|