股票交易表格
2023股票投资收益分析表 - 分析表 Unnamed: 0 Unnamed: 1 股票投资收益分析表Analysis of stock investment income股票代码A0001A0002A0003A0004A0005A0006A0007A0008A0009A0010A0011A0012Unnamed: 2 买入买入股数326302388428425358373265248260444438Unnamed: 3 买入股价346523645534Unnamed: 4 买入手续费666652456264Unnamed: 5 卖出卖出股数258288207303
股票投资组合分析模型excel表格下载 - 股票投资组合分析模型 Unnamed: 0 Unnamed: 1 股票投资组合分析模型原始数据无风险利率组合分析股票1股票2股票3股票4合计总收益率Unnamed: 2 0.055市场指数β0.381.351.291.60.142588241123674Unnamed: 3 市场总风险率每股风险率0.350.150.20.4Unnamed: 4 0.045权数0.1255199296431440.4089025105860790.30122409905740.1643534607133771总风险率Unnamed: 5 市场总收益率加权β0.04769757326439490.5520183892912070.3885790877840450.2629655371414031.251260587481050.130000931122935Unnamed: 6 0.125加权每股风险率0.005514338458166970
2025股票价值投资分析表免费下载 - 价值投资分析表 Unnamed: 0 Unnamed: 1 股票 代码000910000923002022002382002443002521002608300981600012600023600062股票价值投资分析表 股票 名称大亚圣象河钢资源科华生物蓝帆医疗金洲管道齐峰新材江苏国信中红医疗皖通高速浙能电力华润双鹤Unnamed: 3 涨幅%-1.74-5.611.090.89-0.64-2.390.591.490.153.14-0.93Unnamed: 4 现价12.3918.8513.8919.246.256.946.8596.936.73.9411.76Unnamed: 5 总股本 (亿股)5.476.535.1510.075.214.95......
2025股票分批买入操作计划表免费下载 - 分批买入计划 Unnamed: 0 股票分批买入操作计划表 账户金额序号123说明：Unnamed: 2 120000股票名称海螺水泥龙马环卫中新集团1. 第二行的条件用户可根据自身情况自行修改；2. “递增百分比%”代表后面一批建仓金额比前面一批建仓金额增加的百分比；3. 此表仅供参考，具体投资决策请用户自行决定。Unnamed: 3 股票只数批次123小计：123小计：123小计：Unnamed: 4 3可用金额10989.01098901113186.813186813215824.17582417584000010989.01098901113186.813186813215824.17582417584000010989.01098901113186.813186813215824.175824175840000Unnamed:
2025年股票收益分析表 - Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 股票收益分析表序号12345678910合计Unnamed: 3 股票名称股票1股票2股票3股票4股票5股票6股票7股票8股票9股票10Unnamed: 4 股票代码000001000002000003000004000005000006000007000008000009000010Unnamed: 5 数量50002000300025001800220035001000800105022850Unnamed: 6 成本价15121820221410.835221818.68Unnamed: 7 总成本75000240005400050000396003080037800350001760018900382700Unnamed: 8 现价15.510.819.82123151136231719.21Unnamed: 9 当前持仓7750021600594005250041400330003850036
2024年股票收益投资分析表 - Sheet1 Unnamed: 0 股票收益统计分析表 序号1234567Unnamed: 2 交易日期XXXXXXXXXXXXXXXXXXXXXXXXUnnamed: 3 交易单号A0001A0002A0003A0004A0005A0006Unnamed: 4 股票名称股票1股票2股票3股票4股票5股票6Unnamed: 5 股票代码B0001B0002B0003B0004B0005B0006Unnamed: 6 买入数量1000450550500800450Unnamed: 7 买进单价(元)16.511.88.7513.116.512.5Unnamed: 8 买进总价(元)1650053104812.56550132005625Unnamed: 9 现价(元)1810.210.114.21811.6Unnamed: 10 卖出总价(元)18000459055557100144005220Unnamed: 11 盈亏率0.0909090909090908-
2024年股票投资收益记录表 - 股票投资收益记录表 Unnamed: 0 Unnamed: 1 Unnamed: 2 股票投资收益记录表序号12Unnamed: 3 股票代码601111601985Unnamed: 4 股票名称中国国航中国核电Unnamed: 5 发行商Unnamed: 6 买进价6.84.8Unnamed: 7 数量10000080000Unnamed: 8 交易费用18080Unnamed: 9 买进成本680180384080Unnamed: 10 当前价7.85.67Unnamed: 11 股票市值780000453600Unnamed: 12 股票收益9982069520Unnamed: 13 收益率0.146755270663647850.18100395750885231Sheet2 总成本 总市值总收益1064260 1233600.00.15911525379136676
股票投资业绩表 - Sheet1 Unnamed: 0 股票投资业绩表 汇总123明细序号123456789101112131415161718192021222324252627282930313233Unnamed: 2 买入成本交易费用买入总成本股票名称XXXXXXXXXXXXXXXUnnamed: 3 发行商XXXXXXXXXXXXXXXUnnamed: 4 代码XXXXXXXXXXXXXXXUnnamed: 5 22352.511322465.5数量150220125Unnamed: 6 买进价/股55.245.532.5Unnamed: 7 交易费用355226Unnamed: 8 当前市值收益收益率总成本 买进价+交易费用8315100624088.5000000000000000000000000000000Unnamed: 9 当前价/股62.238.235.1Unnamed: 10 22121.5-344-0.01531236785293市值933股票交易表格
家庭基金股票理财记录明细表 - Sheet1 家庭理财记录表 股票投入总计 及盈利序号1234567891011121314Unnamed: 1 股票三安光电金山办公中芯国际长电科技贵州茅台Unnamed: 2 100000投入 资金2000020000200002000020000Unnamed: 3 收益率0.050.150.250.180.05Unnamed: 4 13600收益 金额10003000500036001000Unnamed: 5 基金投入总计及盈利基金诺安成长混合汇丰智能新能源招商中证白酒金鹰信息产业广发科技先锋Unnamed: 6 190000投入 资金6000030000200002000060000Unnamed......
2025年股票理财收益统计表 - Sheet1 股票理财收益统计表 日期2019-03-21 00:00:00Unnamed: 1 股票名称鄂尔多斯Unnamed: 2 代码600295Unnamed: 3 买入价7.92Unnamed: 4 买入数量2000Unnamed: 5 买入总金额1584000000000000000000000000000000000000000000000000000000000
股票收益统计表 - Sheet1 股票收益统计表 序号12Unnamed: 1 日期2018-12-19 00:00:002018-12-19 00:00:00Unnamed: 2 股票代码000002600030Unnamed: 3 股票名称万科A中信证券Unnamed: 4 买入价22.0115总收益： 卖出价2416.872200 数量2000018000Unnamed: 7 收益3980032400
2025年股票投资分析对比表 - Sheet1 股票投资分析对比表 基本面技术面关键指标Unnamed: 1 股票名称当前价格每股盈利市盈率(自动计算)每股净资产市净率(自动计算)股息率历史最低价历史最高价历史最低市盈率历史最高市盈率历史最低市净率历史最高市净率历史最低股息率历史最高股息率行业地位净资产收益率>=10%净利润率>=5%毛利率>=20%资产负债率Unnamed: 2 格力电器50.644.3811.561643835616415.773.211160431198480.03917.55788500.770.0070.09710.28690.11310.30230.63Unnamed: 3 美的集团50.753.2515.615384615384612.474.069767441860470.02568.5661.25754......
股票投资盈亏追踪表 - 股票投资记录 Unnamed: 0 Unnamed: 1 Unnamed: 2 股票投资盈亏追踪表股票名称XXXXUnnamed: 3 发行商XXXXUnnamed: 4 代码000012Unnamed: 5 账户总成本买进价/每股35Unnamed: 6 350050买进数量10000Unnamed: 7 账户市值交易费用50Unnamed: 8 550000买进成本350050Unnamed: 9 账户盈亏当前价55Unnamed: 10 199950市值550000Unnamed: 11 2019-11-13 00:00:00盈亏比率股票收益199950Unnamed: 12 0.5712041136980431收益率0.5712041136980431更多
股票内在价值估算表 - 贴现模型 Unnamed: 0 股票内在价值估算表 股票代码600xxx说明： 1.自由现金流价值=息税前利润+折旧-资本支出-营运资本增加； 2.现金流贴现=自由现金流/(1+贴现率)^年数，贴现率取值范围一般在8%~14%之间，风险越高、波动越大的行业，取值越高，越接近14%；风险越低、波动越小的行业，取值越低，越接近8%。 3.永久价值=[第5年或10年的现金流*(1+公司长期增长率)]/(贴现率-公司长期增长率)，其中公司长期增长率取值3%Unnamed: 2 股票名称中国xxUnnamed: 3 预估年份自由现金流(万元)预估现金流增长率预估现金流贴现率现金流贴现(万元)Unnam股票交易表格
2025基金股票投资收益预测表免费下载 - 基金股票投资收益预测表 Unnamed: 0 基金股票投资收益预测表 319.6序号1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950Unnamed: 2 基金/股票基金A基金A基金B基金CUnnamed: 3 买入时间2021-07-30 00:00:002021-08-02 00:00:002021-08-03 00:00:002021-08-10 00:00:00Unname......
2025股票基金理财收益统计表免费下载 - sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 股票基金理财收益统计表序号合计1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
2025股票基金投资记录表免费下载 - sheet1 Unnamed: 0 Unnamed: 1 股票基金投资记录表计划持仓金额序号12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
