persistentone3 Posted October 28, 2012 Posted October 28, 2012 Does anyone know of a data vendor who provides 10 years of price-earnings, price-to-book, price-to-tangible-book, and enterprise value ratios for stocks? Ideally I want to have the high *and* low valuations using those metrics for each of the 10 years, to see how a stock prices out over a full cycle.
persistentone3 Posted October 28, 2012 Author Posted October 28, 2012 Morningstar has some but not all of these. I have Morningstar and I don't see these. They have return on assets, return on equity, and return on invested capital for 10 years. Where are you seeing PE, PB, PTB, and EV ratios for 10 years?
matjone Posted October 28, 2012 Posted October 28, 2012 I remembered seeing it on there but I couldn't remember exactly what it had, so I went and checked after I replied. It looks like it only does average ratios, no high and low, and there's nothing for EV or TBV. It's under the "Valuation" tab.
persistentone3 Posted October 28, 2012 Author Posted October 28, 2012 I remembered seeing it on there but I couldn't remember exactly what it had, so I went and checked after I replied. It looks like it only does average ratios, no high and low, and there's nothing for EV or TBV. It's under the "Valuation" tab. That's helpful thanks. I would still like something much more detailed if anyone knows of a source.
NormR Posted October 28, 2012 Posted October 28, 2012 Ycharts has some for free http://ycharts.com/companies/BRK.A/chart#series=type%3Acompany%2Cid%3ABRK.A%2Ccalc%3Aprice_to_book_value&format=real&recessions=false&zoom=10&startDate=&endDate=
watsa_is_a_randian_hero Posted October 28, 2012 Posted October 28, 2012 Capiq has by quarter high, low, average, and ending ratios. you can also build your own ratios using their excel plug for specific dates. for some large caps they have over 20 years of data. They have also added forward-looking multiples in recent years.
ageofsocrates Posted October 29, 2012 Posted October 29, 2012 look at thomson one banker or bloomberg if have the resources. Also can try typing the ticker on reuters.com. May be able to pull out 5 year ratios.
persistentone3 Posted October 29, 2012 Author Posted October 29, 2012 Capiq has by quarter high, low, average, and ending ratios. you can also build your own ratios using their excel plug for specific dates. for some large caps they have over 20 years of data. They have also added forward-looking multiples in recent years. Capital IQ is about $20K per year? I would like to be spending under $1K for this data.
persistentone3 Posted October 29, 2012 Author Posted October 29, 2012 Ycharts has some for free http://ycharts.com/companies/BRK.A/chart#series=type%3Acompany%2Cid%3ABRK.A%2Ccalc%3Aprice_to_book_value&format=real&recessions=false&zoom=10&startDate=&endDate= YCharts gives very decent information. It's a shame they don't package a lot of this information into a single chartview, and instead they seem intent on making you manually construct all of your indicators in a single graph. It is very cumbersome and time consuming to do this, particularly for the number of issues I follow. I also wish they would stack each indicator with a separate graph above the prior indicator, with a common timeline. Trying to overload a single graph space with six indicators gets way too busy. Still, for the money it is a good find, thanks.
watsa_is_a_randian_hero Posted October 29, 2012 Posted October 29, 2012 Capiq has by quarter high, low, average, and ending ratios. you can also build your own ratios using their excel plug for specific dates. for some large caps they have over 20 years of data. They have also added forward-looking multiples in recent years. Capital IQ is about $20K per year? I would like to be spending under $1K for this data. I get through my employer (luckily). unsure on price, though I would be surprised if we're paying that much. I did thought that they pay somewhere in the $1-3k range at the margin for incremental users. Not sure what a subscription is like for a single user.
mysticdrew Posted October 29, 2012 Posted October 29, 2012 Does anyone know of a data vendor who provides 10 years of price-earnings, price-to-book, price-to-tangible-book, and enterprise value ratios for stocks? Ideally I want to have the high *and* low valuations using those metrics for each of the 10 years, to see how a stock prices out over a full cycle. Could try Gurufocus. I believe they have each of these.
educatedidiot Posted September 25, 2017 Posted September 25, 2017 persistentone, You can get 10 year charts of price-earnings, price-to-book, price-to-tangible-book, and enterprise value ratios on Rocket. Here's Wal-Mart's 10-year EV/EBITDA chart for example: http://www.rocketfinancial.com/Charts.aspx?fID=4876&r=3650&t=4 Given all the pessimism in the market over brick-and-mortar retail, surprised to see the valuation multiple on this one near 10-year highs! If you click on the dropdown box you can access those other valuation charts that you were looking for as well.
SlowAppreciation Posted September 25, 2017 Posted September 25, 2017 Does anyone know of a data vendor who provides 10 years of price-earnings, price-to-book, price-to-tangible-book, and enterprise value ratios for stocks? Ideally I want to have the high *and* low valuations using those metrics for each of the 10 years, to see how a stock prices out over a full cycle. Could try Gurufocus. I believe they have each of these. Is Gurufocus worth the cost?
Jurgis Posted September 25, 2017 Posted September 25, 2017 Is Gurufocus worth the cost? Why not get Morningstar for free through your library (if you're in US)? Does Gurufocus have stuff which is worth it?
Travis Wiedower Posted September 26, 2017 Posted September 26, 2017 You can get most of this through Gurufocus on the Interactive Chart tab. If you're cheap like me you can use the free version, click out of the annoying pop-ups asking you to sign up, and when it restricts access you can open up an Incognito tab and keep using it. Not the most efficient method if you're pulling data for tons of stocks, but I use the above method to occasionally use their charts (which are pretty damn good for being "free") and it's fine.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now