ͨ´ïÐŹ«Ê½±àд³õÖи߼¶È«Ì׽̳̣¨¸½Í¨´ïÐÅÈ«²¿º¯Êý±í£© ÁªÏµ¿Í·þ

·¢²¼Ê±¼ä : ÐÇÆÚÈý ÎÄÕÂͨ´ïÐŹ«Ê½±àд³õÖи߼¶È«Ì׽̳̣¨¸½Í¨´ïÐÅÈ«²¿º¯Êý±í£©¸üÐÂÍê±Ï¿ªÊ¼ÔĶÁbaed3fc051e2524de518964bcf84b9d529ea2c5f

×÷ÕߣºÕÇÀ²

V1£º=MA£¨VOL£¬5£©£» V2£º=VOL/REF£¨V1£¬1£©£¾2£» ³¤ÆÚºáÅÌ

a¡¢PZ1Êǵ±Ìì150ÈÕ¾ù¼Û£º PZ1£º=MA£¨CLOSE£¬M£©£» b¡¢PZ2ÊÇ150ÈÕµÄ×î¸ß¼Û£» PZ2£º=HHV£¨HIGH£¬M£©£» c¡¢PZ3ÊÇ150ÈÕµÄ×îµÍ¼Û£» PZ3£º=LLV£¨LOW£¬M£©£»

d¡¢PZ4ÊÇ150ÈÕµÄ×î¸ß¼ÛºÍ150ÈÕ¾ù¼ÛµÄ¾àÀëµÄ°Ù·Ö±È£¬PZ5¸ÕºÃÏà·´ÊÇ×îµÍ¼ÛºÍ¾ù¼ÛµÄ²îµÄ°Ù·Ö±È£» PZ4£º=£¨PZ2-PZ1£©/PZ1£» PZ5£º=£¨PZ1-PZ3£©/PZ1£»

e¡¢ÉèΪ¹É¼ÛÔÚ150ÈÕ¾ùÏßÉÏÏÂ15%²¨¶¯£¬Ò²¾ÍÊÇPZ4¡¢PZ5¶¼Ð¡ÓÚ0.15£» PZ£º=REF£¨PZ4£¬1£©£¼0.15 AND REF£¨PZ5£¬1£©£¼0.15£»

3¡¢½ñÌì´´ÏÂÀúʷиߣ¬Ò²¾ÍÊǽñÌìµÄ×î¸ß¼ÛÊÇ150ÌìÄÚµÄ×î¸ß¼Û£¡ TP1£ºHHV£¨HIGH£¬M£©£» TP£º=HIGH=TP1£»

×ÛºÏÈý¸öÌõ¼þµÄ×îºóµÄÂß¼­ÅжÏʽ¾ÍÊÇÎÒÃǵÄ×îºó½áÂÛ£º V2 AND PZ AND TP£¨²ÎÊýM=150Ì죩

×îÖÕ½á¹û¾ÍÊÇ£º £¨²ÎÊýM=150Ì죩 V1£º=MA£¨VOL£¬5£©£» V2£º=VOL/REF£¨V1£¬1£©£¾2£» PZ1£º=MA£¨CLOSE£¬M£©£» PZ2£º=HHV£¨HIGH£¬M£©£» PZ3£º=LLV£¨LOW£¬M£©£» PZ4£º=£¨PZ2-PZ1£©/PZ1£» PZ5£º=£¨PZ1-PZ3£©/PZ1£»

PZ£º=REF£¨PZ4£¬1£©£¼0.15 AND REF£¨PZ5£¬1£©£¼0.15£» TP1£ºHHV£¨HIGH£¬M£©£» TP£º=HIGH=TP1£» V2 AND PZ AND TP£»

×¢Ò⣺Èç¹ûÔ´Âë¼ÓÈëµ½¹«Ê½±à¼­Æ÷ºóÏÔʾ´íÎó£¬Çë¶à×¢Òâ±êµã·ûºÅ£¬ÐèÒª½«ÖÐÎÄģʽϵıêµã¸Ä³ÉÓ¢ÎÄģʽϵıêµã£¬ÀýÈ磺¡°£º¡±¸Ä³É¡°:¡±£¬ ¡°£¬¡±¸Ä³É¡°,¡±ÒÔ¼°À¨ºÅµÈµÈ¡£

37

×÷ÕߣºÕÇÀ²

3. ¸÷ÖÖÖ¸±ê¹«Ê½±à¼­Æ÷µÄÏêϸÇø±ð

¹«Ê½¹ÜÀíÆ÷¿É¹ÜÀíËÄÖÖÀàÐ͵Ĺ«Ê½£ºÖ¸ ±ê ¹« ʽ£º ÓÃÓÚÖ¸±êͼÐεĻæÖÆ¡£Ìõ¼þÑ¡¹É¹«Ê½£ºÓÃÓÚÌõ¼þÑ¡¹É¡£½»Ò×ϵͳ¹«Ê½£ºÓÃÓÚר¼Òָʾ¼°²â²Î¡¢²âÖ¸¡£Îå²Ê£ËÏß¹«Ê½£ºÓÃÓÚ£ËÏßģʽָʾ¡£ÕâËÄÖÖ¹«Ê½Ï໥¶ÀÁ¢£¬Ãû³Æ¿ÉÒÔÏàͬ£¬µ«ÆäÄÚÈݺÍ×÷Óò»Í¬¡£Ã¿ÖÖÀàÐ͵Ĺ«Ê½°üÀ¨ËÄÖÖÐÎʽ£º ϵͳ¼ÓÃܹ«Ê½£ºÓÃÂÌɫͼ±êºÍËøÐηûºÅÏÔʾ£¬Òª½øÐÐÃÜÂëÈ·ÈÏ ÏµÍ³¹«Ê½£ºÓÃÂÌɫͼ±êÏÔʾ£¬¿É½øÐÐɾ¸Ä Óû§¼ÓÃܹ«Ê½£ºÓúìɫͼ±êºÍËøÐηûºÅÏÔʾ£¬Òª½øÐÐÃÜÂëÈ·ÈÏ Óû§¹«Ê½£ºÓúìɫͼ±êÏÔʾ£¬¿É½øÐÐɾ¸ÄÖ¸±ê¹«Ê½¸½¼ÓÂòÂôÂß¼­ÅжÏʽ£¬µÃµ½½»Ò×ϵͳ¹«Ê½£»Ö¸±ê¹«Ê½¸½¼ÓÑ¡¹ÉÌõ¼þÂß¼­ÅжÏʽ£¬µÃµ½Ìõ¼þÑ¡¹É¹«Ê½¡£Ö¸±ê¹«Ê½¸½¼ÓÉ«²ÊÂß¼­Åжϣ¬µÃµ½Îå²ÊKÏß¹«Ê½¡£

3.1 ¼¼ÊõÖ¸±ê¹«Ê½±à¼­Æ÷

¼¼ÊõÖ¸±ê¹«Ê½¼´Í¨³£Ëù˵»­ÏßÖ¸±ê£¬´ËÀ๫ʽµÄÖ÷ҪĿµÄÊÇͨ¹ý¶ÔÊý¾Ý²ÉÈ¡Ò»¶¨µÄÔËË㣬½«Êä³ö½á¹ûÖ±¹ÛµÄÏÔÏÖÔÚ·ÖÎöͼÉÏ£¬ÎªÍ¶×ÊÕßÌṩÑÐÅÐÐÐÇéµÄ»ù±¾ÒÀ¾Ý¡£´ËÀàÖ¸±êÖÁÉÙÒªÓÐÒ»ÌõÊä³öÏߣ¬Êä³ö°üÀ¨ÎÄ×Ö,ͼ±êµÈ£¬±¾ÏµÍ³ÀÏ°æ±¾ÔÊÐí×î¶à6ÌõµÄÊä³öÏߣ¬Ð°汾¿ÉÒÔÊä³ö50ÌõÊä³öÏß¡£¼¼ÊõÖ¸±ê¹«Ê½±à¼­Æ÷ʵÏÖ¶Ô¼¼Êõͼ±í·ÖÎöÖи÷À༼ÊõÖ¸±êºÍ×ÔÎÒ¶¨ÒåµÄ¼¼Êõ·ÖÎöÖ¸±êµÄ±àд£¬²¢ÇÒͨ¹ýTDXµÄ·ÖÎö½çÃæÐγÉͼ±í¡¢ÇúÏߣ¬ÒÔ·½±ãºÍÑ°ÕÒÓÐÒâÒåµÄ¼¼ÊõͼÐκͼ¼ÊõÌØÕ÷¡£

3.2 Ìõ¼þÑ¡¹É¹«Ê½±à¼­Æ÷

Ò²¾ÍÊÇͨ³£ÒâÒåÉϽâÊ͵ÄÖÇÄÜÑ¡¹É¡£µ«ÎÒÃǵÄÄ¿µÄÔÚÓÚ½¨Á¢Ò»¸öÍêÈ«¿ª·Å¡¢×ÔÓɵÄÑ¡¹Éƽ̨£¬¿ÉÒÔͨ¹ý¶Ô¸Ãƽ̨µÄÊìÁ·Ê¹Ó㬽èÖú¼ÆËã»úµÄ¸ßËÙºÍ׼ȷµÄ¼ìË÷¹¦ÄÜÑ°ÕÒÂú×ãÄúµÄÀí½âµÄ¹ÉƱÐÎ̬ºÍ¼¼ÊõÌØÕ÷£¬Èç¹ûºÍÔ¤¾¯ÏµÍ³½áºÏÆðÀ´Ó㬽«¿ÉÒÔÔÚÅÌÖÐʵʱÌáʾ·ûºÏÌõ¼þµÄ¹ÉƱ¡£Ìõ¼þÑ¡¹É¹«Ê½ÓÐÇÒ½öÓÐÒ»¸öÊä³ö£¬ÕâÊÇËüºÍ¼¼ÊõÖ¸±ê²»Í¬µÄµØ·½¡£

3.3 Îå²ÊKÏß¹«Ê½±à¼­Æ÷

׼ȷ½²£¬¸Ã±à¼­Æ÷µÄ¹¦ÄÜÊǸ½ÊôÓÚÌõ¼þÑ¡¹É¹¦ÄÜÖ®Éϵģ¬ÎÒÃÇ¿ÉÒÔͨ¹ý¸Ã¹¦Äܽ«Âú×ãÌõ¼þµÄÁ¬ÐøKÏßÐÎ̬¸³ÓèÑÕÉ«£¬Çø±ðÁËÆäËüµÄKÏß¡£ Ìõ¼þÑ¡¹É¹«Ê½ÓëÎå²ÊKÏß¹«Ê½µÄÇø±ð£ºÌõ¼þÑ¡¹É¹«Ê½ºÍÎå²ÊKÏß¹«Ê½¶¼ÓÐÇÒ½öÓÐÒ»¸öÊä³ö£¬ÆäÄ¿µÄ¶¼ÊÇΪͶ×ÊÕßÌṩÂòÈë»òÂô³öµãµÄָʾ£¬²»Í¬Ö®´¦ÔÚÓÚ£ºÌõ¼þÑ¡¹É¹«Ê½½ö¶Ô×î½üÊý¾ÝÌáʾÂòÈë»òÂô³ö£¬¶øÎå²ÊKÏß¹«Ê½Ôò¶ÔÊäÈëµÄËùÓÐÀúÊ·Êý¾Ý½øÐÐÌáʾ¡£ÁíÍ⣬Îå²ÊKÏß¹«Ê½µÄÊä³öÊÇÔÚKÏßͼÉÏ£¬Í¨¹ý¸÷ÖÖÑÕÉ«¶ÔÌáʾÊý¾Ý½øÐбêʶ£¬Ìõ¼þÑ¡¹É¹«Ê½µÄÊä³öÊÇÕÒ³ö·ûºÏ×î½üÌõ¼þµÄËùÓйÉƱ¡£

38

×÷ÕߣºÕÇÀ²

3.4 ½»Ò×ϵͳ¹«Ê½±à¼­Æ÷

½»Ò×ϵͳ¹«Ê½ÊÇͨ¹ýÉ趨ÂòÈëºÍÂô³öµã(ÓÐÇÒ½öÓÐÕâÁ½¸öÊä³ö)£¬ÓɼÆËã»ú½øÐÐÄ£Äâ²Ù×÷¡£ÒÔ´ËΪÒÀ¾Ý£¬ÏµÍ³Ò»·½Ãæ¿ÉÒÔ½øÐÐÎå²ÊKÏß¹«Ê½µÄ¹¦ÄÜ£¬Í¬Ê±ÌáʾÂòÈëºÍÂô³ö£»ÁíÒ»·½Ãæ¿ÉÒÔͨ¹ýÄ£Äâ²Ù×÷£¬¶ÔÖ¸±êÂòÂôµÄÊÕÒæ¡¢Ö¸±êµÄ×î¼Ñ²ÎÊý¼°×î¼ÑÖ¸±êµÈ¸÷ÇéÐνøÐвâÊÔ¡£½»Ò×ϵͳÊÇÔÚÌõ¼þÑ¡¹É¹¦ÄÜÉϵÄÒ»´Î´óµÄÑÓÉ죬ּÔÚ½¨Á¢Ò»Ì×ÍêÕûµÄ½»Ò×¹æÔòÌåϵ£¬Í¨¹ý¸Ã±à¼­Æ÷¶Ô¸÷¸öÏà¹ØµÄ½»Ò×»·½Ú£¬°üÀ¨ÂòÈëµÄÇÐÈë¡¢Âô³ö¡¢Ö¹ËðÒÔ¼°ÕûÌåµÄ½»Ò×ÐÔÄܼìÑéµÈµÈ×÷³ö¶¨Á¿µÄ¹æ¶¨£¬°ïÖúͶ×ÊÕß½¨Á¢Ò»Ì×ÊôÓÚ×Ô¼ºµÄÂòÂô¹æÔòºÍÀíÂÛ¡£

¹«Ê½ÏµÍ³(¸ß¼¶)

1. ÌØÊ⹫ʽ½Å±¾±àд

Òª±àдһ¸ö¹«Ê½£¬±ØÐëÒªÃ÷È·Õâ¸ö¹«Ê½¶ÔÓ¦µÄÀíÂÛ֪ʶ¡£Ò»Ì×ÍêÕûµÄÀíÂÛ֪ʶÇÒÄÜÔÚͨ´ïÐŵĹ«Ê½Æ½Ì¨ÉÏ×ö³É¹«Ê½»¹ÒªÂú×ãÈçÏÂÒªÇó£º

1. ´Ó¸ÃÀíÂÛÓ¦ÄÜ·ÖÎö³ö¹«Ê½Æô¶¯µÄÆðʼÊý¾Ý¡£Èç¹ÉƱµÄ¿ª¸ßµÍÊÕ¼Û¸ñ¡¢³É½»Á¿¡¢¸÷²ÆÎñÊý¾Ý¡¢¸÷¼´

ʱÊý¾Ý¡¢Ê±¼äÊý¾Ý¡¢Ò»Ð©³£¼ûµÄ¼¼Êõ·ÖÎö¸ÅÄî¡¢ÆäËûÀíÂ۵Ľá¹ûµÈ£¬ÕâЩÊý¾Ý´ó²¿·ÖÊÇϵͳÌṩµÄ£¬¶ø×îºóÁ½ÏîÔòÒª´ÓÆäËû¹«Ê½ÖеÃÀ´Ò²¾ÍÊǶÔÓ¦ÓÚ¹«Ê½±àдÖеÄÖ¸±êÒýÓòÙ×÷(µ±È»ÔÚÕ⹫ʽ±àдǰҪȷ±£¸ÃÒªÒýÓõÄÖ¸±êÒÑʵÏÖ)¡£

2. ´ÓÀíÂÛÖÐÓ¦ÄÜ·ÖÎö³öÆðʼÊý¾Ýµ½½á¹ûµÄÃ÷È·ÔËËã¹ý³Ì¡£ÔÚ¹«Ê½Æ½Ì¨ÖÐÌṩÁËһЩϵͳº¯Êý£¬ÕâЩ

º¯Êý°üº¬Á˲¿·Ö³£ÓõÄÔËËã¹ý³Ì(ÈçHHV(X,N) ¿ÉÇóNÖÜÆÚÄÚX×î¸ßÖµ)¡£Èç¹ûÀíÂÛÖеÄÔËËã¹ý³Ì²ð½âÍêÈ«ºó£¬ÄÜÓɹ«Ê½Æ½Ì¨Öеĺ¯Êý¼°ÔÊÐíµÄ»ù±¾ÔËËãÈ«²¿×é³É¾Í¿ÉÒÔ±àд³É¹«Ê½ÁË¡£

ÔÚ֮ǰµÄѧϰµ±ÖУ¬ÎÒÃÇÒѾ­¶Ô¹«Ê½ÏµÍ³¡¢¹«Ê½½Å±¾±à¼­ÓÐÁË»ù±¾µÄÈÏʶ¡£¹«Ê½ÏµÍ³Ìṩ¸øÎÒÃǵĻù±¾º¯Êý¡¢ÏµÍ³¹«Ê½£¬¾ÍÊÇÎÒÃÇÔËÓù«Ê½ÏµÍ³±àд×Ô¼ºµÄ¹«Ê½Ê±µÄ»ù±¾ÔªËØ¡£¶ÔÓÚһЩ³£¼ûµÄ¼¼Êõ·ÖÎö¸ÅÄîµÄ±àдÔÚÉÏÒ»Õ½ÚÒѾ­¸ø³öÁ˽éÉܺÍʾÀý£¬±¾Õ½ÚÖ÷ÒªÀ´½éÉÜÒ»ÏÂÔÚ¹«Ê½½Å±¾±àдÈç¹ûÓÃϵͳº¯Êý¼°»ù±¾ÔËËãÀ´½â¾öһЩÌØÊâÄÑÌâ¡£

1.1ÔÚ·ÖÖÓÖÜÆÚÏ»®·Ö½»Ò×ÈÕ

39

×÷ÕߣºÕÇÀ²

1. ¾ùÏߣ¨·ÖÖÓ£©£º

Ö¸±êÃû³Æ£º¾ùÏߣ¨·ÖÖÓ£©

Ö¸±êÔ­Àí£º¾ù¼Û=ÀÛ¼Ó×Ôµ±ÈÕ¿ªÊе½µ±Ç°KÏßʱ¼äÄڵijɽ»½ð¶î/ÀÛ¼Ó×Ôµ±ÈÕ¿ªÊе½µ±Ç°KÏßʱ¼äÄڵijɽ»Á¿¡£ ±àд·ÖÎö£º

1.È·¶¨½»Ò×ÈÕÄÚµÚÒ»¸ùKÏßµÄλÖã¨Äѵ㣩£»

2.×Ô1ÖÐÈ·¶¨µÄλÖÃÀۼӳɽ»½ð¶î¡¢³É½»Á¿£¨ÓÉϵͳº¯ÊýSUMʵÏÖ£©£» 3.Óɳɽ»½ð¶î¡¢³É½»Á¿Çó¾ù¼Û£¨Óɳý·¨²Ù×÷·ûʵÏÖ£©¡£

¹«Ê½½Å±¾£º

FIRST:=IF(PERIOD=0,HOUR=9 AND MINUTE=31, IF(PERIOD=1,HOUR=9 AND MINUTE=35, IF(PERIOD=2,HOUR=9 AND MINUTE=45, IF(PERIOD=3,HOUR=10 AND MINUTE=0, IF(PERIOD=4,HOUR=10 AND MINUTE=30,0)))));

SUM(AMO,BARSLAST(FIRST)+1)/SUM(VOL,BARSLAST(FIRST)+1);

ÉÏÃæµÄ¹«Ê½ÊÊÓÃÓÚ1·ÖÖÓ£¬5·ÖÖÓ£¬15·ÖÖÓ£¬30·ÖÖÓ£¬60·ÖÖÓµÈÎå¸öÖÜÆÚÏ¡£½«¸ø³öÿ¸ö½»Ò×ÈÕÖи÷ÖÜÆÚϾùÏßµÄ×ßÊÆ¡£¹«Ê½½Å±¾±àдÖеÄÖصã¾ÍÊÇFirst±äÁ¿µÄÈ·¶¨£¬ÕâÒ²ÊÇÕâ¶Î½Å±¾µÄÁÁµã¡£First±äÁ¿±íʾµÄÊǵ±ÈÕµ±Ç°ÖÜÆڵĵÚÒ»¸ùKÏßλÖã¬ÊÇͨ¹ýIFº¯ÊýµÄǶÌ×ʹÓýáºÏ¸÷·ÖÖÓÖÜÆڵĵÚÒ»¸ùKÏßµÄʱ¼äµÃÀ´µÄ¡£

1.2 ¿çÖÜÆÚÒýÓÃÊý¾Ý

ÔÚͬһ¸ö¹«Ê½½Å±¾ÖУ¬ËùÓбäÁ¿µÄÊý¾ÝÖÜÆÚ¶¼ÊÇÏàͬµÄ£¬¾ÍÊǵ÷Óù«Ê½Ê±ÉèÖõÄÖÜÆÚ¡£ÔÚ¹«Ê½½Å±¾ÖÐÒªÓÃÆäËüÖÜÆÚµÄÊý¾Ý£¬¹²ÓÐÁ½ÖÖ·½Ê½£º

1£© ¶Ô±äÁ¿ÓñäÖÜÆÚ·ûºÅ£¨#£©£¬¸Ä±äÆäÖÜÆÚ¡£ÕâÖÖ·½Ê½ÓоÖÏÞÐÔ£¬Ö»ÄÜÔÚСÖÜÆÚ¹«Ê½Öеõ½´óÖÜÆÚÊý

¾Ý£¬ÇÒ½öÊÊÓÃÓÚһЩ»ù±¾Êý¾Ý£¬Èçclose£¬high£¬low£¬openµÈ¡£ ʾÀý½Å±¾£º ÈÕ×î¸ß¼Û:H;

ÖÜ×î¸ß¼Û:H#WEEK; ÔËÐÐʾÀý£º

40