已把源数据贴上,可做成上图。也在高岭俱乐部网站查询动态图表
看到篇文章《山西汾酒市值突破千亿元“大关” 超越大秦铁路“登顶”山西板块》,颇多感慨:
华夏古文明,山西好风光。但要说踏实肯干和金融成就,这些千亿市值突破的事远比不上百年前晋商的荣耀。
$大秦铁路(SH601006)$是很好的管资产而不是管资本的范例。若想市值反映盈利能力,每年赚取的eps0.8元都用于分红或回购,市场把它作为一个很好的高息品种。而实际情况却是:一半的盈利用于收购低效资产,最终的命运会沦为破净。一个价值1500亿以上的品种搞成了1000亿之下,这也是能力,顶多是融资能力。铁总的基因是强大的,山西人民只能忍耐。
再看另一个当事方品种$山西汾酒(SH600809)$,搞到了12倍市净率,更多是在白酒风口上的原因。和同门的茅台、五粮液比,市值还显小,更别提背靠华夏文明的大树之根。酒这东西该怎么喝一旦有了金融藏品属性,发展之路就曲折了。
原文还涉及另外三只曾经的千亿市值山西股票,$西山煤电(SZ000983)$,太钢不锈和永泰能源。从市净率历史估值库中(数据来源guru.net.cn,高岭)抽调自2003年来的关键时点pb数据。永泰能源公司因涉及增发业务重组因素,不做估值数据提取。未来某一天喝上了曾经的“国酒”,再做上述四只个股估值念叨。
数据附在下面,供参考玩味。
id stock pbttm date stock pbttm date
601006 2003-01-07 600809 3.3 2003-01-07 000825 1.3 2003-01-07 000983 1.6 2003-01-07 2003-04-17 600809 3.7 2003-04-17 000825 1.6 2003-04-17 000983 2 2003-04-17 2003-11-14 600809 3.6 2003-11-14 000825 1.7 2003-11-14 000983 1.9 2003-11-14 2004-04-07 600809 3.2 2004-04-07 000825 1.4 2004-04-07 000983 1.8 2004-04-07 2004-09-08 600809 3.7 2004-09-08 000825 1.6 2004-09-08 000983 3 2004-09-08 2004-12-24 600809 2.7 2004-12-24 000825 1.2 2004-12-24 000983 2.4 2004-12-24 2005-06-06 600809 2.9 2005-06-06 000825 1.1 2005-06-06 000983 4.4 2005-06-06 2005-09-20 600809 2.7 2005-09-20 000825 0.9 2005-09-20 000983 2 2005-09-20 2005-12-06 600809 3.6 2005-12-06 000825 1 2005-12-06 000983 1.9 2005-12-06 2006-02-28 600809 2.9 2006-02-28 000825 0.8 2006-02-28 000983 1.2 2006-02-28 2006-07-05 600809 3.4 2006-07-05 000825 1 2006-07-05 000983 1.6 2006-07-05 51696 601006 2.2 2006-08-14 600809 6.3 2006-08-14 000825 1.1 2006-08-14 000983 1.7 2006-08-14 51697 601006 2.9 2006-12-28 600809 11.7 2006-12-28 000825 2.6 2006-12-28 000983 2.1 2006-12-28 51698 601006 3.9 2007-02-27 600809 11.1 2007-02-27 000825 3.1 2007-02-27 000983 3.3 2007-02-27 51699 601006 5.8 2007-05-29 600809 15.6 2007-05-29 000825 5.1 2007-05-29 000983 5.6 2007-05-29 51700 601006 9.2 2007-10-16 600809 14.2 2007-10-16 000825 6.4 2007-10-16 000983 14.2 2007-10-16 51701 601006 8.9 2007-12-28 600809 12.3 2007-12-28 000825 5.1 2007-12-28 000983 12 2007-12-28 51702 601006 4.8 2008-04-21 600809 5.2 2008-04-21 000825 2.5 2008-04-21 000983 7.8 2008-04-21 51703 601006 4.7 2008-07-28 600809 4.4 2008-07-28 000825 1.8 2008-07-28 000983 6.3 2008-07-28 51704 601006 3.5 2008-09-18 600809 2.8 2008-09-18 000825 1.2 2008-09-18 000983 2.7 2008-09-18 51705 601006 3.5 2008-10-28 600809 3.2 2008-10-28 000825 0.9 2008-10-28 000983 2.4 2008-10-28 51706 601006 2.6 2008-12-31 600809 3.2 2008-12-31 000825 1 2008-12-31 000983 3.2 2008-12-31 51707 601006 2.5 2009-03-03 600809 4.4 2009-03-03 000825 1.5 2009-03-03 000983 2.9 2009-03-03 51708 601006 3.8 2009-08-04 600809 9 2009-08-04 000825 3.5 2009-08-04 000983 10.2 2009-08-04 51709 601006 3 2009-08-31 600809 7.2 2009-08-31 000825 2.1 2009-08-31 000983 6.8 2009-08-31 51710 601006 2.5 2009-12-31 600809 11.3 2009-12-31 000825 2.6 2009-12-31 000983 9.6 2009-12-31 51711 601006 2.9 2010-04-15 600809 11.4 2010-04-15 000825 2.2 2010-04-15 000983 7.8 2010-04-15 51712 601006 2.8 2010-07-02 600809 9.3 2010-07-02 000825 1.3 2010-07-02 000983 4.3 2010-07-02 51713 601006 2.9 2010-09-21 600809 13.9 2010-09-21 000825 1.4 2010-09-21 000983 4.7 2010-09-21 51714 601006 2.4 2010-11-11 600809 16.9 2010-11-11 000825 1.6 2010-11-11 000983 7.1 2010-11-11 51715 601006 2.1 2010-12-31 600809 15.4 2010-12-31 000825 1.4 2010-12-31 000983 6.7 2010-12-31 51716 601006 2 2011-01-20 600809 11.1 2011-01-20 000825 1.3 2011-01-20 000983 5.6 2011-01-20 51717 601006 2.3 2011-04-15 600809 11.7 2011-04-15 000825 1.6 2011-04-15 000983 5.6 2011-04-15 51718 601006 1.8 2011-09-28 600809 13 2011-09-28 000825 1.1 2011-09-28 000983 4.5 2011-09-28 74512 601006 1.7 2011-10-11 600809 11.2 2011-10-11 000825 1.1 2011-10-11 000983 4.6 2011-10-11 72243 601006 1.8 2011-10-21 600809 10.9 2011-10-21 000825 1.1 2011-10-21 000983 4.2 2011-10-21 69974 601006 1.8 2011-11-03 600809 12 2011-11-03 000825 1.1 2011-11-03 000983 4.4 2011-11-03 67705 601006 1.7 2012-01-05 600809 8 2012-01-05 000825 0.9 2012-01-05 000983 2.8 2012-01-05 65436 601006 1.7 2012-02-27 600809 9.7 2012-02-27 000825 1 2012-02-27 000983 3.6 2012-02-27 63167 601006 1.6 2012-03-29 600809 9.1 2012-03-29 000825 0.9 2012-03-29 000983 3 2012-03-29 60898 601006 1.7 2012-05-04 600809 11.5 2012-05-04 000825 1 2012-05-04 000983 3.9 2012-05-04 58629 601006 1.7 2012-06-04 600809 10.5 2012-06-04 000825 0.9 2012-06-04 000983 3.4 2012-06-04 56360 601006 1.4 2012-07-23 600809 5.2 2012-07-23 000825 0.9 2012-07-23 000983 3 2012-07-23 54091 601006 1.4 2012-08-30 600809 5 2012-08-30 000825 0.8 2012-08-30 000983 2.5 2012-08-30 77633 601006 1.4 2012-09-30 600809 9.5 2012-09-30 000825 0.8 2012-09-30 000983 2.6 2012-09-30 79951 601006 1.4 2012-10-30 600809 11.3 2012-10-30 000825 0.8 2012-10-30 000983 2.5 2012-10-30 82269 601006 1.4 2012-11-30 600809 9.1 2012-11-30 000825 0.8 2012-11-30 000983 2.2 2012-11-30 84587 601006 1.4 2012-12-03 600809 8.2 2012-12-03 000825 0.8 2012-12-03 000983 2.1 2012-12-03 86905 601006 1.5 2012-12-31 600809 10.4 2012-12-31 000825 0.9 2012-12-31 000983 2.7 2012-12-31 88892 601006 1.4 2013-01-01 600809 10.2 2013-01-01 000825 0.8 2013-01-01 000983 2.9 2013-01-01 91364 601006 1.5 2013-03-30 600809 6 2013-03-30 000825 0.8 2013-03-30 000983 2.3 2013-03-30 93836 601006 1.4 2013-04-30 600809 5.4 2013-04-30 000825 0.8 2013-04-30 000983 2.1 2013-04-30 99344 601006 1.4 2013-06-30 600809 5 2013-06-30 000825 0.6 2013-06-30 000983 1.5 2013-06-30 96877 601006 1.4 2013-08-29 600809 5 2013-08-29 000825 0.6 2013-08-29 000983 1.5 2013-08-29 101696 601006 1.5 2013-09-30 600809 3.9 2013-09-30 000825 0.6 2013-09-30 000983 1.5 2013-09-30 104163 601006 1.4 2013-10-30 600809 3.6 2013-10-30 000825 0.6 2013-10-30 000983 1.4 2013-10-30 106630 601006 1.5 2013-12-30 600809 3.9 2013-12-30 000825 0.6 2013-12-30 000983 1.3 2013-12-30 109098 601006 1.43 2013-12-31 600809 4.36 2013-12-31 000825 0.6 2013-12-31 000983 1.4 2013-12-31 111571 601006 1.3 2014-01-20 600809 3.83 2014-01-20 000825 0.55 2014-01-20 000983 1.14 2014-01-20 114044 601006 1.35 2014-02-07 600809 3.37 2014-02-07 000825 0.57 2014-02-07 000983 1.16 2014-02-07 116517 601006 1.3 2014-02-24 600809 3.47 2014-02-24 000825 0.56 2014-02-24 000983 1.1 2014-02-24 118990 601006 1.18 2014-03-20 600809 3.54 2014-03-20 000825 0.53 2014-03-20 000983 0.99 2014-03-20 121463 601006 1.34 2014-03-31 600809 3.38 2014-03-31 000825 0.56 2014-03-31 000983 1.15 2014-03-31 123936 601006 1.24 2014-04-24 600809 3.26 2014-04-24 000825 0.56 2014-04-24 000983 1.01 2014-04-24 138850 601006 1.27 2014-05-19 600809 3.11 2014-05-19 000825 0.58 2014-05-19 000983 1.02 2014-05-19 136337 601006 1.2 2014-06-30 600809 2.95 2014-06-30 000825 0.61 2014-06-30 000983 1 2014-06-30 133824 601006 1.32 2014-07-25 600809 3.55 2014-07-25 000825 0.63 2014-07-25 000983 1.11 2014-07-25 131311 601006 1.35 2014-08-19 600809 3.59 2014-08-19 000825 0.65 2014-08-19 000983 1.18 2014-08-19 128798 601006 1.43 2014-09-30 600809 3.66 2014-09-30 000825 0.7 2014-09-30 000983 1.25 2014-09-30 126285 601006 1.47 2014-10-30 600809 3.65 2014-10-30 000825 0.97 2014-10-30 000983 1.2 2014-10-30 152173 601006 1.55 2014-11-11 600809 4.18 2014-11-11 000825 0.92 2014-11-11 000983 1.21 2014-11-11 149597 601006 1.96 2014-12-31 600809 5.04 2014-12-31 000825 1.2 2014-12-31 000983 1.56 2014-12-31 146997 601006 1.79 2015-02-06 600809 4.22 2015-02-06 000825 1.04 2015-02-06 000983 1.37 2015-02-06 144369 601006 2.06 2015-03-24 600809 4.81 2015-03-24 000825 1.29 2015-03-24 000983 1.58 2015-03-24 141702 601006 2.59 2015-04-28 600809 5.21 2015-04-28 000825 1.7 2015-04-28 000983 1.8 2015-04-28 157619 601006 2.36 2015-06-12 600809 5.71 2015-06-12 000825 2.04 2015-06-12 000983 2.12 2015-06-12 154999 601006 1.71 2015-07-08 600809 3.21 2015-07-08 000825 1.03 2015-07-08 000983 1.11 2015-07-08 152379 601006 1.49 2015-09-29 600809 3.06 2015-09-29 000825 0.94 2015-09-29 000983 1.02 2015-09-29 160259 601006 1.44 2015-12-31 600809 3.77 2015-12-31 000825 1.1 2015-12-31 000983 1.19 2015-12-31 163066 601006 1.12 2016-01-28 600809 2.91 2016-01-28 000825 0.9 2016-01-28 000983 1.35 2016-01-28 165873 601006 1.07 2016-04-28 600809 3.24 2016-04-28 000825 0.93 2016-04-28 000983 1.63 2016-04-28 196459 601006 1.04 2016-11-20 600809 3.28 2016-11-20 000825 0.89 2016-11-20 000983 1.79 2016-11-20 196460 601006 1.27 2017-05-02 600809 5.13 2017-05-02 000825 1.1 2017-05-02 000983 1.62 2017-05-02 196455 601006 1.32 2017-11-10 600809 9.97 2017-11-10 000825 1.11 2017-11-10 000983 1.63 2017-11-10 180758 601006 1.3 2017-12-29 600809 8.3 2017-12-29 000825 1 2017-12-29 000983 1.72 2017-12-29 196456 601006 1.47 2018-01-26 600809 9.52 2018-01-26 000825 1.07 2018-01-26 000983 1.74 2018-01-26 196457 601006 1.31 2018-02-09 600809 7.91 2018-02-09 000825 1.17 2018-02-09 000983 1.57 2018-02-09 196458 601006 1.22 2018-05-02 600809 7.89 2018-05-02 000825 1.21 2018-05-02 000983 1.29 2018-05-02 216392 601006 1.24 2018-07-24 000825 1.08 2018-07-24 000983 1.1 2018-07-24 216387 601006 1.06 2018-10-18 000825 0.88 2018-10-18 000983 0.98 2018-10-18 216390 601006 1.15 2018-12-28 000825 0.77 2018-12-28 000983 0.87 2018-12-28 216391 601006 1.17 2019-02-22 600809 5.73 2019-02-22 000825 0.88 2019-02-22 000983 0.9 2019-02-22 216388 601006 1.11 2019-03-26 600809 6.94 2019-03-26 000825 0.93 2019-03-26 000983 0.92 2019-03-26 216389 601006 1.14 2019-04-19 600809 7.27 2019-04-19 000825 0.95 2019-04-19 000983 1.14 2019-04-19 237558 601006 0.98 2019-08-07 600809 7.62 2019-08-07 000825 0.67 2019-08-07 000983 0.92 2019-08-07 237559 601006 0.99 2019-10-08 600809 9.05 2019-10-08 000825 0.69 2019-10-08 000983 0.91 2019-10-08 237560 601006 1.07 2019-12-31 600809 10.5 2019-12-31 000825 0.73 2019-12-31 000983 0.94 2019-12-31 237561 601006 0.92 2020-02-03 600809 8.29 2020-02-03 000825 0.62 2020-02-03 000983 0.75 2020-02-03 237562 601006 0.95 2020-02-20 600809 9.16 2020-02-20 000825 0.64 2020-02-20 000983 0.8 2020-02-20 237563 601006 0.85 2020-03-23 600809 8.13 2020-03-23 000825 0.58 2020-03-23 000983 0.71 2020-03-23