- 帖子
- 4901
- 主題
- 44
- 精華
- 24
- 積分
- 4916
- 點名
- 84
- 作業系統
- Windows 7
- 軟體版本
- Office 20xx
- 閱讀權限
- 150
- 性別
- 男
- 來自
- 台北
- 註冊時間
- 2010-4-30
- 最後登錄
- 2025-4-8
               
|
6#
發表於 2012-6-7 21:51
| 只看該作者
回復 5# mead - Sub Timer()
-
- Dim HHMMSS As Integer
-
- On Error Resume Next
-
- ' Sheets("策略記錄").Select
-
- Sheets(2).Cells(2, 1) = Time '將時間show至策略的a2欄位
- If (TimeValue(Now) <= TimeValue("08:45:00") Or TimeValue(Now) >= TimeValue("13:45:00")) Then GoTo 10 '營業時間才執行
-
- ' If Minute(Time) <> LastMin Then '開始後做
-
- i = i + 1
-
- If i = 60 Then
-
- Sheets(2).Range("a10000").End(xlUp).Offset(1, 0) = Time
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 1) = O
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 2) = H
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 3) = L
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 4) = C
-
-
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 5) = O1
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 6) = H1
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 7) = L1
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 8) = C1
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 9) = O2
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 10) = H2
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 11) = L2
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 12) = C2
-
- i = 0
-
- O = Sheets(2).Cells(2, 2)
-
- H = Sheets(2).Cells(2, 2)
-
- L = Sheets(2).Cells(2, 2)
-
- C = Sheets(2).Cells(2, 2)
-
-
-
- O1 = Sheets(2).Cells(2, 3)
-
- H1 = Sheets(2).Cells(2, 3)
-
- L1 = Sheets(2).Cells(2, 3)
-
- C1 = Sheets(2).Cells(2, 3)
-
-
-
- O2 = Sheets(2).Cells(2, 4)
-
- H2 = Sheets(2).Cells(2, 4)
-
- L2 = Sheets(2).Cells(2, 4)
-
- C2 = Sheets(2).Cells(2, 4)
-
- Else
-
- C = Sheets(2).Cells(2, 2)
-
- If H = "" Then H = Sheets(2).Cells(2, 2)
-
- If C >= H Then H = C
-
- If C < L Then L = C
-
- If O = 0 Then O = Sheets(2).Cells(2, 2) Else O = O
-
- If L = 0 Then L = Sheets(2).Cells(2, 2) Else L = L
-
-
-
- C1 = Sheets(2).Cells(2, 3)
-
- If H1 = "" Then H1 = Sheets(2).Cells(2, 3)
-
- If C1 >= H1 Then H1 = C1
-
- If C1 < L1 Then L1 = C1
-
- If O1 = 0 Then O1 = Sheets(2).Cells(2, 3) Else O1 = O1
-
- If L1 = 0 Then L1 = Sheets(2).Cells(2, 3) Else L1 = L1
-
-
-
- C2 = Sheets(2).Cells(2, 4)
-
- If H2 = "" Then H2 = Sheets(2).Cells(2, 4)
-
- If C2 >= H2 Then H2 = C2
-
- If C2 < L2 Then L2 = C2
-
- If O2 = 0 Then O2 = Sheets(2).Cells(2, 4) Else O1 = O1
-
- If L2 = 0 Then L2 = Sheets(2).Cells(2, 4) Else L2 = L2
-
- End If
-
- LastMin = Minute(Time)
-
- ' End If
- 10
- Application.OnTime Now + TimeValue("00:00:01"), "Timer" '每秒顯示
-
- End Sub
複製代碼 |
|