There seems to be a problem with the signup process. It’s probably an issue created by the plugin that administers the WordPress forum. I will check if I can fix this. If not, I will install a different forum plugin. Stay tuned!

Sorry about the delay!

Policies – please read!

  • Everyone can read posts, but to start a new topic or add a reply you’d need to register. (Apparently, a WordPress ID is required)
  • Be courteous to others. Treat others like you like to be treated. Discuss the issues. No ad-hominem attacks!
  • It’s OK to include external links if they are relevant. But please avoid spamming! Please no affiliate links.
  • Before starting a new topic, please check if that question/topic has been discussed before already and add to that discussion instead of starting a new topic.
  • If you’ve written a cool blog post that you want to share with others please post this in the “Self-Promo” category only!
  • Please read the usual Disclaimers and the Privacy Policy!
  • The forum policies may be amended in the future!
Please or Register to create posts and topics.

Shiller CAPE data

It looks like the Shiller CAPE data on his website ( is not available. But don't despair! In my post a few months ("Building a Better CAPE Ratio") ago, I mentioned that I run the CAPE update (almost) daily and post it here:

The 12/30/2022 CAPE is 27.47 (original CAPE methodology, but with month-end index value) and 22.20 (my new method factoring in corporate tax changes and share buybacks).

harishkswamy, FireCrackersJourney and savinglabor have reacted to this post.


For easy access to the Shiller CAPE ratio from the official website, I use the following formula into my GoogleSheet:


It automatically pulls the latest CAPE ratio value, so that I don't have to manually upadate it.


Would you/someone know if I could do similar value extraction from your csv file?


Good question. I have no idea. Ideally, I'd need a tool in WordPress to read my CSV data table, and display the output on my site. Then you can grab it from there with that IMPORTHTML command.

But I don't know how to update that. I will research that, though.

A reader found a way to link the ERN CAPE estimates into a Google Sheet.

I added the CAPE estimates to my SWR sheet, tab "CAPE-based Rule". See cells C5-D9. This utilizes the IMPORTDATA function.

Note: CAPE.1 is the Shiller CAPE but using the most recent EPS numbers and using the most recent or month-end S&P data.

CAPE.2 implements the corporate tax and earnings reinvestment adjustments.

Thanks to reader "Jason" for solving that riddle!

jt17 and FireCrackersJourney have reacted to this post.