|
PureBytes Links
Trading Reference Links
|
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
------------------------ 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/
|