Step 1: Baidu search almond, open almond official website.
Step 2: Click the index, enter the CSI bonus in the search box, and select the one with the word index behind it.
Step 3: Click PE-TTM, weighted by market value, 10 year, and finally click Export CSV, which also exports the CSV of PB.
Step 4: Open the downloaded csv table, click the weighted column of PB market value in the PB table, and copy and paste it into the PE table.
Step 5: In the PE table, only time, PE-TTM market value weighting and PB market value weighting are reserved, and a column is left in the middle.
Step 6: Write down PE temperature, PB temperature and long-term input temperature.
Step 7: Enter "=percentrank ()" in the pe temperature column corresponding to the date you want to query (suppose it is May 22nd), and the formula will pop up automatically. Fill in the brackets, arrays, values and decimal places, then multiply by 100, and press enter to complete the PE temperature. Similarly, calculate the PB temperature, and directly copy and paste the previously calculated contents at the PB temperature.
Step 8: After completion, enter the formula "=(PE temperature +PB temperature) /2" in the column below the long-term input temperature.
Step 9: After completing the above steps, you can get the long-term investment temperature value you want to know that day, and then according to this value, you can switch the index and buy and sell funds by yourself.