|
PureBytes Links
Trading Reference Links
|
Friends,
Actually one can follow a little smarter approach and create a hypo
security with only tomorrow's value rather than creating whole lot of
extra values going far out in future, if one needs to
compute/estimate/anticipate only tomorrows value(s). The creation of
this security (and import thereof) can easily be automated and can be
a part of usual daily processing. (Tomorrow's date can be made even
smarter by skipping all the market holdidays as well ...)
Regards,
- Salil V Gangal
--- In amibroker@xxxxxxxxxxxxxxx, "salil_gangal" <salil_gangal@xxxx>
wrote:
> Tomasz,
>
> Thanks a lot for the detailed explanation. Now I have a better
> handle on this issue.
>
> And I can easily live with this. In fact it will be quite useful.
>
> Just thinking aloud ===> It looks like if I were create a security
> with (hypothetical) future values going upto December 31, 2020 and
> keep that as 'selected', then I can safely put computed values
> in 'real' securities ... and still I can maintain the date of these
> not to have to forced as old dates. (This referrs to my question
in
> the post http://groups.yahoo.com/group/amibroker/message/45946 )
>
> Regards,
> - Salil V Gangal
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko"
<amibroker@xxxx>
> wrote:
> > 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@xxxx>
> > 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@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/
> > >
> > >
> > >
------------------------ 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/
|