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

[amibroker] Re: How to do this................NO RESPONSE SO FAR..lemme try again



PureBytes Links

Trading Reference Links

Why did you not follow up the excellent lead by Graham. You don't 
need to "count the days" by hand

the following code will give you what you want.  You may just need to 
reconfigure how windows shows dates on your computer.  Mine 
is "mm/dd/yyyy"

Try this

dt = DateTime();
Price1 = LastValue( ValueWhen(dt==StrToDateTime("12/05/2005"), C ) );
Price2 = LastValue( ValueWhen(dt==StrToDateTime("1/06/2006"), C ) );
Price3 = LastValue( ValueWhen(dt==StrToDateTime("2/07/2007"), C ) );
AddColumn(Price1 ,"Dec 5, 2005");
AddColumn(Price2 ,"Jan 6, 2006");
AddColumn(Price3 ,"Feb 7, 2007");

Filter =1;

--- In amibroker@xxxxxxxxxxxxxxx, "meenhal" <meenhal@xxx> wrote:
>
> 
> Thanks but Mr Graham's reply addressed the question to the point.
> Your solution will require counting the days first , furthermore 
> this ref method deals with bars not days I suppose
> 
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "Ara Kaloustian" <ara1@> wrote:
> >
> > Filter = Your criteria;
> > AddColumn(Close,...
> > AddColumn,Ref(Close,-x),"x days ago");
> > AddColumn(Ref(Close,-y),"y days ago");
> > 
> > where x and y and offset in days
> > 
> > 
> > ----- Original Message ----- 
> > From: "meenhal" <meenhal@>
> > To: <amibroker@xxxxxxxxxxxxxxx>
> > Sent: Thursday, July 10, 2008 10:37 PM
> > Subject: [amibroker] Re: How to do this................NO 
RESPONSE 
> SO 
> > FAR..lemme try again
> > 
> > 
> > >
> > >
> > > So far no response
> > >
> > > To put it simply: can we get closing prices for two or more
> > > nonconsecutive days in the exploration window?
> > >
> > > --- In amibroker@xxxxxxxxxxxxxxx, "meenhal" <meenhal@> wrote:
> > >>
> > >> I need to list in the same analysis window closing prices of 
all
> > >> shares trades on 3 differnt dates
> > >>
> > >> header for the window shouldlook like
> > >>
> > >> Ticker | Dec 5, 2005 | Jan 6, 2006  |   Feb 7, 2007
> > >>
> > >> XYZ    |     1.02    |      0.97    |         2.1
> > >>
> > >>
> > >>
> > >> How can I tell mibroker to give me closing prices on three 
dates
> > > of
> > >> those scripts traded on those dates
> > >>
> > >> I have tried date conversions, barcount and barindex........can
> > > not do
> > >> it
> > >> Help please  and Thanks in advance
> > >>
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Please note that this group is for discussion between users 
only.
> > >
> > > To get support from AmiBroker please send an e-mail directly to
> > > SUPPORT {at} amibroker.com
> > >
> > > For NEW RELEASE ANNOUNCEMENTS and other news always check 
DEVLOG:
> > > http://www.amibroker.com/devlog/
> > >
> > > For other support material please check also:
> > > http://www.amibroker.com/support.html
> > > Yahoo! Groups Links
> > >
> > >
> > >
> >
>



------------------------------------

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

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