Foxtable(狐表)用户栏目专家坐堂 → [求助]行计算


  共有2264人关注过本帖平板打印复制链接

主题:[求助]行计算

帅哥哟,离线,有人找我吗?
有点蓝
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:107861 积分:548662 威望:0 精华:9 注册:2015/6/24 9:21:00
  发帖心情 Post By:2020/5/21 20:16:00 [只看该作者]

Dim codes As List (Of String) = DataTables("股piao信息明细表").GetValues("代码 Is Not Null","代码")
For Each code As String In codes
    Dim drlist As List (Of DataRow) = DataTables("股piao信息明细表").Select("代码 = '" & code & "'","时间")
    drlist(0)("涨跌幅") = (drlist(0)("收盘价") - drlist(0)("开盘价")) / drlist(0)("开盘价") * 1%
    For i As Integer = 1 To drlist.Count - 1
        drlist(i)("涨跌幅") = (drlist(i)("收盘价") - drlist(i - 1)("收盘价")) / drlist(i - 1)("收盘价") * 1%
    Next
Next

 回到顶部