{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import sys\n", "\n", "sys.path.insert(0, \"../../\")\n", "from pyecharts import online\n", "\n", "online()\n", "# 演示必要的准备代码,使用该库时不需重复此单元格命令" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import xalpha as xa\n", "import pandas as pd" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# ETF拯救世界的指数投资计划" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "path = \"../../tests/etf.csv\"\n", "read = xa.record(path, skiprows=1)\n", "# 读取E大的发车记录,该记录采取且慢的发车记录,但由于早期有些仓位是按点数不定时买入的,可能买入时点与E大和且慢记录稍有出入" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [], "source": [ "sysopen = xa.mulfix(status=read.status, totmoney=150 * 1000)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | 基金名称 | \n", "基金代码 | \n", "当日净值 | \n", "单位成本 | \n", "持有份额 | \n", "基金现值 | \n", "基金总申购 | \n", "历史最大占用 | \n", "基金持有成本 | \n", "基金分红与赎回 | \n", "换手率 | \n", "基金收益总额 | \n", "投资收益率 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "华夏上证50ETF联接A | \n", "001051 | \n", "0.851000 | \n", "0.7060 | \n", "11206.23 | \n", "9536.50 | \n", "9000.00 | \n", "8000.00 | \n", "7911.17 | \n", "1088.83 | \n", "0.207906 | \n", "1625.33 | \n", "20.3166 | \n", "
1 | \n", "华夏恒生ETF联接 | \n", "000071 | \n", "1.490300 | \n", "0.8942 | \n", "6852.82 | \n", "10212.76 | \n", "9000.00 | \n", "9000.00 | \n", "6127.61 | \n", "2872.39 | \n", "0.223119 | \n", "4085.15 | \n", "45.3906 | \n", "
2 | \n", "华安标普石油指数 | \n", "160416 | \n", "1.100000 | \n", "0.8720 | \n", "1146.73 | \n", "1261.40 | \n", "1000.00 | \n", "1000.00 | \n", "1000.00 | \n", "0.00 | \n", "0.175312 | \n", "261.40 | \n", "26.1400 | \n", "
3 | \n", "广发养老指数A | \n", "000968 | \n", "0.951300 | \n", "0.9715 | \n", "8234.85 | \n", "7833.81 | \n", "8000.00 | \n", "8000.00 | \n", "8000.00 | \n", "0.00 | \n", "0.196026 | \n", "-166.19 | \n", "-2.0774 | \n", "
4 | \n", "华夏中证500ETF联接 | \n", "001052 | \n", "0.550000 | \n", "0.6135 | \n", "9779.61 | \n", "5378.79 | \n", "6000.00 | \n", "6000.00 | \n", "6000.00 | \n", "0.00 | \n", "0.203456 | \n", "-621.21 | \n", "-10.3535 | \n", "
5 | \n", "广发中证环保ETF联接A | \n", "001064 | \n", "0.572100 | \n", "0.7175 | \n", "11149.05 | \n", "6378.37 | \n", "8000.00 | \n", "8000.00 | \n", "8000.00 | \n", "0.00 | \n", "0.217780 | \n", "-1621.63 | \n", "-20.2704 | \n", "
6 | \n", "华夏沪深300ETF联接A | \n", "000051 | \n", "1.119000 | \n", "0.9662 | \n", "1035.03 | \n", "1158.20 | \n", "1000.00 | \n", "1000.00 | \n", "1000.00 | \n", "0.00 | \n", "0.226427 | \n", "158.20 | \n", "15.8200 | \n", "
7 | \n", "南方原油 | \n", "501018 | \n", "1.233500 | \n", "0.0000 | \n", "0.00 | \n", "0.00 | \n", "1000.00 | \n", "1000.00 | \n", "-94.26 | \n", "1094.26 | \n", "0.514404 | \n", "94.26 | \n", "9.4260 | \n", "
8 | \n", "华安德国30(DAX)联接 | \n", "000614 | \n", "1.174000 | \n", "1.0945 | \n", "1827.26 | \n", "2145.20 | \n", "2000.00 | \n", "2000.00 | \n", "2000.00 | \n", "0.00 | \n", "0.260714 | \n", "145.20 | \n", "7.2600 | \n", "
9 | \n", "博时信用债纯债债券A | \n", "050027 | \n", "1.076000 | \n", "1.0289 | \n", "1849.63 | \n", "1990.20 | \n", "2000.00 | \n", "1964.21 | \n", "1903.17 | \n", "96.83 | \n", "0.313219 | \n", "87.03 | \n", "4.4308 | \n", "
10 | \n", "广发医药卫生联接A | \n", "001180 | \n", "0.812600 | \n", "0.7934 | \n", "11344.23 | \n", "9218.32 | \n", "9000.00 | \n", "9000.00 | \n", "9000.00 | \n", "0.00 | \n", "0.306208 | \n", "218.32 | \n", "2.4258 | \n", "
11 | \n", "富国中证红利指数增强 | \n", "100032 | \n", "1.027000 | \n", "1.0429 | \n", "9274.34 | \n", "9524.75 | \n", "11000.00 | \n", "9671.79 | \n", "9671.79 | \n", "1328.21 | \n", "0.390310 | \n", "-147.04 | \n", "-1.5203 | \n", "
12 | \n", "广发中债7-10年国开债指数A | \n", "003376 | \n", "0.998000 | \n", "0.8963 | \n", "3184.84 | \n", "3178.47 | \n", "6000.00 | \n", "6000.00 | \n", "2854.52 | \n", "3145.48 | \n", "0.509478 | \n", "323.95 | \n", "5.3992 | \n", "
13 | \n", "华宝标普油气上游股票 | \n", "162411 | \n", "0.697000 | \n", "0.5475 | \n", "3653.21 | \n", "2546.29 | \n", "2000.00 | \n", "2000.00 | \n", "2000.00 | \n", "0.00 | \n", "0.378631 | \n", "546.29 | \n", "27.3145 | \n", "
14 | \n", "建信中证500指数增强A | \n", "000478 | \n", "1.948200 | \n", "2.3362 | \n", "4708.47 | \n", "9173.04 | \n", "11000.00 | \n", "11000.00 | \n", "11000.00 | \n", "0.00 | \n", "0.385835 | \n", "-1826.96 | \n", "-16.6087 | \n", "
15 | \n", "易方达创业板ETF联接A | \n", "110026 | \n", "1.581200 | \n", "1.8858 | \n", "530.29 | \n", "838.49 | \n", "1000.00 | \n", "1000.00 | \n", "1000.00 | \n", "0.00 | \n", "0.445122 | \n", "-161.51 | \n", "-16.1510 | \n", "
16 | \n", "广发创业板ETF联接A | \n", "003765 | \n", "0.867000 | \n", "0.9612 | \n", "1040.42 | \n", "902.04 | \n", "1000.00 | \n", "1000.00 | \n", "1000.00 | \n", "0.00 | \n", "0.481530 | \n", "-97.96 | \n", "-9.7960 | \n", "
17 | \n", "华夏海外收益债券A | \n", "001061 | \n", "1.247000 | \n", "1.2129 | \n", "3297.78 | \n", "4112.33 | \n", "4000.00 | \n", "4000.00 | \n", "4000.00 | \n", "0.00 | \n", "0.501374 | \n", "112.33 | \n", "2.8083 | \n", "
18 | \n", "华安黄金易ETF联接A | \n", "000216 | \n", "0.979100 | \n", "1.0296 | \n", "971.23 | \n", "950.93 | \n", "1000.00 | \n", "1000.00 | \n", "1000.00 | \n", "0.00 | \n", "0.572100 | \n", "-49.07 | \n", "-4.9070 | \n", "
19 | \n", "广发纯债债券A | \n", "270048 | \n", "1.202000 | \n", "1.1549 | \n", "1687.15 | \n", "2027.95 | \n", "2000.00 | \n", "1992.44 | \n", "1948.57 | \n", "51.43 | \n", "0.622196 | \n", "79.38 | \n", "3.9841 | \n", "
20 | \n", "易方达证券公司分级 | \n", "502010 | \n", "0.790800 | \n", "0.9443 | \n", "3176.89 | \n", "2512.28 | \n", "3000.00 | \n", "3000.00 | \n", "3000.00 | \n", "0.00 | \n", "0.751029 | \n", "-487.72 | \n", "-16.2573 | \n", "
21 | \n", "广发中证传媒ETF联接A | \n", "004752 | \n", "0.763600 | \n", "0.9262 | \n", "4318.73 | \n", "3297.78 | \n", "4000.00 | \n", "4000.00 | \n", "4000.00 | \n", "0.00 | \n", "0.881643 | \n", "-702.22 | \n", "-17.5555 | \n", "
22 | \n", "富国量化沪深300 | \n", "100038 | \n", "1.671000 | \n", "1.6982 | \n", "1766.60 | \n", "2951.99 | \n", "3000.00 | \n", "3000.00 | \n", "3000.00 | \n", "0.00 | \n", "2.433333 | \n", "-48.01 | \n", "-1.6003 | \n", "
23 | \n", "广发中证全指金融地产联接A | \n", "001469 | \n", "0.875300 | \n", "0.9044 | \n", "2211.40 | \n", "1935.64 | \n", "2000.00 | \n", "2000.00 | \n", "2000.00 | \n", "0.00 | \n", "2.991803 | \n", "-64.36 | \n", "-3.2180 | \n", "
24 | \n", "兴全可转债混合 | \n", "340001 | \n", "1.024400 | \n", "1.0050 | \n", "995.02 | \n", "1019.30 | \n", "1000.00 | \n", "1000.00 | \n", "1000.00 | \n", "0.00 | \n", "3.258929 | \n", "19.30 | \n", "1.9300 | \n", "
25 | \n", "富国中证500 | \n", "161017 | \n", "1.929000 | \n", "1.9519 | \n", "512.31 | \n", "988.25 | \n", "1000.00 | \n", "1000.00 | \n", "1000.00 | \n", "0.00 | \n", "14.038462 | \n", "-11.75 | \n", "-1.1750 | \n", "
26 | \n", "广发中证500ETF联接C | \n", "002903 | \n", "0.877200 | \n", "0.8407 | \n", "1189.48 | \n", "1043.41 | \n", "1000.00 | \n", "1000.00 | \n", "1000.00 | \n", "0.00 | \n", "22.812500 | \n", "43.41 | \n", "4.3410 | \n", "
27 | \n", "货币基金 | \n", "mf | \n", "1.273397 | \n", "1.0073 | \n", "49317.98 | \n", "62801.35 | \n", "152039.31 | \n", "149000.00 | \n", "49677.34 | \n", "102361.97 | \n", "0.281480 | \n", "13124.01 | \n", "8.8081 | \n", "
28 | \n", "总计 | \n", "total | \n", "NaN | \n", "NaN | \n", "NaN | \n", "164917.84 | \n", "262039.31 | \n", "150000.00 | \n", "149999.91 | \n", "112039.40 | \n", "0.164860 | \n", "14917.93 | \n", "9.9453 | \n", "