数据下载时间：202303

结果输出

指数成分股数量

• 创业板50数量:50
• 创业板指数量:100
• 科创创业50数量:50
• 沪深300数量:300

创业板50和创业板指

创业板50比创业板指更倾向权重股

• 创业板50跟创业板指相同的公司数量：50
• 创业板50的公司在创业板指中所占的权重：74.46
• 创业板50的前十大权重股所占的权重：61.87
• 创业板指的前十大权重股所占的权重：47.92

创业板50和创业板指和科创创业50

创业板50跟创业板指在科创创业50中的占比差不多；最近科创50涨了一些，现在已经离开低估区了，可以考虑把理财计划中科创创业50的调整为创业板；

• 创业板50跟科创创业50相同的公司数量：22
• 创业板50的公司在科创创业50中所占的权重：62.815000000000005
• 创业板指跟科创创业50相同的公司数量：25
• 创业板指的公司在科创创业50中所占的权重：66.654

创业板50和创业板指和沪深300

创业板50跟创业板指在沪深300中的占比也差不多；

• 创业板50跟沪深300相同的公司数量：28
• 创业板50的公司在沪深300中所占的权重：11.003
• 创业板指跟沪深300相同的公司数量：36
• 创业板指的公司在沪深300中所占的权重：12.286

代码

@Slf4j
public class Chuangyeban50IndexAnalysis {

    public static void main(String[] args) {
        String hushen300WeightFileName = "202303/000300closeweight.xls";
        List<ZhongZhengWeightMo> hushen300Weights = Lists.newArrayList();
        EasyExcel.read(ResourceUtil.getResource(hushen300WeightFileName).getFile(), ZhongZhengWeightMo.class, new ZhongZhengWeightMoListener(hushen300Weights)).sheet().doRead();

        String kechuangchuangye50WeightFileName = "202303/931643closeweight.xls";
        List<ZhongZhengWeightMo> kechuangchuangye50Weights = Lists.newArrayList();
        EasyExcel.read(ResourceUtil.getResource(kechuangchuangye50WeightFileName).getFile(), ZhongZhengWeightMo.class, new ZhongZhengWeightMoListener(kechuangchuangye50Weights)).sheet().doRead();

        String chuangyebanzhiWeightFileName = "202303/399006_cons_202303.xls";
        List<GuoZhengWeightMo> chuangyebanzhiWeights = Lists.newArrayList();
        EasyExcel.read(ResourceUtil.getResource(chuangyebanzhiWeightFileName).getFile(), GuoZhengWeightMo.class, new GuoZhengWeightMoListener(chuangyebanzhiWeights)).sheet().doRead();

        String chuangyeban50WeightFileName = "202303/399673_cons_202303.xls";
        List<GuoZhengWeightMo> chuangyeban50Weights = Lists.newArrayList();
        EasyExcel.read(ResourceUtil.getResource(chuangyeban50WeightFileName).getFile(), GuoZhengWeightMo.class, new GuoZhengWeightMoListener(chuangyeban50Weights)).sheet().doRead();

        System.out.println("创业板50数量:" + chuangyeban50Weights.size());
        System.out.println("创业板指数量:" + chuangyebanzhiWeights.size());
        System.out.println("科创创业50数量:" + kechuangchuangye50Weights.size());
        System.out.println("沪深300数量:" + hushen300Weights.size());

        Map<String, GuoZhengWeightMo> chuangyeban50WeightMap = chuangyeban50Weights.stream().collect(Collectors.toMap(GuoZhengWeightMo::getConstituentCode, item -> item, (v1, v2) -> v2));
        Map<String, GuoZhengWeightMo> chuangyebanzhiWeightMap = chuangyebanzhiWeights.stream().collect(Collectors.toMap(GuoZhengWeightMo::getConstituentCode, item -> item, (v1, v2) -> v2));
        Map<String, ZhongZhengWeightMo> kechuangchuangye50WeightMap = kechuangchuangye50Weights.stream().collect(Collectors.toMap(ZhongZhengWeightMo::getConstituentCode, item -> item, (v1, v2) -> v2));
        Map<String, ZhongZhengWeightMo> hushen300WeightMap = hushen300Weights.stream().collect(Collectors.toMap(ZhongZhengWeightMo::getConstituentCode, item -> item, (v1, v2) -> v2));

        Comparator<GuoZhengWeightMo> guoZhengWeightMoComparator = Comparator.comparing(GuoZhengWeightMo::getWeight).reversed();
        chuangyeban50Weights.sort(guoZhengWeightMoComparator);
        chuangyebanzhiWeights.sort(guoZhengWeightMoComparator);

        System.out.println("创业板50跟创业板指相同的公司数量：" + chuangyeban50Weights.stream().filter(item -> chuangyebanzhiWeightMap.get(item.getConstituentCode()) != null).distinct().count());
        System.out.println("创业板50的公司在创业板指中所占的权重：" + chuangyeban50Weights.stream().map(item -> chuangyebanzhiWeightMap.get(item.getConstituentCode())).filter(Objects::nonNull).mapToDouble(GuoZhengWeightMo::getWeight).sum());
        System.out.println("创业板50的前十大权重股所占的权重：" + chuangyeban50Weights.subList(0, 10).stream().mapToDouble(GuoZhengWeightMo::getWeight).sum());
        System.out.println("创业板指的前十大权重股所占的权重：" + chuangyebanzhiWeights.subList(0, 10).stream().mapToDouble(GuoZhengWeightMo::getWeight).sum());

        System.out.println("创业板50跟科创创业50相同的公司数量：" + chuangyeban50Weights.stream().map(item -> kechuangchuangye50WeightMap.get(item.getConstituentCode())).filter(Objects::nonNull).count());
        System.out.println("创业板50的公司在科创创业50中所占的权重：" + chuangyeban50Weights.stream().map(item -> kechuangchuangye50WeightMap.get(item.getConstituentCode())).filter(Objects::nonNull).mapToDouble(ZhongZhengWeightMo::getWeight).sum());
        System.out.println("创业板指跟科创创业50相同的公司数量：" + chuangyebanzhiWeights.stream().map(item -> kechuangchuangye50WeightMap.get(item.getConstituentCode())).filter(Objects::nonNull).count());
        System.out.println("创业板指的公司在科创创业50中所占的权重：" + chuangyebanzhiWeights.stream().map(item -> kechuangchuangye50WeightMap.get(item.getConstituentCode())).filter(Objects::nonNull).mapToDouble(ZhongZhengWeightMo::getWeight).sum());

        System.out.println("创业板50跟沪深300相同的公司数量：" + chuangyeban50Weights.stream().map(item -> hushen300WeightMap.get(item.getConstituentCode())).filter(Objects::nonNull).count());
        System.out.println("创业板50的公司在沪深300中所占的权重：" + chuangyeban50Weights.stream().map(item -> hushen300WeightMap.get(item.getConstituentCode())).filter(Objects::nonNull).mapToDouble(ZhongZhengWeightMo::getWeight).sum());
        System.out.println("创业板指跟沪深300相同的公司数量：" + chuangyebanzhiWeights.stream().map(item -> hushen300WeightMap.get(item.getConstituentCode())).filter(Objects::nonNull).count());
        System.out.println("创业板指的公司在沪深300中所占的权重：" + chuangyebanzhiWeights.stream().map(item -> hushen300WeightMap.get(item.getConstituentCode())).filter(Objects::nonNull).mapToDouble(ZhongZhengWeightMo::getWeight).sum());
    }
}