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

[µo°Ý] ³o°Ý°}¦Cªº¬Û¥[¬O§_¦³¨ä¥¦ªº¼gªk¦³§ó§Öªº°õ¦æ³t«×

[µo°Ý] ³o°Ý°}¦Cªº¬Û¥[¬O§_¦³¨ä¥¦ªº¼gªk¦³§ó§Öªº°õ¦æ³t«×

Function Cal_Avg_xDay(Date_I, xDay) As Double   ' ­p¼Æ¤ë½u/©u½u
ReDim xDay_Sum(xDay)
For j = 1 To xDay
   xDay_Sum(j) = AR(3)(Date_I - j + 1, BT_Stock_I)
Next
Cal_Avg_xDay = WorksheetFunction.Round(WorksheetFunction.Average(xDay_Sum), 2)
End Function

§Ú¼g¤F¤@­Ó function, ¥Î¨Ó­pºâªÑ»ùªº¤ë½u/©u½u¡C¶Ç¤J­È¬°·í¤é¤é´Áªºindex¡AxDay¬°20or60¡C
½Ð°Ý¦³¨ä¥¦¸û²¼äªº¼gªk¥H¤Î§ó§Öªº°õ¦æ³t«×¶Ü¡AÁÂÁ¡C
¤pµæ³¾¤@­Ó ½Ð¦h«ü±Ð~

¦^´_ 1# kasl

¤£­n¥Îworksheetfunction ·|§ó§Ö
ss

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD