股票交易流水收益记录表

操作流程：自选设定卖出或不想再关注交易记录1、设置费率：先费率、委托费已默认自动生成，如有变动请到面简洁，费率一般不会频繁变动）；2、录入数据：在发生“投入”、单元格直接输入数据覆盖公式是代码对照表中没有该只股票（3、查看明细：多只股票交易共表，只想了解其中某只股票的明细交易情况时，请选按钮查看。点击盈亏查看1、本表适用交易资软件的资金管理模块要准确好用一些，股票买卖分析则请使用专业股票软件操作。2、除盈亏查看表外，3、各表预设行数不够用时请自行往下拖拉填充公式，自选交易记录盈亏其他操作流程：简单设置1表→详细记录2表→自动生成3表。自选设定表用于监看当前实际持有或其他需要关注的股票，数据实时更新，设置方法表中有详细说明，已经卖出或不想再关注的股票请在网页中删除重新导入（但不要删除大盘指数）。交易记录表记录股票投资全过程（投入/买入/卖出/派息/送股/配股/送权/冻结/解冻/中签/支取/活息设置费率：先撤销工作表保护，然后点击BA列上面的“+”号展开AU~AZ列，修改变动日期及税费率（表内过户费率、委托费已默认自动生成，如有变动请到J列K列修改），修改完后可点回BA列上面的“-”号隐藏面简洁，费率一般不会频繁变动）；录入数据：在“操作日期”、“操作类别”、“股票代码”、“成交价格”、“成交数量”列输入基本数据“投入”、“派息”、“冻结”、“解冻”、“支取”、“活息”情况时，请在“成交金额”列单元格直接输入数据覆盖公式，其他数据自动生成。如输入股票代码后股票名称列出现“#N/A”等错码是代码对照表中没有该只股票（一般是新股或已改名），请自行在该表AP、AQ两列修改或添加代码和对应名称；查看明细：多只股票交易共表，只想了解其中某只股票的明细交易情况时，请点击“股票名称”单元格上的筛选按钮查看。点击L列上面的“+”号展开还可查看止赢止损参考价。盈亏查看表根据“交易记录”表及“自选设定”表数据自动汇总生成。适用交易沪深A股、权证、封闭式基金的资金管理，所有计算结果均已扣除税金手续费，可能比不少专业投资软件的资金管理模块要准确好用一些，股票买卖分析则请使用专业股票软件操作。、除盈亏查看表外，其余各表均可单独使用。、各表预设行数不够用时请自行往下拖拉填充公式，也可清空旧数据从新记录。制作，设置方法表中有详细说明，已经支取/活息/转入）修改变动日期及税费率（表内过户号隐藏（保持版“操作日期”、“操作类别”、“股票代码”、“成交价格”、“成交数量”列输入基本数据。在“成交金额”列对应行等错码，可能代码和对应名称；点击“股票名称”单元格上的筛，可能比不少专业投制作:叶明代码↑名称最新涨跌涨跌幅000713丰乐种业13.290.161.22%031002钢钒GFC1159901深100ETF0.610.023.41%399001深证成指9557.58290.873.14%580021青啤CWB1600630龙头股份5.250.101.94%定制自选股：下表内点右键选“编辑查询”,在“添加自选股”栏内添加股票代码,点一下“添加”按钮,待左上角的“→”出现后勾选它(只勾选表格的那一个),点“导入”操盘必读实时解盘查看L2前收开盘最高最低成交量成交额13.1313.0813.3013.0454693722962000.590.590.610.59108581506492846009266.719259.649605.209236.1690346860666120800005.155.145.265.101811394296002019年9月26日换手率前一周涨跌前一月涨跌总股本流通股本1.83%0.77%16.19%2.99亿2.99亿32.83亿18.83亿-0.17%7.31%0.00亿0.00亿-0.40%7.32%0.00亿0.00亿0.00亿0.00亿0.43%-0.77%10.75%4.25亿4.25亿更新数据：交易时间内在下表点右键选“数据区域属性”,勾选“刷新频率”并设定1分钟;其余时间把该勾选去掉,只需点查看DDE#N/A上证指数#N/A#N/A#N/A#N/A今日盈亏#N/A#N/A实现盈亏#N/A累计盈亏#N/A#N/A上交税费#N/A浮动盈亏#N/A#N/A买卖次数品种股票代码股票名称持仓量持股市值1000012南玻Ａ500#N/A2600050中国联通3600518康美药业-200#N/A4600597光明乳业投入资金4,600.00累计盈亏#N/A资产总值#N/A1目前仓位#N/A投入资金投资成本资产总值保本价昨收盘最新价涨跌幅今日盈亏实现盈亏9.157#N/A#N/A#N/A#N/A#REF!#REF!#N/A#N/A#N/A#N/A#REF!#REF!#REF!89.236次2019年09月26日星期四100%目前仓位持仓分布深证成指9,557.58290.873.14%666.12亿股票市值现金余额目前仓位浮动盈亏投资成本投资盈亏盈亏率持仓比#N/A4,566.84#N/A#N/A#N/A2,396.00#REF!#REF!#N/A#REF!#N/A2,559.00#REF!#REF!#N/A9,521.844,600.00#N/A#N/A2,446.77印花税率佣金费率过户费率委托费0.150%0.10%0.150%0.10%0.10%0.150%0.10%0.10%0.150%0.10%E列、J列计算扣除手续费引用有问题或建议请留言[e-mail]首买比例加仓倍数成本递度首买价格6.00%1.103.0%10.001买6.0%6.0%10.003,000.003,000.0030010.002买6.6%12.6%9.703,300.006,300.006409.843买7.3%19.9%9.413,630.009,930.0010269.684买8.0%27.8%9.133,993.0013,923.0014649.515买8.8%36.6%8.854,392.3018,315.3019609.356买9.7%46.3%8.594,831.5323,146.8325229.18总仓位买入价根据测试需要修改此行数据→分批建仓单次比例单次资金累计资金总股数成本价7买10.6%56.9%8.335,314.6828,461.5131609.018买11.7%68.6%8.085,846.1534,307.6638848.839买12.9%81.5%7.846,430.7740,738.4347048.6610买14.1%95.6%7.607,073.8447,812.2756358.49阻力0.1919.53阻力2.19125.53阻力0.38211.06阻力2.38227.060.00%0.00%阻力0.50012.00阻力2.50028.003.00%1.43%阻力0.61812.94阻力2.61828.945.91%2.78%阻力0.80914.47阻力2.80930.478.73%4.06%阻力1.00016.00阻力3.00032.0011.47%5.28%阻力1.19117.53阻力3.19133.5314.13%6.42%阻力1.38219.06支撑0.19112.9416.00输入近期相对高点→输入近期相对低点→实际亏损8.00股价损失测试资金50,000.0016.70%7.51%阻力1.50020.00支撑0.3829.8919.20%8.53%阻力1.61820.94支撑0.5008.0021.63%9.49%阻力1.80922.47支撑0.6186.1123.98%10.40%阻力2.00024.00支撑0.8093.06gggggggg010101gggggg02012/02/01投入12012/02/07买入600518康美药业11.99022012/02/07买入600050中国联通4.78032012/02/08卖出600518康美药业12.08042012/02/08卖出600050中国联通4.82052008/03/24买入600597光明乳业8.51062008/05/14卖出600597光明乳业8.56062008/07/11派息72008/09/18买入7.50082008/09/19买入8.20092008/10/09卖出10.000102008/11/07买入3.000112008/11/13卖出5.180122008/11/13买入3.650132008/11/14卖出4.300142008/11/14买入1.880买卖次数操作日期操作类别股票代码股票名称成交价格0.00%0.000%0.00%0.005,600.002000.00%0.150%0.10%6.002,404.005000.00%0.150%0.10%6.002,396.002000.10%0.150%0.10%8.422,407.585000.10%0.150%0.10%8.412,401.593000.30%0.300%0.10%16.322,569.323000.30%0.300%0.10%16.412,551.590.00%0.300%0.00%0.0030.002,0000.00%0.150%0.00%22.5015,022.505,0000.00%0.150%0.00%61.5041,061.505,0000.00%0.150%0.00%75.0049,925.005,0000.00%0.150%0.00%22.5015,022.505,0000.00%0.150%0.00%38.8525,861.1510,0000.00%0.150%0.00%54.7536,554.755,0000.00%0.150%0.00%32.2521,467.7520,0000.00%0.150%0.00%56.4037,656.400.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.00成交金额成交数量印花税率佣金费率过户费率上交税费0.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%0.000%0.00%0.000.000.00%