16,748
社区成员
发帖
与我相关
我的任务
分享
Type MyType
a2 As Long '日期
a3 As Long '开盘价
a4 As Long '最高价
a5 As Long '最低价
a6 As Long '收盘价
a7 As Single '成交金额
a8 As Long '成交量
a9 As Long '?
End Type
Sub 按钮1_Click()
Dim File2 As Integer
Dim b As MyType
File1 = FreeFile
Open "sz399002.day" For Binary Access Read As #File1
i = 2
Do While Not EOF(File1)
Get #File1, , b
'Cells(i, 1) = b.a1
Cells(i, 2) = b.a2
Cells(i, 3) = b.a3
Cells(i, 4) = b.a4
Cells(i, 5) = b.a5
Cells(i, 6) = b.a6
Cells(i, 7) = b.a7
Cells(i, 8) = b.a8
Cells(i, 9) = b.a9
i = i + 1
Loop
Close #File1
End Sub
Type
TTDXDayInfo = packed record
nDate : integer; //日期, 格式:yyyymmdd的整数 如20080101 20081229
nStartPrice : integer; //开盘价格, 格式:开盘价*100,取整
nMaxPrice : integer; //最高价, 格式:~~
nMinPrice : integer; //最低价, 格式:~~
nEndPrice : integer; //收盘价, 格式:~~
nAmount : Single; //成交总额,元
nCount : integer; //总量,手
M : integer; //保留 暂为分析出来,猜测是平均价格
end;
这是我很多年前分析的,现在已经不用这个了,因为这个是未复权的,得自己分析GBBQ来进行复权,将很麻烦