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

[µo°Ý] ½Ð±Ð¦p¦ó­×§ïµ{¦¡¨Ó´£°ª°õ¦æ®Ä²v©O?

¦^´_ 15# Andy2483
¨ºÀ³¸Ó¬O»~§R¤F¡A­n¥[¦^¥h

TOP

¦^´_ 12# ÂŤÑÄR¦À

¦³µ{¦¡½X,¦ý¬O¤£·|³Q°õ¦æ,¦]¬°¤Ö¤F Call Price,©Ò¥H­n½T©w¤@¤U¥¿½Tµ{¦¡½X¬O¦p¦ó¹B§@
Option Explicit
Private Sub Worksheet_Calculate()
Call RecordPrice
End Sub
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 13# Andy2483

©êºp¡A§Ú¤H¦b¥~­±¡AµLªk¶}ÀɮסA§Ú¦^¥h«á¦A¸ò§A½T»{¡A·PÁ§A

TOP

¦^´_ 10# ÂŤÑÄR¦À


i14¨ìi18¬O¦³¥Î¨ìif¥h°µ§P§O¡AµM«á¤~°µ¼Æ¦r¹B°e
¨S¦³¬Ý¨ì °µ¼Æ¦r¹B°eªº¤½¦¡©Îµ{¦¡½X
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 8# Andy2483
©êºp¡A¦³price¡A§Ú¥Î¤â¾÷¦^ªº¡A¨S¬Ý¨ìªþ¥ó¡Aprice¤º®e´N¬O°õ¦æ¶À¦â¤W­±³¡¤Àªº½Æ»s¡A½Æ»s¨ì¤U­±¡AµM«á¥h°µ¹B°eªü¡A§Úªºªþ¥ó¸Ì­±¨S¦³¶Ü¡HÁÙ¬O§Ú»~§R¤F

TOP

¥»©«³Ì«á¥Ñ Andy2483 ©ó 2024-1-18 14:27 ½s¿è

¦^´_ 9# ÂŤÑÄR¦À


    [B2]=I14+I15+I16+I17+I18
³o¸òSub Price() ¦³Ãö«Y,¤S»¡¥i¥H§R°£,¦³¥Ù¬Þ
¬O§_¦³·sªº½d¨ÒÀÉ
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2024-1-18 14:25 ½s¿è

¦^´_ 8# Andy2483
¥t¥~andy¡A½Ð±Ð¤@¤U¡A§Ú¶À¦â³¡¤Ài14¨ìi18¬O¦³¥Î¨ìif¥h°µ§P§O¡AµM«á¤~°µ¼Æ¦r¹B°e¡A¦ý§A¤W­±¶Kªºµ{¦¡½X¤]¦³°µ§P§OµM«á¹Bºâªº¥\¯à¡H

TOP

¦^´_ 8# Andy2483
¥i¥H§R°£

TOP

¥»©«³Ì«á¥Ñ Andy2483 ©ó 2024-1-18 14:21 ½s¿è

¦^´_ 7# ÂŤÑÄR¦À


    ½d¨Ò¤u§@ªí¼Ò²Õ¸Ì¨S¦³Call Price,¥¦»Ý­n°õ¦æ¶Ü?
¸Ì­±¦³µ{¦¡ Sub Price() ¦ý¤S¨S³Q Call Price
I14-I18¸òN14-N18ªº¼Æ­È¤S¸ò¥¦¦³Ãö
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 6# Andy2483
Andy¯à¼g­Ó¤j·§§Ú¥h°õ¦æ¬Ý¬Ý¶Ü¡H¤£µM§A³o¼Ë»¡§Ú¤]¤£¤Ó²M·¡¡A¯à¤£¯àÁÙ¬O­n°õ¦æ«á¤~¯à½T©w

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD