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

[µo°Ý] ¨D±Ï!³Ìªñ¨Ï¥Îvba excel web¤U¸ü¨C¤éªÑ»ùºô¯¸®É¡A¹J¨ì©Ç°ÝÃD

[µo°Ý] ¨D±Ï!³Ìªñ¨Ï¥Îvba excel web¤U¸ü¨C¤éªÑ»ùºô¯¸®É¡A¹J¨ì©Ç°ÝÃD

¥»©«³Ì«á¥Ñ ashin1981 ©ó 2016-8-19 21:43 ½s¿è

¦U¦ì¤j¤j¦n!

¤p§Ì³Ìªñ¹J¨ì¤@­Ó©Ç°ÝÃD¡A¹ê¦b¤£ª¾­n«ç»ò¸ÑÄÀ¡A¤p§Ì¦³¼g¤@­Óµ{¦¡excel  vba web¤è¦¡±N¸ê®Æ¤U¸ü¨ìexcel¡A¦ý³Ìªñ¬O¦b8¤ë¥÷®É·|¥X²{¤@¨Ç°ÝÃD¡A¤§«e³£«Ü¥¿±`¤U¸ü¡A©Ò¥H¤£¾å±o¬O¤£¬Otwseºô¯¸ªº°ÝÃD¡C

¤U­±ºô§}¦pªG¦b8¤ë¡B7¤ë³£¥i¥H¥¿±`¥X²{¡AµL½×¬O­þ¤@­ÓªÑ»ù¥N¸¹¡A¦ý¬O·í¤U¸ü6¤ë¡B5¤ë¡B4¤ë´N·|¶}©l¥X²{°ÝÃD(¥H«e³£¤£·|)
http://www.twse.com.tw/ch/trading/exchange/STOCK_DAY/genpage/Report201608/201608_F3_1_8_2329.php?STK_NO=2329&myear=2016&mmon=08 (¥¿±`)
http://www.twse.com.tw/ch/trading/exchange/STOCK_DAY/genpage/Report201607/201607_F3_1_8_2329.php?STK_NO=2329&myear=2016&mmon=07 (¥¿±`)

¤p§ÌÁ|¤@­Ó¨Ò¤l¨Ó»¡¡A¤U­±¨â­Óºô§}¡A¥u®t¦b¤ë¥÷°Ñ¼Æ(4¤ë¥÷©M3¤ë¥÷)¤£¦P¡A¦ý¬O²Ä¤@­Óºô§}¿é¤J¨ìÂsÄý¾¹ºô§}¡A¥L·|¥¿±`Åã¥Ü¡A²Ä¤G­Ó´NµLªkÅã¥Ü¡A¦ý¬O
©_©Çªº¬O¡A¦pªG­nÅý3¤ë¥÷¥¿±`ªº¸Ü¡A¥i¥H¥ý¥Î¤â°Ê¬d¸ß3¤ë¥÷«á¡A¤§«á3¤ë¥÷ªººô§}¿é¤J¨ìÂsÄý¾¹ºô§}®É´N¥i¥H¥¿±`Åã¥Ü¡A¨º¤§«á¥h¶]µ{¦¡®É¡A´N¥i¥H¤U¸ü3¤ë¥÷ªº¸ê®Æ¤F¡C
1.http://www.twse.com.tw/ch/trading/exchange/STOCK_DAY/genpage/Report201604/201604_F3_1_8_2329.php?STK_NO=2329&myear=2016&mmon=04
2.http://www.twse.com.tw/ch/trading/exchange/STOCK_DAY/genpage/Report201603/201603_F3_1_8_2329.php?STK_NO=2329&myear=2016&mmon=03

§Æ±æ½Ð¦U¦ì°ª¤âÀ°À°¤p§Ì¡AÁÂÁÂ!

¦^´_ 1# ashin1981
¨C¤éªÑ»ùºô¯¸ ¥i°Ñ http://forum.twbts.com/thread-12590-1-1.html
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD