长投温度的计算(电脑版、沪深300)

1、长投温度的计算（电脑版，以计算沪深300指数的温度为例）一、打开理杏仁二、搜索到沪深300指数，分别下载PE和PB数据1、PE：选择PE-TTM,加权平均值，10年，点击“导出CSV”、“按周”下载到电脑中2、PB：同理，选择PB，加权平均值，10年，点击“导出CSV”、“按周”下载到电脑中三、用excel或者wps开始计算1、打开PE数据文件，只保留时间和PE-TTM两列，其他没用的删除。时间这列如果显示是乱码，就把列宽加宽一些。,也.BCDEFGH1J1I时间点位市值流通市值PE-rn（加PE-TTM分PETTM危HPE-ITH中（PE-TTK机会值（加权平均值2#321S.413.06E

2、4132.27E+1310.72380.233615.663512.9310.38943#3257.673.08E+132.29E+1310.E2D70.242115.66712.931710.39064#3167.443.03E4132.25E+1310.2760.225615.66712.953310.39065253.L4E4132.33E+1311.C3710.269615.66712.953310.3906631K64MD7E+13工26E+1310.153Ci.247915.66712.953310.39067#3134.953.D2E+13223E+1310.74310.2314

3、15.66712.96S910.3906B3170.733.05R4132.26E+1310.E7220.240415.66712.976010.3906934S2.as3.22R+132.43E+1311.6930.359215.66712.991710.3906103410.493,25E+132.4E+1311.一口吕0,333215,675712.599610.390011flffffffffU3242.093,QSE+13乙23E+1310.9650,252315.675713.014110.3906123277.白43.D5B+132.29E+1311.前技0.25T715.075

4、713.032110.390D13ffffffRfifi3334.53.L4E+132.33E+1311.1740.278315.090513.0410.390614#3325.333.L3E+132.32E+1311.59500.307415.714S13.057B10.390615#32Z3.Q23.04B+132.2QE+1311.1120D.2715.732513.077710.390D16#3405.023.L9E+132.37E+1311.7330.354715.769313.084110.39061?#3315.283.L2E+132.31E+1311.47D60.311515.

5、786913.098110.390613#3521.233.26B+132.42E+1312.C2580.385115.803513.108810.390619#3492.393.22E+132.39E+1311.ES520.369515.041213.117210.390620#3492.693.23E4132.39E41311.?0330.370315.346413.123410.390621#3365.123.L2E4132.32E+1B11.4460.313615.863313.137110.390622#3510.983.23E+132.4E+1311.F9470.365415.80

6、6318.147910.390623#*360S.93.33E4132.46E+1312.2290.394615.904113.164510.3906243753.433.45E4132.54E+1312.esei0.42415.929913.175410.390625#3779.623.34E+13工49E+1312.ES51Ci.417315.9513.1S1110.390626#*#3770.593.34E413或49E+1312.312.419615.967313.194410.3906273EL6.53.4R+132.52E+1312.E2750.441415.9731IS.2093

7、10.390628#3903.063.49R-H32.5SE+1313.19370.496116.033513.225fi10.3906293B72.343,46E+13乙50E+1313.CSD10,474716,Q63S13.2SOB10.3900303774.03,3TE+13工49E+1312.73150,4Z33L&.03413.24Z110.390031flffffffffu3750.as3.3TB+132.43E+1312.E3D30.44口白10.099413.252710.390D3Z并并#37DD.353.35E+132.47E+1312.S9L20.技9310.13711

8、3.201710.390D33#3B7L.143.44E+132.54E+1313.57D70.515410.180813.274210.390D34#SB54.ao3.41B+132.51E+1313.2SL50.501310.199213.274210.390D:1匚JJJJJJJJJJ,uCCiI-,riuc*qrtcfCCTT-ITCTCEaTirT!4qLIiccrr保留成以下的样子时间pe-ttjK加权平均值）2010/11/2010.7238201S/11/1610.S20720LS/11/910.62762018/11/211.0371201B/10/2610.9153201S

9、/10/1910.74312018/10/1210.87222018/9/2811.66932018/9/2111.550820LS/9/1410.965201B/9/711.014920LB/8/3111.1742018/S/2411.3956201S/S/1711.112620LB/8/1011.7332018/8/311.47062、打开PB文件复制PB（加权平均值）这一列，粘贴到PE表格中。如下图4A匚D1i时间FE-TTM（,加权平均面PBG5l权立均1122013/11/2010.T2381.31132013/11/1610.82071.323142QLE/11/910.6276L

10、2P94520LB/11/211.03711.3496b2019/10/2610.9L53L.366S12013/10/1910.74311.303182013/10/1210.87221.37969201.E/972811.Q&931.48071020LB/9/2111.55081.4662112QLE/9714LCL965LJ3907122018/9/711.01491.3959132OLB/0/31LI.174L.4153U20LB/872411.395C1.43171520LB/8/1711.11261.392416201.E/S/10LL7331.4626172010/8/311.4

11、7061.4236182QLE/7/2T130258-4971920LB/7/2011.88521.47322020LB/7/1311.903SL.4702212018/7/C11.49461.40932220LB/6/2911.89471.462123201.E/672212.2291.50062A20LB/6/1512.68611.552825201S/6/S135891L.siai262018/6/112.63121.51523、按照时间排序，最远的时间在最开始，最近的时间在最后面，效果如下：ABcDE时间sPE-TTM（加权平均值HlPE（加权平均三)200S/11/2114.1772

12、.2605200S/11/2B13.47792.USB2008/12/514.45972.30452008/12/1213.98822.23012008/12/1914.34032.2862008/12/2613.17592.10132008/12/3112.91982.05782009/1/913.47362.15842009/1/1013.7B092.20B02009/1/2314.05762.25232009/2/615.37352.46312009/2/1316.26B22.60632009/2/2015.S1B52.53202009/2/2714.70052.3527i2009/3/

13、615.45462.46742009/3/1315.10332.39132009/3/2016.22252.553212009/3/2717.35272.61372009/4/3IS.02442.64352009/4/10IB.26782.65972009/4/1719.60342.72452009/4/2420.2B832.65212009/4/3022.81852.61452009/5/824.32332.76844、在PE-TTM后面插入新的一列“PE温度”，在PB后面插入新的一列“PB温度”，在最后加入“长投温度”，如图AE,CDEF时间WPE-E（加权平均值PEifiMWPEL加权可

14、均刁PE温度长投温度200S/U/2114,1772.30052008/11/26134772.14332008/12/514.45972,3045z2008/12/1213b93B22.23012008/12/1&14.34DS22腼2Q08/12/2613ul7592.LQL32008/12/3112.91982.057820Q9/1/913.473&2.15342003/1/1013.7Hg2.20能2009/1/Z314.057&2,25232005/2/615,37352,非3120Q9/Z/1310.2&BZ2.&Q&32003/2/2015.51B52532820Q9/Z/271

15、4.70052.352T2005/3/615,4546243743005/3/1a15r1033a,39132009/3/20IQ.22252.55322009/3/3717J35275,61372005/4/313,02442.04352009/4/1018.26782,65972009/4/176034九72453009/4/3420.28BS2.05212009/4/302281B52.61452009/5/824.323S2.7G842009/5/1524.44&378312009/5/2223.99582.73872009/5/2724,323工7T442005/0/525.5fi&

16、72.95825、开始计算PE温度。在B3格子里录入公式=NORMDIST(B3,AVERAGE(B$2:B3),STDEV(B$2:B3马*其场粘贴”艮制格捋B/P田丁E11-Id牙叁”;IA-A-二三三三三3:二=,三舌中，三触布JJ隼现%SUMIKI=NORMD1ST(B3.AVERAGEE32:B3),STDEVE32:E3J3LH100dAB匚DEFG1时间FE-TTM加利匚均值*!FE温度二邛1加根平均可PE电度长投温度22003/11/2114-177.2.2A0532003/11/231S.4779=NORMDICT(2.14884200B/12/514.45972.30455

17、2003/12/12IS.9882、2.230162003/12/1914.34032.28S72003/12/26IS.17592.101382003/12/3112.9L9S2.O57S92009/1/91S47SS2.15841Q2009/1/lfiIS.78S92.208S112009/1/2314.057fi2.2523122009/2/615.37352.4AS1C4”U乐I/.AB，L口EF1时间PE-TT联加权平均值SPE温度三PEC加极平均向PE温度长投温度22008/11/2114.1772.260532008/11/28L3.4779r23.9750061L2.14084

18、2003/12/5L4.45971I2.304552008/12/12L3.90822.2801&2008/12/19L4.34032.206J2008/12/26L3.17592.1013B200S/12/31L2.9198工0578gZ009/1/9L3.4736工1584102009/1/16L3.78692.208612009/1/ZSL4.05762.252322009/2/5L5.3735工4631R2009/Z/13LG.26SZ2.6063142009/2/20L5,81852.532852009/Z/Z7L4.70052.3527162009/3/5L5.4546工4674把

19、公式复制到下面每一行C34国方=flDJ!IUIST(E3,AVERAGE(B$3:EK,STJEV2;B3),1)+100A-FE-rrnig相平也值一CDEFG由三FE温度-PEf加权平均,FE温度长投温度?2003/11/2114.1772.26053201)8/1；2313.477923,9750OS112.14I94ZD0E/1Z/519773.7EM2呈M2.304552003/12/1213.993246.3B6245-45工23(1152008/1214uS40S74,352078262.须7200S/12/2613,17596.6EdE639092.10133200a/12；

20、3112.91337.3757740243屹花92009/1/913.473031.237063712.1534G3D0S/1/1613.52,35633102.加脚12W/1/23i*057670.2B2739422.25232Ea9也加15.37359i3QWQT12r钦132D09/2/13【和2692ea.a95ioir2.刖羽42000/2/2015.Hl9593.B76449552.5323521)1)2/2714,700666.351450572.362762gq尚四15u45史iB6.424539工的T47E009/3/1315.LQ337&.114835972.3513S2D

21、(J9/3/2UIbu222594,920937552553292DD93/2717,35279E.646759562.61376、同理计算PB温度，公式变为=NORMDIST(D3,AVERAGE(D$2:D3),STDEV(D$2:D3),1)*100口复制格式周日乜田以三三三三二合并居中-三动慢行E3较fx=N0RIDISr(D3nAVERAGE(D$2:D3),STDEV(D32:D3),1)*100ABToIe、1=(时间0FE-TTM（加权平均值，fe温度Efe（加权平均刁FE温度长投温度OOB/11/Z114.177Z.Z605OOS/11/2S13.477923.9750061

22、12.1488123.975006112003/12/514.459779.7B5624E42.3045008/12/1213.988246.3B624552.2301OOS/12/1914.340374,35267B262.20SL003/12/2613.17596.&a4B6S9C92.1013?OOS/12/3112.919S7.3757746242.057S2009/1/913.473631,23766B712.15S42009/1/1613.78S952.ssessiee2.20se2009/1/2314.057S70,29273822.25232009/2/615.3T359930

23、000712.46312009/2/1316.26829939510172.60632009/2/2015.018593.S76449E52.532S2009/2/2714.700566,351450972.35272009/3/615.4546S6.42453C2.4674把公式复制到下面每一行Fil,QA/AECDEFG1町问MPE-TTH（加权平均值，PE温度二邛（加权平均三PE温度长投混度I2008/11/2114.ITT2.3605200S/LL/2S13=4779r23.975006112.14BBr23.97500612008/127514.45打79.785e24542.304

24、5r79.65411972008/12/1213.988246.386245452.2301746.43402b2008/12/1914.340374,352678263.3B6F74.37613H200S/L2/2613=17596.6848689092.1U1SF6.70290227J2008/12/3112.E流7.375774242.057l：rM7533962?2009/1/913=473631,237668712.15a4r34.07679702009/1,/1.&13.T8&952.356331962.2口日/56.3450H622009/1/2314.C57670,292738

25、422.2523,73.5776705122009/2/615.3T3590,30000712.4631F9S.43771Bi32009/2/LS10.2082SH.89510172.000393.907507142009/2/2015.B1B593.S76449552.532BF93.H9H495752009/2/2714.7005QQ.351450972.3527*66.0504309&2009/3/615.454606.4245392.4674FB5.716B05572009/8/IS15.103370,114835972.3913r71.000307532009/3/2016.2225

26、94.920937952.5532F92.54&H3HB92009/3/2717.352790.04759502.6137*94.Q71B5B02009/4/3IS.024490,300236522.6435F94.55904512009/4/1018.207890,082717042.05973,010424724门719.岛口4AA.157RS?S?fiS?2.745F95.45fi5fil77、计算长投温度。公式为=（C3+E3）/2,PE温度和PB温度的平均值J1SUHIFXb1及二(C3-3)/2AJECDEFGE1间PE-TDA（加板平均值三FE温度EFE1加根平均日FE温度长投温

27、.度2008/11/2114,1772.2605.2008/11/2813.477923.975006112.148813.97500611J；22008/12/514.45979.7S5Q2442.3045f79.D54LL97-200S/12/1213.90S246.386245d52.230/46,434S262008/12/1914.340374.352678262.286r74,37613142008/12/2613.1759S.e848689C92.1013r6.702902272008/12/3112.Hl兆7.3757740242.Q578r7.175339022009/1/9

28、13.473631.23766S712.15S4r34.S767972009/1/1613.706952.356331262.2086r56,34508622009/1/2314.057670.29273822.2523r73,57767352005/2/015.373558.3000Q72.4631r9B,4377LB4把公式复制到下面每一行_F3r力=(C3+E3V2EIC口EFC时间FE-TTK加板平均值司PE温度EPE加极平均二FE温度长投温度2003/11/21111772.260532008/1L/2B13.47793r97500Hl2.1438r23.975006123.9750

29、06142003/12/514.459779.785624542.304579.654119779.71937212008/12/1213.938246.38624?452.230146.434E2646.410535T62QOS/12/1914.340374.35267E2&2.23674.376131474.364404872000/12/2613.17596.694668092.1013飞.702902276.69388559S2000/12/3112.91987.375774242.05737.L75339627.2755571292009/1/913.473631,23766E712.153434.87679733.0572328102009/1/1613.736952.3563S19&2.20365fl.3450Efl254.3507091r2009/1/2314.057G70.29273E422.252373.577678571.93520B