|
PureBytes Links
Trading Reference Links
|
Ken it is quite easy to set up the string in excel from all the cells
DateNum()==900926 OR DateNum()==910621
Column A : Datenum()==
Column B: 900926 etc
Cell C1: =A1&B1
Rest of Column C: =C1&A2&B2
The last cell in column C will have the total string, just have to add the
bit at the start (Sshort=) and end(;) for AB
Cheers,
Graham
http://groups.msn.com/ASXShareTrading
http://groups.msn.com/FMSAustralia
-----Original Message-----
From: Ken Close [mailto:closeks@xxxxxxxx]
Sent: Monday, 17 November 2003 1:46 AM
To: AmiBroker List
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
------------------------ 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/
------------------------ 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/
|