查看未结算的赎回交易
-- 查看未清算赎回交易
select t.account_no, t.trading_no, t.fundcode, t.cnfrm_nv, t.cnfrm_shares,t.shares_cnfrm_date,
s.sttlmnt_time, s.sttlmnt_status
from trading_rcd t left join shares_sttlmnt_rgst s
on t.trading_no = s.trading_no
where t.trading_drctn = 2 and (sttlmnt_status = '2' or sttlmnt_status is null)
order by t.account_no, t.shares_cnfrm_date desc
查看累计剩余份额，成本净值，最新总市值，最新净值
SELECT t.account_no, t.fundcode, s.fundname , round(sum(t.remaining_shares), 2) AS '剩余份额' , round(sum(t.remaining_shares * t.cnfrm_nv) / sum(t.remaining_shares), 4) AS '剩余成本' , round(sum(t.remaining_shares*p.unt_nv), 2) '当前市值' , p.nv_date '最新净值日' , p.unt_nv '最新净值' FROM trading_rcd t LEFT JOIN fund_list s ON t.fundcode = s.fundcode AND t.account_no = s.account_no LEFT JOIN ( SELECT a.fundcode, a.nv_date, a.unt_nv FROM fund_nv_rcd a, ( SELECT fundcode, max(nv_date) AS nv_dt FROM fund_nv_rcd GROUP BY fundcode ) b WHERE a.fundcode = b.fundcode AND a.nv_date = b.nv_dt ) p ON t.fundcode = p.fundcode WHERE t.remaining_shares > 0 GROUP BY t.account_no, t.fundcode, s.fundname ORDER BY t.account_no, t.fundcode
查看最新PE、PB分位数
SELECT a.ts_code, a.name, b.last_trd_dt AS '最后交易日', e.close AS '收盘点位' , CONCAT(round(e.pct_chg, 2) + '', '%') AS '涨跌幅' , c.pe_ttm AS '市盈率', c.pb AS '市净率' , concat(round(d.pe_ttm_l10y_prcntl * 100, 2) + '', '%') AS '近十年/成立至今市盈率百分位' , concat(round(d.pb_l10y_prcntl * 100, 2) + '', '%') AS '近十年/成立至今市净率百分位' FROM index_traking a, ( SELECT ts_code, max(trade_date) AS last_trd_dt FROM index_daily GROUP BY ts_code ) b, index_dailybasic c, index_dlybsc_anlyz d, index_daily e WHERE a.ts_code = b.ts_code AND a.status = 1 AND b.last_trd_dt = c.trade_date AND a.ts_code = c.ts_code AND a.ts_code = d.ts_code AND b.last_trd_dt = d.trade_date AND a.ts_code = e.ts_code AND b.last_trd_dt = e.trade_date
Linux 常用脚本命令
tar压缩/解压命令 https://blog.csdn.net/CSNN2019/article/details/111469541
screen命令 https://blog.csdn.net/carefree2005/article/details/122415714
SSH端口修改 https://blog.csdn.net/sdujava2011/article/details/126836571
查看crontab日志 tail -f /var/log/cron
在目录下搜索关键字 find ./ -name '*.*' | xargs grep "test" -R
重启服务器 shutdown -r now --立即重启 https://www.xaheimi.com/safe/438.html
查看进程
- Linux提示killed的原因 https://blog.csdn.net/Castlehe/article/details/122936585
- Linux查看CPU和内存使用情况 https://www.cnblogs.com/xd502djj/archive/2011/03/01/1968041.html
Mysql数据库
数据库备份
导出gz压缩文件 mysqldump -u用户名 -h127.0.0.1 -p密码 数据库名 | gzip > 备份文件名.sql.gz
导入gz压缩文件 gunzip -f < 备份文件名.sql.gz |mysql -u用户名 -h127.0.0.1 -p密码 数据库名
参考：https://blog.csdn.net/A___LEi/article/details/117031973
文章评论