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

[¤À¨É] ¤j½L¨C¤ë¨C¤Ñ¾ú¥v¦¨¥æ¶q»Pª÷ÃB¤U¸ü

¦^´_ 24# GBKEE

½Ð°ÝGBKEE¤j¤j

§Ú¦b"­pºâ"¤u§@ªíªº¨â­ÓÄæ¦ì "call-oi$" "put-oi$",­n§¹¦¨¤W­z°ÝÃDªº¼Æ¾Ú­pºâ,½Ð°Ý­n¦p¦ó­×¥¿?ÁÂÁ±zªº¨ó§U

TEST.zip (99.9 KB)

stock

TOP

¦^´_ 27# GBKEE


   ¥i¥H¥¿±`°õ¦æ¤F
«D±`·PÁÂGBKEE¤j¤jªº¼ö¤ß¨ó§U,ÁÂÁ±z
stock

TOP

¦^´_ 27# GBKEE

GBKEE¤j¤j¯u©êºp
§Ú¦Û¤v·s¼W¥[¤@¨ÇªF¦è,ÁÙ¦³¥H¤U°ÝÃD
1.¥i§_¦b''­pºâ''ªº¤u§@ªí¤¤²Ä278¦C¥[¤W¥[Á`ªº­pºâ?³o¤@¦C¬O§_·|ÀH¸ê®Æ·½¨C¤ëÅܰʦÓÅÜ°Ê?
2.¦b''­pºâ''ªº¤u§@ªí¤¤¤w¥[¤W"§ó·s"³o­Ó«ö¶s¨Ó±±¨î§ó·s,«ö¤U«á,¸ê®Æ¶i¨Ó,¦ý¬O«ö¶s¤£¨£¤F?

½Ð°Ý­n¦p¦ó­×¥¿?ÁÂÁ±z¼·ªÅ«ü¾É,ÁÂÁÂ...

TEST2.zip (34.86 KB)

stock

TOP

¦^´_ 30# GBKEE

¤w¥¿±`°õ¦æ
¯uªº«D±`·PÁÂGBKEE¤j¤jªº¼ö¤ßÀ°¦£,ÁÂÁ±z
stock

TOP

¦^´_ 30# GBKEE


GBKEE¤j¤j,§Ú­è­è°õ¦æµ{¦¡,µo²{¤p­pºâ¥Xªº¼Æ­È³£¤£¥¿½T,½Ð°Ý­n­×§ï­þ¸Ì?¤£¦n·N«ä¦A³Â·Ð±zÀ°¦£,ÁÂÁ±z
  1. Option Explicit
  2. Private Sub §ó·s()
  3.     With ActiveSheet
  4.         .Cells.Clear
  5.         With .QueryTables.Add("URL;http://www.taifex.com.tw/chinese/3/3_2_2.asp", ActiveSheet.[A1])
  6.             .WebFormatting = xlWebFormattingNone
  7.             .Refresh BackgroundQuery:=False
  8.             ActiveSheet.Names(.Name).Delete
  9.         End With
  10.         .Range("E:G,I:L,N:Q").Delete                                    '§R°£¦h¾lªºÄæ
  11.         .Range("1:6,8:8").Delete                                        '§R°£¦h¾lªº¦C
  12.         .Range("B1").End(xlDown).Offset(1).Resize(2).EntireRow.Delete   '§R°£¦h¾lªº¦C
  13.         .Range("A:A").Insert                                            '´¡¤J¤@Äæ
  14.         .[B1].Resize(, 12) = Array("«´¬ù", "¤ë¥÷", "¼i¬ù»ù", "¶R½æÅv", "¦¨¥æ»ù", "¥¼¥­­Ü¶q", "CALL", "=C2", "call-oi", "put-oi", "call-oi$", "put-oi$")
  15.         '**  "=C2" ¥i­×§ï¬° ¥¿½Tªº°Ñ·Ó  ***
  16.         With .Range("b2", .[b2].End(xlDown))
  17.             .Offset(, -1) = "=rc4 +rc8 + rc9"
  18.             .Columns(5).Replace "-", ""
  19.             .Columns(7) = "=IF(rc[-3]=""Call"",1,0)"    'R1C1ªí¥Üªk : ¤u§@ªí¤Wß}¤J¤½¦¡
  20.             .Columns(8) = "=IF(rc[-6]=r1c9,1,8)"
  21.             .Columns(9) = "=IF(rc[-2]=1,rc[-3],0)"
  22.             .Columns(10) = "=IF(rc[-3]=0,rc[-4],0)"
  23.             .Columns(11) = "=if(rc[-1]=0,rc[-6]*rc[-5],"""")"
  24.             .Columns(12) = "=if(rc[-2]<>0,rc[-7]*rc[-6],"""")"
  25.         End With
  26.         .UsedRange.Value = .UsedRange.Value             '®ø°£¤½¦¡
  27.         .Columns.AutoFit
  28.         With .Range("b2", .[b2].End(xlDown))
  29.             .Offset(, -1) = "=rc4 +rc8 + rc9"
  30.             .Columns(5).Replace "-", ""
  31.             .Columns(7) = "=IF(rc[-3]=""Call"",1,0)"    'R1C1ªí¥Üªk : ¤u§@ªí¤Wß}¤J¤½¦¡
  32.             .Columns(8) = "=IF(rc[-6]=r1c9,1,8)"
  33.             .Columns(9) = "=IF(rc[-2]=1,rc[-3],0)"
  34.             .Columns(10) = "=IF(rc[-3]=0,rc[-4],0)"
  35.             .Columns(11) = "=if(rc[-1]=0,rc[-6]*rc[-5],"""")"
  36.             .Columns(12) = "=if(rc[-2]<>0,rc[-7]*rc[-6],"""")"
  37.              With .Cells(.Rows.Count + 1, 1) '.Rows.Count + 1 ½d³ò¤º¸ê®ÆÁ`¦C¼Æ+1
  38.                 .Cells(1, 0) = "¤p­p"
  39.                 .Cells(1, 6) = Application.Sum(.Parent.Columns(6))
  40.                 .Cells(1, 9) = Application.Sum(.Parent.Columns(9))
  41.                 .Cells(1, 10) = Application.Sum(.Parent.Columns(10))
  42.                 .Cells(1, 11) = Application.Sum(.Parent.Columns(11))
  43.                 .Cells(1, 12) = Application.Sum(.Parent.Columns(12))
  44.             End With
  45.         End With
  46.     End With
  47. End Sub
½Æ»s¥N½X
stock

TOP

¦^´_ 33# GBKEE


    ÁÂÁÂGBKEE¤j¤jªº§Ö³t¦^À³,¥i¥H¥¿½Tºâ¥X¤p­p¤F,¦A¦¸·PÁ±zªº¼ö¤ß¨ó§U,¯¬±z¶g¥½´r§Ö...
stock

TOP

¥»©«³Ì«á¥Ñ usana642 ©ó 2012-10-24 18:10 ½s¿è

¦^´_ 33# GBKEE

¦A½Ð±ÐGBKEE¤j,§Ú¦A¼W¥[¤@­Ó''¬ö¿ý''¤u§@ªí,§â­pºâ«áªº¤p­p,¦Û°Ê¶×¤JÀx¦s,¦pªG¹j¤Ñ¦A«ö''­pºâ''¤u§@ªíªº''§ó·s''«ö¶s«á,§Æ±æ¯à¦b''¬ö¿ý''¤u§@ªí¦Û°ÊÀx¦s·í¤Ñ­pºâ«áªº¤p­pµ²ªG,Àµ½ÐGBKEE¤j¤j¦A¦¸¨ó§U,ÁÂÁ±z...
[attach]12878[/attach]
stock

TOP

¥»©«³Ì«á¥Ñ usana642 ©ó 2012-10-24 18:14 ½s¿è

¦^´_ 33# GBKEE

¤£¦n·N«ä,¨S¦³¤W¶Ç¦n,¦A¤W¶Ç¤@¦¸

TEST2.zip (49.2 KB)

TEST2.zip (49.2 KB)

stock

TOP

¦^´_ 45# GBKEE

ÁÂÁÂGBKEEªº¼ö¤ß¨ó§U,¥i¥H¥¿±`°õ¦æ¤F,«D±`·PÁ±z,¯¬±z¨Æ¨Æ¶¶¤ß
stock

TOP

¥»©«³Ì«á¥Ñ usana642 ©ó 2012-10-25 13:34 ½s¿è

¦^´_ 45# GBKEE

GBKEE¤È¦w
§Ú·Q¦A½Ð±Ð±z
½Ð°Ý¦pªG§Ú·Q¦b''³sµ²''¤u§@ªí¤¤,¬D¿ï¥X¶RÅv©M½æÅvªº³Ì¤j¥¼¥­­Ü¶q,
¨Ò¦p24¤é¬O
½æÅv   ¼i¬ù»ù=7000        ³Ì«á¦¨¥æ»ù=27.5  ¥¼¥­­Ü¶q=38191
¶RÅv   ¼i¬ù»ù=7700        ³Ì«á¦¨¥æ»ù=11.5  ¥¼¥­­Ü¶q=57082

µM«á¤À§O¦Û°ÊÀx¦s¦b''¬ö¿ý''¤u§@ªí¤¤,¨C¤Ñªºµ²ªG¤]¯à¬ö¿ýÀx¦s,¦A¦¸Àµ½Ð±zªºÀ°¦£,ÁÂÁ±z
TEST2.zip (52.74 KB)

TEST2.zip (52.74 KB)

stock

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD