根据okex交易所API实现的一系列功能如下
- 记录多个账户的持仓
- 记录期现套利溢价
- 记录暴涨暴跌
- 记录现货下单
- 记录期货下单
- 进行期货跟单
- 各类数据使用微信机器人查询
- 各类数据邮件提醒
- 安装pipreqs:pip install pipreqs
- 生成requirements.txt文件：pipreqs . --encoding=utf8 --force
- 安装requirements.txt依赖：pip install -r requirements.txt
- 出现 pymssql==2.1.4 报错的话，使用 python 3.7 https://www.lfd.uci.edu/~gohlke/pythonlibs/#pymssql
-
./utils :工具脚本
- email_send.py 发送邮件
- ms_sql.py 数据库
- tools.py 个人工具
-
./ok :okapi脚本
- account_record.py 定时记录几个账号的资金变化
- ok_baodao.py 提醒期货开仓
- spot_record 提醒现货BTC买入
- straddle_info 记录ok期货出现溢价，提醒套利机会
- skyrocketing_info 记录ok暴涨暴跌
- 发送邮件
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(1000) not null,
type tinyint not null,
create_time [datetime] NOT NULL DEFAULT (getdate()),
status bit default(1),
)- 记录帐号相关信息：API/期货选择/张数
CREATE TABLE tab_accounts(
[id] [int] IDENTITY(1,1) NOT NULL,
[keyvalue] [varchar](50) NOT NULL,
[api_key] [varchar](80) NOT NULL,
[seceret_key] [varchar](80) NOT NULL,
[passphrase] [varchar](80) NOT NULL,
[order_instrument_id] [varchar](20) NULL,
[order_size] [varchar](10) NULL,
[status] [tinyint] NULL
)- 记录几个账号的资金变化
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 tinyint default(1),
)
CREATE TABLE tab_okex_account_swapbytoken(
[id] [int] IDENTITY(1,1) NOT NULL,
keyvalue varchar(50) not null,
eos_equity float not null,
bsv_equity float not null,
tab_price_id int not null,
eos_value float not null,
bsv_value float not null,
total_value float null,
create_time [datetime] NOT NULL DEFAULT (getdate()),
status tinyint default(1),
)
CREATE TABLE tab_okex_account_swapbydoller(
[id] [int] IDENTITY(1,1) NOT NULL,
keyvalue varchar(50) not null,
eos_usd_equity float not null,
eth_usd_equity float not null,
total_value float null,
create_time [datetime] NOT NULL DEFAULT (getdate()),
status tinyint default(1),
)
CREATE TABLE tab_price(
[id] [int] IDENTITY(1,1) NOT NULL,
eos_price float not null,
bsv_price float not null,
create_time [datetime] NOT NULL DEFAULT (getdate()),
)- 记录帐号资金2.0 - 单账户币本位余额记录
CREATE TABLE tab_swap_one_token(
[id] [int] IDENTITY(1,1) NOT NULL,
keyvalue varchar(50) not null,
instrument_id varchar(20) not null,
equity float not null,
create_time [datetime] NOT NULL DEFAULT (getdate()),
status tinyint default(1),
)- 记录量化的买入卖出策略
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())
)