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

Re: [amibroker] Re: How does Date() return the date ?



PureBytes Links

Trading Reference Links

Salil,

Synchronization works always. It is actually very easy to check it
for yourself.

Synchronization works on DATE / TIME BASIS.

So date time of foreign ticker ALWAYS matches currently selected
symbol.

I don't know how this can be explained clearer.

As for your example:
Re-read
http://www.amibroker.com/guide/afl/afl_view.php?name=FOREIGN


The last parameter - fixup - with the default value of 1 - causes filling the holes in the data with previous values (behaviour
introduced in 3.90.3), if fixup is 0 - the holes are not fixed (the old, pre-3.90.3 behaviour)

Lets assume that current symbol has data from August 1 to August 15
while foreigned only from August 1 to August 5.

So if fixup is 1 then Foreigned symbol data will be filled up with last available data


So
August 1 will REMAIN August 1
August 2 will REMAIN August 2
August 3 will REMAIN August 3
August 4 will REMAIN August 4

August 5 will REMAIN August 5
August 6 is missing in foreigned data so it will hold 'last available data' that is from August 5
August 7 is missing in foreigned data so it will hold 'last available data' that is from August 5
August 8 is missing in foreigned data so it will hold 'last available data' that is from August 5
August 9 is missing in foreigned data so it will hold 'last available data' that is from August 5
.....


If FIXUP is zero
August 1 will REMAIN August 1
August 2 will REMAIN August 2
August 3 will REMAIN August 3
August 4 will REMAIN August 4

August 5 will REMAIN August 5
August 6 is missing in foreigned data so it will be set to NULL
August 7 is missing in foreigned data so it will be set to NULL
August 8 is missing in foreigned data so it will be set to NULL
August 9 is missing in foreigned data so it will be set to NULL


As you can see if there is a MATCHING record for given DATE
it REMAINS IN PLACE. 
If there is no matchin record the result may be NULL (fixup= 0)
or the last known value preceding given date.


Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
From: "salil_gangal" <salil_gangal@xxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Thursday, August 14, 2003 1:12 AM
Subject: [amibroker] Re: How does Date() return the date ?


> Tomasz,
>
> Hmmm ... alas ... this explanation, I guess actually causes more
> problems (for what I'm doing) than it solves.
>
> What will be the effct of sync when the data for selected security is
> more and that of the foreigned securities is less ?  So the selected
> security is upto August 13th and foreigned is only up August 5th.
> Will the sync operation shift the data of foreigned security from 5th
> to 13th, 4th to 12th and so on to match-up with selected security ?
> (If so, then that sure is ... err ... I don't know.)
>
> Regards,
> - Salil V Gangal
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <amibroker@xxxx>
> wrote:
> > Salil,
> >
> > If you read the documentation on FOREIGN
> > http://www.amibroker.com/guide/afl/afl_view.php?name=FOREIGN
> >
> > you would learn that FOREIGN function SYNCHRONIZES all bars / dates.
> >
> > The date of each bar is always given by DateNum() and Foreign
> symbols
> > always match current security.
> >
> > Best regards,
> > Tomasz Janeczko
> > amibroker.com
> > ----- Original Message -----
> > From: "salil_gangal" <salil_gangal@xxxx>
> > To: <amibroker@xxxxxxxxxxxxxxx>
> > Sent: Thursday, August 14, 2003 12:41 AM
> > Subject: [amibroker] Re: How does Date() return the date ?
> >
> >
> > > Tomasz,
> > >
> > > Hmm ...
> > >
> > > That does pose an interesting problem when one is dealing
> securities
> > > via Foreign(), as none of the values in Foreign are *actually*
> > > selected.
> > >
> > > So perhaps let me re-state the problem. As before I have 3
> securities
> > > with different lengths of data and I'm accessing all of them with
> > > Foreign().  What is the way that I can know which data element is
> > > associated with which date ?  (In other words, LastValue() for
> first
> > > security is for date August 5th, for second it is for date August
> 8th
> > > and third it is for date August 13th.  How can know these dates
> in
> > > AFL script ?)
> > >
> > > Regards,
> > > - Salil V Gangal
> > >
> > >
> > >
> > >
> > > --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko"
> <amibroker@xxxx>
> > > wrote:
> > > > Salil,
> > > >
> > > > Date() returns string representing "selected" value of
> currently
> > > selected symbol
> > > > See http://www.amibroker.com/guide/afl/afl_view.php?
> > > name=SELECTEDVALUE
> > > >
> > > > for description of what 'selected' value means.
> > > >
> > > > Best regards,
> > > > Tomasz Janeczko
> > > > amibroker.com
> > > > ----- Original Message -----
> > > > From: "salil_gangal" <salil_gangal@xxxx>
> > > > To: <amibroker@xxxxxxxxxxxxxxx>
> > > > Sent: Thursday, August 14, 2003 12:10 AM
> > > > Subject: [amibroker] How does Date() return the date ?
> > > >
> > > >
> > > > > Friends,
> > > > >
> > > > > ( Sure ... sure ... Date() returns a string which contains
> the
> > > date
> > > > > in the particular locale format.)  However, my questions is
> how
> > > > > exactly does Date() determine what to return ?
> > > > >
> > > > > Say if I have only 3 securities in database, one of them that
> has
> > > > > data from beninning of year thru August 5th, second from
> > > beginning of
> > > > > year thru August 8th and third from beginning of year thru
> August
> > > > > 13th.  Then what is returned by Date() in such a database and
> > > why ?
> > > > >
> > > > > Regards,
> > > > > - Salil V Gangal
> > > > >
> > > > >
> > > > >
> > > > > Send BUG REPORTS to bugs@xxxx
> > > > > Send SUGGESTIONS to suggest@xxxx
> > > > > -----------------------------------------
> > > > > Post AmiQuote-related messages ONLY to:
> amiquote@xxxxxxxxxxxxxxx
> > > > > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > > > > --------------------------------------------
> > > > > Check group FAQ at:
> > > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > > > >
> > > > > Your use of Yahoo! Groups is subject to
> > > http://docs.yahoo.com/info/terms/
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
> > > Send BUG REPORTS to bugs@xxxx
> > > Send SUGGESTIONS to suggest@xxxx
> > > -----------------------------------------
> > > Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> > > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > > --------------------------------------------
> > > Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
>
>
>
> Send BUG REPORTS to bugs@xxxxxxxxxxxxx
> Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->

Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

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