ËùÊôº¯Êý×飺ÏßÐÍÃèÊö
COLORGRAYÉèΪ»ÒÉ«
ÀýÈç:MA1:MA(CLOSE,5),COLORGRAY ËùÊôº¯Êý×飺ÏßÐÍÃèÊö COLORGREENÉèΪÂÌÉ«
ÀýÈç:MA1:MA(CLOSE,5),COLORGREEN ËùÊôº¯Êý×飺ÏßÐÍÃèÊö
COLORMAGENTAÉèΪ¾§ºìÉ«
ÀýÈç:MA1:MA(CLOSE,5),COLORMAGENTA ËùÊôº¯Êý×飺ÏßÐÍÃèÊö
COLORREDÉèΪºìÉ«
ÀýÈç:MA1:MA(CLOSE,5),COLORRED ËùÊôº¯Êý×飺ÏßÐÍÃèÊö
COLORRGB½«ºì£¬ÂÌ£¬À¶Èý»ùÉ«»ìºÍ³ÉÒ»¸öÑÕɫֵ¡£ Ó÷¨:COLORRGB(R,G,B) R,G,B·Ö±ðȡֵΪ0£255¡£
¸Ãº¯Êý½öÓÃÔÚDRAWTEXTµÈ»Ïߺ¯ÊýÖÐCOLOR²ÎÊýÖ¸¶¨ÑÕɫʹÓá£
ÀýÈ磺DRAWTEXT(CLOSE/OPEN>1.08,LOW,'´óÑôÏß',COLORRGB(255,0,0));½«ÏÔʾºìÉ«µÄ´óÑôÏßÎÄ×Ö¡£
ÈôÓû§ÐèÖ¸¶¨Ö¸±êÏßÑÕÉ«£¬ÇëʹÓÃCOLOR00FFFFµÈÕâÖÖÓï·¨£¬ÏêϸÇë²Î¿¼½ð×ÖËþ¹«Ê½±àд½Ì³Ì¡£
ËùÊôº¯Êý×飺»æÍ¼º¯Êý
COLORSTICKÒÔÁãÖáΪÖÐÐÄ»²ÊÉ«°ô×´Ïߣ¬ÁãÖáÏÂΪÒõÏßÑÕÉ«£¬ÁãÖáÉÏΪÑôÏßÑÕÉ« ÀýÈç: CLOSE-OPEN,COLORSTICK ËùÊôº¯Êý×飺ÏßÐÍÃèÊö
COLORWHITEÉèΪ°×É«
ÀýÈç:MA1:MA(CLOSE,5),COLORWHITE ËùÊôº¯Êý×飺ÏßÐÍÃèÊö
COLORYELLOWÉèΪ»ÆÉ«
ÀýÈç:MA1:MA(CLOSE,5),COLORYELLOW ËùÊôº¯Êý×飺ÏßÐÍÃèÊö
COMBIN¼ÆËã´Ó¸ø¶¨ÊýÄ¿µÄ¶ÔÏ󼯺ÏÖÐÌáÈ¡Èô¸É¶ÔÏóµÄ×éºÏÊý¡£ÀûÓú¯Êý COMBIN ¿ÉÒÔÈ·¶¨Ò»×é¶ÔÏóËùÓпÉÄܵÄ×éºÏÊý¡£
Ó÷¨:COMBIN(A,B),AΪ¶ÔÏóµÄ×ÜÊýÁ¿,BΪÿһ×éºÏÖжÔÏóµÄÊýÁ¿ ÀýÈç:COMBIN(8,2),´Ó°Ë¸öºòÑ¡ÈËÖÐÌáÈ¡Á½¸öºòÑ¡È˵Ä×éºÏÊý (28) ËùÊôº¯Êý×飺Êýѧº¯Êý
CONTINUE
Ó÷¨:ʹ±¾´ÎÑ»·Ìáǰ½áÊø£¨²»ÔÙÖ´ÐÐCONTINUEÏÂÃæµÄÓï¾ä£©£¬È»ºóÔÙ¸ù¾ÝÑ»·Ìõ¼þÊÇ·ñÂú×ã¾ö¶¨ÊÇ·ñ½øÈëÏ´ÎÑ»·¡£ ËùÊôº¯Êý×飺¿ØÖÆÓï¾ä
COSÓàÏÒÖµ¡£
Ó÷¨:COS(X)·µ»ØXµÄÓàÏÒÖµ ËùÊôº¯Êý×飺Êýѧº¯Êý
COST³É±¾·Ö²¼Çé¿ö¡£
Ó÷¨:COST(10),±íʾ10%»ñÀûÅ̵ļ۸ñÊǶàÉÙ£¬¼´ÓÐ10%µÄ³Ö²ÖÁ¿Ôڸü۸ñÒÔÏ£¬ÆäÓà90%Ôڸü۸ñÒÔÉÏ£¬ÎªÌ×ÀÎÅÌ
¸Ãº¯Êý½ö¶ÔÈÕÏß·ÖÎöÖÜÆÚ±È½ÏÓÐЧ ËùÊôº¯Êý×飺ָ±êº¯Êý
COUNTͳ¼ÆÂú×ãÌõ¼þµÄÖÜÆÚÊý¡£
Ó÷¨:COUNT(X,N),ͳ¼ÆNÖÜÆÚÖÐÂú×ãXÌõ¼þµÄÖÜÆÚÊý,ÈôN=0Ôò´ÓµÚÒ»¸öÓÐЧֵ¿ªÊ¼¡£ ÀýÈ磺COUNT(CLOSE>OPEN,20)±íʾͳ¼Æ20ÖÜÆÚÄÚÊÕÑôµÄÖÜÆÚÊý ËùÊôº¯Êý×飺ÒýÓú¯Êý
COVARÇó2¸öÐòÁеÄз½²î¡£
Ó÷¨:COVAR(X1,X2,N) ΪX1ÓëX2µÄNÖÜÆÚµÄз½²î
ÀýÈç:COVAR(CLOSE,INDEXC,8) ±íʾÊÕÅ̼ÛÓë´óÅÌÖ¸ÊýÖ®¼äµÄ8ÖÜÆÚµÄз½²î ËùÊôº¯Êý×飺ͳ¼Æº¯Êý
CROSSÁ½ÌõÏß½»²æ¡£
Ó÷¨:CROSS(A,B)±íʾµ±A´ÓÏ·½ÏòÉÏ´©¹ýBʱ·µ»Ø1£¬·ñÔò·µ»Ø0
ÀýÈ磺CROSS(MA(CLOSE,5),MA(CLOSE,10))±íʾ5ÈÕ¾ùÏßÓë10ÈÕ¾ùÏß½»½ð²æ ËùÊôº¯Êý×飺Âß¼º¯Êý
CROSSDOT»²æ×´Ïß»òX×´Ïß ÀýÈç: CLOSE,CROSSDOT ËùÊôº¯Êý×飺ÏßÐÍÃèÊö
CU_MA1ÐòÁмÆËãģʽϵÄ×Ô¶¨Ò庯ÊýʾÀý. Ó÷¨:CU_MA1(A,N)È¡AµÄNÈÕÒÆ¶¯Æ½¾ùÖµ.
Õâ¸öº¯ÊýÊÇϵͳÄÚÖÃVBS±àдµÄ£¬´úÂ벿·ÖÇëµ¥»÷¡°¹¤¾ß¡±²Ëµ¥Ïµġ°ºê¡±£¬È»ºóÑ¡Ôñ¡°VISUAL BASIC¹¤³Ì¡±¡£
È»ºó´ÓVISUAL BASIC¹¤³Ì×ÊÔ´¹ÜÀíÆ÷ÉÏÑ¡Ôñ¡°FUNCTION¡±Ä£¿é¡£Óû§¿ÉÒÔ´ÓÖÐÖÐѧϰÑо¿Ëû
ËùÊôº¯Êý×飺×Ô¶¨Ò庯Êý
CU_MA2ÖðKÏß¼ÆËãģʽϵÄ×Ô¶¨Ò庯ÊýʾÀý. Ó÷¨:CU_MA2(N)È¡ÊÕÅ̼۵ÄNÈÕÒÆ¶¯Æ½¾ùÖµ.
Õâ¸öº¯ÊýÊÇϵͳÄÚÖÃVBS±àдµÄ£¬´úÂ벿·ÖÇëµ¥»÷¡°¹¤¾ß¡±²Ëµ¥Ïµġ°ºê¡±£¬È»ºóÑ¡Ôñ¡°VISUAL BASIC¹¤³Ì¡±¡£
È»ºó´ÓVISUAL BASIC¹¤³Ì×ÊÔ´¹ÜÀíÆ÷ÉÏÑ¡Ôñ¡°FUNCTION¡±Ä£¿é¡£Óû§¿ÉÒÔ´ÓÖÐÖÐѧϰÑо¿Ëû
ËùÊôº¯Êý×飺×Ô¶¨Ò庯Êý
CURRENTDATE¼ÆËãʱµÄµ±Ç°ÈÕÆÚ¡£ Ó÷¨:CURRENTDATE
º¯Êý·µ»Ø¼ÆËãʱµÄÈÕÆÚ,ÓÐЧֵ·¶Î§Îª(101-1991231),±íʾ1900/01/01-2099/12/31 ×¢Ò⣺¸Ãº¯Êý·µ»Ø³£Êý ËùÊôº¯Êý×飺ʱ¼äº¯Êý
CURRENTTIME¼ÆËãʱµÄµ±Ç°¼ÆËã»úʱ¼ä¡£ Ó÷¨:CURRENTTIME
º¯Êý·µ»Ø¼ÆËãʱµÄʱ¼ä(ʱ·ÖÃë),ÓÐЧֵ·¶Î§Îª(000000-235959) ×¢Ò⣺¸Ãº¯Êý·µ»Ø³£Êý ËùÊôº¯Êý×飺ʱ¼äº¯Êý
D1970TODATEÈ¡µÃ1970ÈÕÆÚXµÄÈÕÆÚÖµ¡£ Ó÷¨:D1970TODATE(X) ËùÊôº¯Êý×飺ʱ¼äº¯Êý
DATAϵͳÄÚ²¿Êý×é¡£
Ó÷¨£ºÈ¡µÃÖ¸¶¨ÖÜÆÚµÄÊý¾Ý, ¶Ô
OPEN,HIGH,LOW,CLOSE,VOL,AMOUNT,OPENINT,OPENV,OPENA,ADVANCE,DECLINE,QT,DATE,TIMEÓÐЧ¡£ Ó÷¨:Êý¾ÝÀàÐÍ[N] ÀýÈç:
CLOSE[78]±íʾȡµÚ78ÖÜÆÚµÄÊÕÅÌ¼Û ËùÊôº¯Êý×飺ÐÐÇ麯Êý
DATABASEÁ¬½ÓÊý¾Ý¿â
Ó÷¨:DATABASE(STRING),STRINGΪÊý¾Ý¿âADOÁ¬½Ó×Ö·û´®
ÀýÈç:(1)Á¬½ÓACCESSÊý¾Ý¿â:DATABASE('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\test.mdb')
±íʾÁ¬½ÓD:\\Test.MDBÊý¾Ý¿âÎļþ.
(2)ͨ¹ýDSNÊý¾ÝÔ´¶ÔÈκÎÖ§³ÖODBCµÄÊý¾Ý¿â½øÐÐÁ¬½Ó: DATABASE('Data Source=adotest;UID=sa;PWD=1234;')
ÆäÖÐadotestÊÇÊý¾ÝÔ´Ãû³Æ£¬saΪµÇ½Óû§£¬1234ΪµÇ½ÃÜÂë (3)²»Í¨¹ýDSN¶ÔSQL SERVERÊý¾Ý¿â½øÐÐÁ¬½Ó£º
DATABASE('driver={SQL Server};Server=127.0.0.1;DATABASE=test;UID=sa;PWD=1234') ÆäÖÐServerÊÇ127.0.0.1·þÎñÆ÷µÄÃû³Æ»òIPµØÖ·£¬testÊÇÊý¾Ý¿âµÄÃû³Æ (4)²»Í¨¹ýDSN¶ÔOracleÊý¾Ý¿â½øÐÐÁ¬½Ó£º
DATABASE('provider=MSDAORA;Data Source=servername;User ID=sa;Password=1234;') ÆäÖÐservernameÊÇ·þÎñÆ÷Ãû³Æ»òIPµØÖ· ËùÊôº¯Êý×飺Êý¾Ý¿âº¯Êý
DATACOUNTÐòÁÐÊý¾ÝÁ¿¡£
Ó÷¨:DATACOUNT£¬·µ»ØÐòÁÐÊý¾ÝÊýÁ¿ ×¢Ò⣺¸Ãº¯Êý·µ»Ø³£Êý ËùÊôº¯Êý×飺³£Êýº¯Êý
DATATYPEµ±Ç°Êý¾ÝÖÜÆÚÀàÐÍ¡£ Ó÷¨:DATATYPE
·µ»ØÖµ·¶Î§Îª0-19£¬·Ö±ð±íʾ
0:·Ö±Ê³É½»¡¢1:1·ÖÖÓ¡¢2:5·ÖÖÓ¡¢3:15·ÖÖÓ¡¢4:30·ÖÖÓ¡¢5:60·ÖÖÓ¡¢ 6:ÈÕ¡¢7:ÖÜ¡¢8:Ô¡¢9:Äê¡¢10:¶àÈÕ¡¢11:¶à·ÖÖÓ¡¢12:¶àÃë¡¢
13:¶àСʱ¡¢14:¼¾¶ÈÏß¡¢15:°ëÄêÏß¡¢16:½ÚÆøÏß¡¢17:3·ÖÖÓ¡¢18:10·ÖÖÓ¡¢19:¶à±ÊÏß ËùÊôº¯Êý×飺³£Êýº¯Êý
DATATYPEMOREÈ¡µ±Ç°¶àÈÕ¡¢¶àСʱ¡¢¶à·ÖÖÓ¡¢¶àÃë¡¢¶à±ÊÏßÖÜÆÚµÄ²ÎÊýÖµ Ó÷¨:DATATYPEMORE(N)Nȡֵ0-4
·Ö±ðΪ0¶àÈÕ£»1¶àСʱ£»2¶à·ÖÖÓ£»3¶àÃë; 4¶à±ÊÏß ËùÊôº¯Êý×飺³£Êýº¯Êý
DATEÈ¡µÃ¸ÃÖÜÆÚ´Ó1900ÒÔÀ´µÄÄêÔÂÈÕ¡£ Ó÷¨:DATE()
º¯Êý·µ»ØÓÐЧֵ·¶Î§Îª(101-1991231),±íʾ19000101-20991231¡£ ËùÊôº¯Êý×飺ʱ¼äº¯Êý
DATEDIFFÈ¡µÃÈÕÆÚÖ®¼äµÄʱ¼ä¼ä¸ôÌìÊý¡£ Ó÷¨:DATEDIFF(DATE1,DATE2)
DATE1,DATE2ΪÐòÁбäÁ¿»ò³£Êý£¬¸ñʽÓëDATEͬ£¬ÓÐЧֵ·¶Î§Îª(101-1991231), ±íʾ19000101-20991231·µ»ØDATE1¡¢DATE2Á½¸öÈÕÆÚÖ®¼äµÄÏà²îµÄÌìÊý£¬ Èç¹û DATE1ÍíÓÚ DATE2£¬Ôò DATEDIFFº¯Êý·µ»Ø¸ºÊý
ÀýÈç:DATEDIFF(LSOLARTERMDATE(1),DATE)±íʾÇóµ±ÄêСº®µ½µ±Ç°ÖÜÆÚÏà²îµÄÌìÊý ËùÊôº¯Êý×飺ʱ¼äº¯Êý
DATETOD1970È¡µÃÈÕÆÚX¾àÀë1970Äê1ÔÂ1ÈÕÒÔÀ´µÄÌìÊý¡£ Ó÷¨:DATETOD1970(X)ÀýÈç: DATETOD1970(DATE)
·µ»Øµ±Ìì¾àÀë1970Äê1ÔÂ1ÈÕµÄÌìÊý¡£ ÈôÈÕÆÚСÓÚ1970ÄêÔò·µ»Ø¶ÔÓ¦¸ºÊý¡£ ËùÊôº¯Êý×飺ʱ¼äº¯Êý
DAYÈ¡µÃ¸ÃÖÜÆÚµÄÈÕÆÚ¡£ Ó÷¨:DAY()