Following a reader’s comments on the STI PE10 data, I’ve decided to make it available for download. If you go to the site, you’ll now notice that I’ve added a “Download Data” button in the ‘Background’ section.

dwnloadData.JPG

Have fun with the PE10 data. It’s something I’ve compiled every month for the last 5-6 (?) years.

There are five pieces of data in the file:

(1) the STI close,
(2) the PE  ratio,
(3) the date,
(4) the implied earnings, and
(5) the average 10-year earnings.

(1), (2) and (3) are self-explanatory. You may find some discrepancies with actual data as there were certain months that I failed to update the data in time and therefore had to extrapolate the data, or I updated a day or two later than I was supposed to. However, for all intents and purposes, it should reflect the PE10 fairly accurately.

(4) and (5) are calculated based on (1) and (2). In order to get an average of the past 10 years’ earnings, I need the current earnings. This is where the “implied earnings” is easily calculated by taking (2) divided by (1). With (4), you can then calculate (5). The PE10 which is not in the file is then simply (1) divided by (5).

Some people may prefer to use an exponential moving average of 10-year earnings or you want to adjust earnings for inflation like Shiller does. Feel free to use the data as long as it’s not for commercial purposes.

If you find anything wrong with it, feel free to let me know.