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

RE: [amibroker] Re: Adding Text to Explore/Scan Columns



PureBytes Links

Trading Reference Links

Duke,
 
Great code! I have checked every ticker that display in AA and they are intact with your define. It is obvious you put a lot time and well logic.
The bottom code is an example to display text and cells color in AA. It can be found in the AFL library under the name "Alert Output As Quick Rewiev". I hope it help.
 
alex
 
//=========================   QUICK VIEW [alert]   =============================
//==============================================================================
//×××   Period at finding changes at stocks price   ××××××××××××××××××××××××××××
x      =-90;
eDay   =-1;
eWeek  =-5;
eMonth =-20;
eQTR   =-60;
eYEAR  =-260;
user   =x;
//×××   HLEDANÁ DÉLKA   ××××××××××××××××××××××××××××××××××××××××××××××××××××××××
qvCAS = eDay;        // There enter lenght period !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
//×××   PODMÍNKY   ×××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××
qvCE       =C;
qvHLEDANE  =Ref(C,qvCAS);
qvBODY     =qvCE-qvHLEDANE;
qvPROCENTA =100*(qvCE-qvHLEDANE)/qvHLEDANE;
//×××   EXPLORE   ××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××
Filter     = C;
AddTextColumn(Name(),"Ticker",2, IIf( MarketID()==0,5,4));
AddColumn(qvHLEDANE,"Prev.Price",1.2);      
AddColumn(C,"Price",1.2,IIf(C<1,11,IIf(C>=1 AND C<3,12,IIf(C>=3 AND C<20,1,0))));
;
AddColumn(qvBODY,"Change in $",1.2,2 ,IIf(qvBODY>=0.001,5,IIf(qvBODY==0,9,4 )));
AddColumn(qvPROCENTA,"Change in %",1.2,2 ,IIf(qvPROCENTA>=0.001,5,IIf(qvPROCENTA==0,9,4 )));//×××   ALERT   ××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××
Buy  = qvPROCENTA>0;
Cover= qvProcenta==0;
Sell = qvPROCENTA<0;
AlertIf( Buy,"",WriteVal(qvPROCENTA,1.2),1,1,0 );
AlertIf( Sell,"",WriteVal(qvPROCENTA,1.2),2,1,0 );
AlertIf( Cover,"",WriteVal(qvPROCENTA,1.2),0,1,0 );
//××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××
        

"Duke Jones, CMT" <Duke.Jones@xxxxxxxxxxxxxxxxxxxxxx> wrote:

If you ever find a way to make the values conditional please post it to the list. So far I have only been able to make just the text colored but not the background without making the whole column the same color.

 

 

 

 

 

Duke Jones, CMT

 


From: dmcleod1981 [mailto:dmcleod1981@xxxxxxxxx]
Sent: Wednesday, March 02, 2005 7:27 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Re: Adding Text to Explore/Scan Columns

 


Graham,

I was trying to only color the cell if the condition was true.

I tried versions of the following but no luck so far...
AddTextColumn( WriteIf( cond1, "Yes", "" ), "10DMA Cross",1.2, IIf
(Cond1>0,colorBlack,colorYellow ));

I will keep trying.

Thank you again for the help.

--- In amibroker@xxxxxxxxxxxxxxx, Graham <kavemanperth@xxxx> wrote:
> Best way to find things out is to check the help screens
> SYNTAX  AddTextColumn( string, name, format = 1.2, textColor =
> colorDefault, bkgndColor = colorDefault )
>
>
> On Thu, 03 Mar 2005 01:16:48 -0000, dmcleod1981 <dmcleod1981@xxxx>
wrote:
> >
> >
> > Herman, thank you for the examples. I was able to get Graham's
> > suggestion to work for me. Your code samples did help me figure
out
> > another problem I was having.
> >
> > Thank you again.
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, "Herman van den Bergen"
> > <psytek@xxxx> wrote:
> > > Hello dave,
> > > Text arrays are not possible in AmiBroker, however you can
display
> > the same
> > > string in all cells of a vertical column using AddTextColumn().
> > Since you
> > > can color the Text as well as the background you can make
> > text "disappear"
> > > by setting its color to White. You can also play with the
> > background color.
> > > Here is a simple example:
> > >
> > > Price = ValueWhen(Buy OR Cover,C);
> > > AddColumn(Price,"Buy/Cover",1.2,colorBlack ,colorBrightGreen );
> > > Price = ValueWhen(Sell OR Short,C);
> > > AddColumn(Price,"Short/Sell",1.2,colorBlack ,colorPink );
> > > DCo = IIf( Sell==3, 1,2);
> > > AddTextColumn("Stop","LongSTop",1.0,DCo,2);
> > > DCo = IIf( Cover==3, 1,2);
> > > AddTextColumn("Stop","ShortSTop",1.0,DCo,2);
> > >
> > > Best regards,
> > > herman
> > >
> > >   -----Original Message-----
> > >   From: Dave McLeod [mailto:dmcleod1981@xxxx]
> > >   Sent: Wednesday, March 02, 2005 6:30 PM
> > >   To: amibroker@xxxxxxxxxxxxxxx
> > >   Subject: [amibroker] Adding Text to Explore/Scan Columns
> > >
> > >
> > >   I would like to try and create a table within Scan/Explore
that
> > contains
> > > text in the table columns itseld if certain conditions are met.
> > Something
> > > like the following sample pic.
> > >
> > >
> > >   Is this possible in Amibroker?
> > >
> > >   Thanks
> > >   DM
> > >
> > >
> > > ---------------------------------------------------------------
----
> > ---------
> > > --
> > >   Celebrate Yahoo!'s 10th Birthday!
> > >   Yahoo! Netrospective: 100 Moments of the Web
> > >
> > >   Check AmiBroker web page at:
> > >   http://www.amibroker.com/
> > >
> > >   Check group FAQ at:
> > > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > >
> > >
> > >         Yahoo! Groups Sponsor
> > >               ADVERTISEMENT
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------------------------------------
----
> > ---------
> > > --
> > >   Yahoo! Groups Links
> > >
> > >     a.. To visit your group on the web, go to:
> > >     http://groups.yahoo.com/group/amibroker/
> > >
> > >     b.. To unsubscribe from this group, send an email to:
> > >     amibroker-unsubscribe@xxxxxxxxxxxxxxx
> > >
> > >     c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms
> > of Service.
> >
> >
> > Check AmiBroker web page at:
> > http://www.amibroker.com/
> >
> > Check group FAQ at:
http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
>
> --
> Cheers
> Graham
> http://e-wire.net.au/~eb_kavan/





Check AmiBroker web page at:
http://www.amibroker.com/

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html






Check AmiBroker web page at:
http://www.amibroker.com/

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html




--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.0 - Release Date: 3/2/2005


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.0 - Release Date: 3/2/2005


Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web

Check AmiBroker web page at:
http://www.amibroker.com/

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html



Yahoo! Groups Sponsor
ADVERTISEMENT
click here


Yahoo! Groups Links