½ð×ÖËþº¯ÊýÕûÀí»ã×Ü

ËùÊôº¯Êý×飺ÏßÐÍÃèÊö

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()

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)