waifwaif/okex-quantification

根据okex-api的相关衍生小脚本

OK API相关小脚本

---

基础脚本

• email_send.py 发送邮件
• ms_sql.py 保存到数据库
• my_schedule.py 定时任务

okapi脚本

• ok510.py 定时记录几个账号的资金变化
• ob_buy_okb.py 记录okb的买入卖出策略
• ok_price_history 记录ok期货出现溢价
• ok_skyrocketing 记录ok暴涨暴跌

sql建表语句

• 发送邮件

  CREATE TABLE tab_send_email(
	[id] [int] IDENTITY(1,1) NOT NULL,
	address_to varchar(30) not null,
	mail_subject nvarchar(300) not null,
	mail_text nvarchar(500) not null,
	create_time [datetime] NOT NULL  DEFAULT (getdate()),
	status bit default(1),
)

• 记录几个账号的资金

  CREATE TABLE tab_okex_price_history(
                    	[id] [int] IDENTITY(1,1) NOT NULL,
                    	name varchar(10) not null,
                    	present float not null,
                    	this_week float not null,
                    	next_week float not null,
                    	quarter float not null,
                    	create_time [datetime] NOT NULL  DEFAULT (getdate()),
                    	status bit default(1),
                    )

• 记录okb的买入卖出策略

 CREATE TABLE tab_bd_buy(
	[id] [int] IDENTITY(1,1) NOT NULL,
	token varchar(10) not null,
	price float not null,
	[action] float not null,
	status bit not null default (1),
	create_time [datetime] NOT NULL  DEFAULT (getdate())
)

• 记录ok暴涨暴跌

   CREATE TABLE tab_minutes_price(
	[id] [int] IDENTITY(1,1) NOT NULL,
	token_price varchar(200) not null,
	create_time [datetime] NOT NULL  DEFAULT (getdate())
)
  CREATE TABLE tab_price_change(
	[id] [int] IDENTITY(1,1) NOT NULL,
	before_price float not null,
	now_price float not null,
	change float not null,
	status bit not null default (1),
	create_time [datetime] NOT NULL  DEFAULT (getdate())
)