期貨交易理論與實務

發表文章

目前顯示的是 11月, 2020的文章

第13週WORD巨集+表單+TypeText+TypeParagraph+字串

11月 29, 2020

Const period As Integer = 4 Const maxerror As Double = 0.0000001 Dim payment(period) As Double '廣域變數 4 維度的陣列 Private Sub CommandButton1_Click() Dim a, b, c, f, gap As Double Dim loopNumber As Integer a = 0 b = 1 gap = 10 loopNumber = 10 payment(0) = TextBox1.Value payment(1) = TextBox2.Value payment(2) = TextBox3.Value payment(3) = TextBox4.Value f = npv(a) If f = 0 Then Label9.Caption = 0 ElseIf f < 0 Then Label9.Caption = "內部報酬率小於 0." Else Do While gap > mexerror And Abs(f) > maxerror And loopNumber < 100 loopNumber = loopNumber + 1 c = (a + b) / 2 f = npv(c) If Abs(f) > maxerror And gap > maxerror Then If f > 0 Then a = c Else b = c gap = b - a End If Else Label9.Caption = c * 100 End If Loop End If Label10.Caption = f Label11.Caption = loopNumber '以下是將結果輸出到 WORD 文件 Sel

閱讀完整內容

第12週劉任昌教你金融計算

11月 22, 2020

躉繳第1期第2期第3期注意，包含首期躉繳的現金流量都大於0。輸出: 報酬率: 淨現值: 迴圈次數: 劉任昌向劉任昌學習的程式碼劉任昌向劉任昌學習的程式碼 <head> <style> h1 { margin: 3; padding: 20px 0; color: #00539F; text-shadow: 3px 3px 1px black; } .Takming { border: 20px outset red; background-color: green; color: white; text-align: center; } .pmt { width: 60pt; height: 20pt; background-color: coral; color: white; text-align: right;} </style> </head> <body> <table border="1"> <tr align="center"><td>躉繳</td><td>第1期</td><td>第2期</td><td>第3期</td></tr> <tr><td><input class="pmt" type="number" /></td> <td><input class="pmt" type="number" /></td> <td><input class="pmt" type="number" /></td> <td><input class="pmt" type="number"