RE: [amibroker] Getting Some Signals Into AB for plotting

["Ken Close" <closeks@xxxxxxxx>]

Ed: thanks but HOW?  Dates in the data are discontinuous.

FT/Trade do not have shorts and covers.

Ken

-----Original Message-----
From: E Winters [mailto:e.winters1@xxxxxxxxxxx] 
Sent: Sunday, November 16, 2003 1:02 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Getting Some Signals Into AB for plotting

Ken,
Possibly importing into an artificial ticker with +1 -1 or 1 and 0.  You
would then be able to plot this and add your plotshapes.  Looks like an
FT
signal file to me :)
Regards,
Ed
----- Original Message -----
From: "Ken Close" <closeks@xxxxxxxx>
To: "AmiBroker List" <amibroker@xxxxxxxxxxxxxxx>
Sent: Sunday, November 16, 2003 12:45 PM
Subject: [amibroker] Getting Some Signals Into AB for plotting


| I have an excel file of some signals that I want to get into AB for
| plotting and comparisons to AB code generated signals.
|
| I have data in this format:
|
| 9/26/1990 Short
| 11/2/1990 Cover
| 11/2/1990 Buy
| 1/31/1991 Sell
| 2/11/1991 Buy
| 6/21/1991 Sell
| 6/21/1991 Short
| 7/16/1991 Cover
| 7/16/1991 Buy
| 11/25/1991 Sell
| 11/25/1991 Short
|
| Some fancy Excel footwork on my part allowed me to introduce
statements
| like this:
|
| Sshort=IIF(DateNum()==900926,1,0);
| Scover=IIF(DateNum()==901102,1,0);
| Sbuy=IIF(DateNum()==901102,1,0);
| Ssell=IIF(DateNum()==910131,1,0);
| Sbuy=IIF(DateNum()==910211,1,0);
| Ssell=IIF(DateNum()==910621,1,0);
| Sshort=IIF(DateNum()==910621,1,0);
| Scover=IIF(DateNum()==910716,1,0);
| Sbuy=IIF(DateNum()==910716,1,0);
| Ssell=IIF(DateNum()==911125,1,0);
| Sshort=IIF(DateNum()==911125,1,0);
|
| I had to get this far to realize that the last Sshort statement would
| replace the Sshort array from previous statements, in other words, I
am
| able to plot only the LAST signal for each array.
|
| I do not think I want to create a statement in Excel for something
like
|
| Sshort=IIF(DateNum()==900926 OR DateNum()==910621 OR ..... etc.  It
| seems like I would have to hand type in all dates.  Yuk!
|
| Can someone suggest how I would go about getting the data shown at the
| top into four arrays that can have the points highlighted with
| PlotShapes statements?  I am stuck.
|
| Thanks for any help,
|
| Ken
|
|
|
| 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/
|
|



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/mOAaAA/3exGAA/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/