£¨1£©´ò¿ªExcel-VBA»òÖ±½Ó´ò¿ªExcel°´ALT+F11£¬ÌùÉϳÌÐò£¨¼û×îºó£©¡££¨2£©ÔÚexcelµ±Öн¨Á¢Èçͼ±í¸ñ£¬±ê»Æ²¿·ÖÐèÒªÊÖ¶¯±ä»¯¡£
£¨3£©ÔÚCÁÐÏàÓ¦±í¸ñÊäÈëÒÔϹ«Ê½¡£
£¨4£©²ÎÊý˵Ã÷¡£
s£¬¾ÍÊDZêµÄ֤ȯµ±Ç°¼Û¸ñ£¬ÎÄ ... Õ¹¿ª
£¨1£©´ò¿ªExcel-VBA»òÖ±½Ó´ò¿ªExcel°´ALT+F11£¬ÌùÉϳÌÐò£¨¼û×îºó£©¡££¨2£©ÔÚexcelµ±Öн¨Á¢Èçͼ±í¸ñ£¬±ê»Æ²¿·ÖÐèÒªÊÖ¶¯±ä»¯¡£
£¨3£©ÔÚCÁÐÏàÓ¦±í¸ñÊäÈëÒÔϹ«Ê½¡£
£¨4£©²ÎÊý˵Ã÷¡£
s£¬¾ÍÊDZêµÄ֤ȯµ±Ç°¼Û¸ñ£¬ÎÄÖÐÒÔÉÏÖ¤50ETFΪÀý¡£
k£¬¾ÍÊÇÐÐȨ¼Û£¬¼ÙÉèÎÒÃÇÒªËãµÄÊÇ2.15µÄcallºÍput¡£
t£¬Ä껯µÄµ½ÆÚÊ£ÓàÈÕ£¬Õâ¸öµØ·½Òª×¢ÒâµÄÊÇÓÐÈËÓÃ365ÌìÀ´Ä껯£¬Ò²ÓÐÈËÒ»ÄêÊÇÓù¤×÷ÈÕ255×óÓÒ£¬ÎÄÖÐʹÓõÄÊÇ255Ìì
r£¬ÄêÀûÂÊ£¬ÄÃÒ»Ä궨´æÀûÂʼÆË㣬ÒÔ2%ΪÀý¡£
v£¬ÀúÊ·²¨¶¯ÂÊ£¬²¨¶¯ÂÊÊÇÖØÒªµÄÄÚÈÝ£¬Õâ±ßÒÔ40%ΪÀý¡£
¸½Excel-VBA³ÌÐò£º
Function cal_d1(s As Double, k As Double, t As Double, r As Double, v As Double) As Double
cal_d1 = (Log(s / k)+ (r + v ^ 2 / 2) * t) / (v * Sqr(t))
End Function
Function cal_d2(s As Double, k As Double, t As Double, r As Double, v As Double)
cal_d2 = cal_d1(s,k, t, r, v) - v * Sqr(t)
End Function
Functioncalloption(s As Double, k As Double, t As Double, r As Double, v As Double)
calloption = s *Application.NormSDist(cal_d1(s, k, t, r, v)) - k * Exp(-(r * t)) *Application.NormSDist(cal_d2(s, k, t, r, v))
End Function
Function putoption(s As Double, k As Double, t As Double, r As Double, v As Double)
putoption = k *Exp(-r * t) * Application.NormSDist(-cal_d2(s, k, t, r, v)) - s *Application.NormSDist(-cal_d1(s, k, t, r, v))
End Function
ÊÕÆð
ͨ½³ 2024-2-19 лл·ÖÏí£¬ºÜÓÐÊÕ»ñ¡£