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 |