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

[µo°Ý] ºô­¶URL¦p¦óÂ^¨ú?

[µo°Ý] ºô­¶URL¦p¦óÂ^¨ú?

°ª¤â¦n:

¶i¤J³o­Óºô§}http://www.msci.com/products/indices/performance.html
§Ú¦bmsci index¤U¿ïEAFEÂI¶i¥h,¤§«á¦³¬Ý¨ì¤@­Óexcel Download Data
¦pªG,§Ú­n³æ¯Â±o¨ìDownload Data ªºurl­n¦p¦ó¨ú±o?

§Ú·Q­nª½±µ¨ú±ourlª½±µ¿é¤Jurl´N¥i¥H±qDownload Data ¤U¸ü§Ú­nªºexcelªí®æ¸ê®Æ

·P®¦


§Æ±æ¥i¥H¶¶«K´£¨Ñ¤èªk ·P®¦

§A¥u¬O­n¤U¸üexcelÀɮ׶Ü?
ÁÙ¬O¶¶«K­n¸ÑªR¤º®e?½Ð¸Ô²Ó»¡©ú§A»Ý­nªº¶µ¥Ø

TOP

¦^´_ 1# taiwandepend


    use VBA to download & save CSV from URL
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# Hsieh


    H¤j

¥i¬O¦pªG§Ú·Q¨ú¥XURLªººô§}­n¦p¦ó°µ©O?
·P®¦

TOP

¦^´_ 5# taiwandepend

§Ú¬Ý¤£À´³oºô­¶¦p¦ó¾Þ§@
½Ðªþ¹Ï»¡©ú­n¤U¸üªº¾Þ§@¦ì¸m
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

³o­Óºô§}¯uªº«ÜÃø¸Ñ,¤£¹L§Ú·Q­n±N¥¦µ{¦¡¤Æ¤]¤£®e©ö,¦pªG¹ïºô­¶¤£¼ôªºÁÙ¯uªº«ÜÃø¸Ñ,¥ýµ¹§Aºô§},¦³»Ý­n¥ÑVBAªº¸Ü¦A»¡
http://www.mscibarra.com/webapp/indexperf/charts?indices=108,C,36&startDate=31 Dec, 1969&endDate=31 Dec, 2020&priceLevel=0&currency=15&frequency=M&scope=R&format=XLS&baseValue=false&site=gimi

TOP

¦^´_ 7# white5168


    ·P®¦W¤j¤j
½Ð°Ý§A¬O¦p¦ó§ä¨ìªº

·P®¦

TOP

À˵ø-->­ì©lÀÉ  ¸Ì­± §ä§ä¬Ý
­YµL¶~¨Æ±¾¤ßÀY
«K¬O¤H¶¡¦n®É¸`

TOP

³o­Óºô§}¯uªº«ÜÃø¸Ñ,¤£¹L§Ú·Q­n±N¥¦µ{¦¡¤Æ¤]¤£®e©ö,¦pªG¹ïºô­¶¤£¼ôªºÁÙ¯uªº«ÜÃø¸Ñ,¥ýµ¹§Aºô§},¦³»Ý­n¥ÑVBAªº ...
white5168 µoªí©ó 2012-6-3 13:38



·Q½Ð°ÝW¤j~§Ú¦ü¥G¤]¦³Ãþ¦üªº°ÝÃD
§Ú·Q¨ì³o³sµ²http://www.jihsun.com.tw/  ¡÷·sª÷¿Ä°Ó«~¡÷»{°â(ÁÊ)ÅvÃÒ¥«³õ¦æ±¡ªí(¨C¤é§ó·s)
¤U¸ü³Ì·s¤é´ÁªºExcelÀɧ@½s¿è¡A¤£¹L¥¦ªººô§}³Ì«á´X­Ó¼Æ¦r³£·|§@ÅÜ°Ê¡A¤£ª¾¹D¸Ó«ç»ò³B²z¡A
©Ò¥H·Q½Ð°Ý¦³¿ìªk¶Ü?

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD