ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Â^¨ú¾ú¥vªÑ»ù

¦^´_ 10# diabo


    ¤£¦n·N«ä¡A¦³¿ìªk¬d ¤j½Lªº¦¨¥æ¶qª÷ÃB¸ê®Æ¶Ü¡H

TOP

diabo

TOP

À³jsleee­n¨D

Ãö©ó¤j½L¦¨¥æ¶q¥i°Ñ¦Òhttp://forum.twbts.com/thread-6750-1-2.html

TOP

¤j½Lªº¥|»ù(¶}°ª§C¦¬)¸ê®Æ³Ì¦n»P¦¨¥æ¶q¸ê®Æ³£±qTWSE¨Ó¤ñ¸û¨S°ÝÃD¡A¤£­n¤@¤U¤lYahoo Finance ¤@¤U¤lTWSE

http://www.twse.com.tw/ch/trading/indices/MI_5MINS_HIST/MI_5MINS_HIST.php?myear=101&mmon=05
http://www.twse.com.tw/ch/trading/exchange/FMTQIK/genpage/Report201206/201206_F3_1_2.php?STK_NO=&myear=2012&mmon=06
diabo

TOP

diabo¤j¤j
¦³¯à¤O½Ð¦Û¦æ¼g¥X¨Ó¥Î,¤£­n¦b©ê«èªF©ê«è¦èªº

TOP

¥»©«³Ì«á¥Ñ diabo ©ó 2012-6-6 23:52 ½s¿è

¦^´_ 16# white5168

§Ú¬O¦n·N´£¿ô¡AYahoo finance ³B²zªº¤é¦¨¥æ¸ê°T¡A¦]¬°¨S¦³¯S§O³B²z¥xÆWªº¼u©Ê©ñ°²»P¸É­×ªº°ÝÃD¡A©Ò¥H¨C¤é¦¨¥æ¸ê®Æ¼Æ¶q»P¥xÆWÃÒ¥æ©Ò¸ê®Æ¦³©Ò¤£¦P¡A½Ð¦Û¦æ¤ñ¸û´Nª¾¹Dªº¡C

§Ú¥i¥H´£¨Ñ¦Û¥ÎªºExcel½d¨Ò¨Ñ°Ñ¦Ò(µ{¦¡½X¨SÂê¡A§¹¥þ¤½¶})¡A½Ð¦Û¦æ¤U¸üªþ¥ó¡C

download_twii.rar (174.4 KB)
1

µû¤À¤H¼Æ

    • GBKEE: µ{¦¡½X¨SÂê¡A§¹¥þ¤½¶} ½×¾Â­n¥æ¬y´N¬O¦p¦¹ª÷¿ú + 2
diabo

TOP

¦^´_ 17# diabo


    ½Ð°Ý¦pªG¬O¤W¥«¡B¤WÂdªº¾ú¥vªÑ»ù¸ê®Æ¬d¸ß, ¬O§_¤]¯à´£¨Ñ? ÁÂÁ¡C
manny

TOP

¦^´_ 16# diabo

¦]§Ú¬O·s¤â,¦³¤£©ú¥Õ³B½Ð±Ð  
½Ð  diabo ¤j¤j:  »¡©ú
        
         Sub §ó·s¤j½L¸ê®Æ() ¤¤
            If ³Ì«á¤@µ§¸ê®Æ¦C¼Æ = 1 Then   
         
           1 --> ªº¥Îªk

         ÁÂÁÂ!!

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2012-8-12 06:07 ½s¿è

¦^´_ 18# tsuneng

         Sub §ó·s¤j½L¸ê®Æ() ¤¤
            If ³Ì«á¤@µ§¸ê®Æ¦C¼Æ = 1 Then   
         
           1 --> ªº¥Îªk

    ÁöµM¬Ý¤£¨ì§¹¾ãµ{¦¡½X
¤£¹L±q³o¤ù¬q¬Ý¨Ó¡A°õ¦æ³o­Ó§PÂ_¤§«eÀ³¸Ó·|¦³¬q­pºâ
³Ì«á¤@µ§¸ê®Æ¦C¼Æ=XXX¹Bºâ¦¡
¤~¨Ó§PÂ_"³Ì«á¤@µ§¸ê®Æ¦C¼Æ"³o­ÓÅܼƬO§_µ¥©ó1
³o¼Ë±ÀÂ_¤£ª¾¹ï§_¡A½Ð¦U¦ì«e½ú«ü¥¿

TOP

¦^´_ 19# white945

´L­«­ì§@ªÌ¡A¥u¶K¥X³¡¥÷µ{¦¡½X.

With Sheets("TWII")
        ¸ê®Æ®w³Ì«á¤@µ§¸ê®Æ¦C¼Æ = .Cells(Rows.Count, "A").End(xlUp).Row
        If ¸ê®Æ®w³Ì«á¤@µ§¸ê®Æ¦C¼Æ = 1 Then
            ¸ê®Æ®w³Ì«á¤@µ§¤é´Á = DateSerial(1999, 1, 1)
        Else
            ¸ê®Æ®w³Ì«á¤@µ§¤é´Á = .Cells(¸ê®Æ®w³Ì«á¤@µ§¸ê®Æ¦C¼Æ, "A").Value
        End If
        ¸ê®Æ®w·s¸ê®Æ¼g¤J¦C¼Æ = ¸ê®Æ®w³Ì«á¤@µ§¸ê®Æ¦C¼Æ + 1
    End With

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD