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

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



PureBytes Links

Trading Reference Links







Bruce:  clever.  That did it.  Thanks.

Ken


-----Original Message-----
From: bruce1r [mailto:brucer@xxxxxxxxx]
Sent: Sunday, November 16, 2003 1:25 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Re: Getting Some Signals Into AB for plotting

Ken - this one is easy if I'm assuming correctly that you are 

producing AFL code.  As soon as I can figure out how to use an 

attachment on Yahoo, I'll post something that may be more interesting 

and more automated.

If you want to fix your code issue, use -

Sshort = 0;

Sshort = IIf(DateNum()==900926, Sshort+1, Sshort);

....




--- In amibroker@xxxxxxxxxxxxxxx, "Ken Close" <closeks@xxxx> wrote:

> 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


  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.