|
PureBytes Links
Trading Reference Links
|
1 method
If they are in a columnlist you could break them out into separate columns
using the space as column delimiter, then do a reformat of the time column
to yyyymmdd, reformat as general number, then just subtract 19000000 from
that column. Then put the rows back together using concatenate function.
Method 2
Using the text functions isolate the dates and do similar as one
There would be other methods in excel but no time to go into it deeper.
Cheers,
Graham
http://groups.msn.com/ASXShareTrading
http://groups.msn.com/FMSAustralia
-----Original Message-----
From: Anthony Faragasso [mailto:ajf1111@xxxxxxxx]
Sent: Sunday, 23 March 2003 11:34 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Re: Dates Question
Steve,
To have the system fire ( Buy or Sell ) on the specific Dates as you
describe...I do not see any other alternative except to insert the dates
manually....
Maybe someone else has a suggestion.
Anthony
steve_almond wrote:
> Anthony,
>
> This works fine, thankyou. I've converted all the dates to Datenums,
> however, I have over 75 buy and 75 sell signals to include in this
> code (listed in Excel). Is there any shorthand way to include so many
> Datenums?
>
> Steve
>
> --- In amibroker@xxxxxxxxxxxxxxx, "Anthony Faragasso" <ajf1111@xxxx>
> wrote:
> > Steve,
> >
> > Try this: under settings tab...set delays to 0, positions to long
> only.
> >
> > Buy=IIf(DateNum()==880109,1,0)OR IIf(DateNum()==911021,1,0);
> > Sell=IIf(DateNum()==890612,1,0)OR IIf(DateNum()==921201,1,0);
> >
> > Filter=1;
> > AddColumn(Buy,"B");
> > AddColumn(Sell,"S");
> >
> >
> > -------Original Message-------
> >
> > From: amibroker@xxxxxxxxxxxxxxx
> > Date: Sunday, March 23, 2003 04:25:17
> > To: amibroker@xxxxxxxxxxxxxxx
> > Subject: [amibroker] Dates Question
> >
> > I've looked in the help files for this, but my programming skilla
> are
> > not good enough to solve this:
> >
> > I want to backtest a series of Buy/Sell signals given on a website
> > (the actual method of deriving the signals is unknown). So, I want
> to
> > tell AB (for the current ticker:
> >
> > Buy on 9/01/1988
> > Sell on 12/06/1989
> > Buy on 21/10/1991
> > Sell on 1/12/1992
> >
> > Etc.
> >
> > Can anyone help to code this?
> >
> > Thanks,
> >
> > Steve
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> > 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 the Yahoo! Terms of Service.
>
>
>
> Yahoo! Groups Sponsor
ADVERTISEMENT
>
> 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 the Yahoo! Terms of Service.
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 ---------------------~-->
Your own Online Store Selling our Overstock.
http://us.click.yahoo.com/rZll0B/4ftFAA/46VHAA/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/
|