Hi Randy,
I see you may move the group page - I'll keep an eye on that. You may recall my note below about using Gurufocus to pull data that used to be available using the Adfn definitions. I am happy to report Guruf works, however, they charge a premium plus membership to get access to their information - thats ~$1,250 per year.
That's steep, do you know of any other source where I can pull 10 year historical data from for ROIC, BVPS, EPS, Sales and Cash?
This is killing me but figured if anyone knew, you would.
Thanks,
Brent
On Monday, October 14, 2019, 07:41:12 AM EDT, Brent <freefaller6@yahoo.com> wrote:
Hi Randy,
That's a good idea, but not sure how Gurufocus could automate the system like I had it with the Advfn values. And it does work well - one of my recent "wins" came from my sheet identifying that RH was on sale at $40 a few years back...not too shabby of a return so far.
The way that my sheet use to work, based on Phil's system, was that I would run a screen based on set criteria that would return about 50 candidates. I would then cut and paste the symbols into my sheet and it would pull the 10 year data for ROIC, EPS, Sales, Cash. Rule #1 isn't necessarily about that raw data as it is about the growth rates over ten years. So my sheet would take the raw data, calculate the growth rates and based on the growth rates, I could quickly see if it was a valid candidate. If so, the sheet would then calculate what the future price could/should be, assuming it was a good company and the 10 year trend continued (this is where some of the subjectivity and research into the company comes in). Then the sheet would discount that future price to what the current price should be. You then add in a margin of safety to the calculated current price, and compare that against current market price. If the margin of safety price is less than the market price, and subjective analysis of the company is strong, it's one to strongly consider.
This entire process was automated with the Advfn values. I would run a screen, copy/paste ticker symbols and out would pop potential winners.
Do you think that could be done with Gurufocus? I am not familiar with the paid version of the site, but would be happy to become a member if it restored functionality of the sheet with some tweeking.
Thanks,
Brent
On Sunday, October 13, 2019, 01:23:58 PM EDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
If it works that well, why not subscribe to GuruFocus? You could probably even automate the process with their screener tool, even to send you email alerts of stocks making their way onto or off of your selection universe.
On Sun, Oct 13, 2019 at 9:18 AM freefaller6@... wrote:
Has anyone found a solution yet for a workaround for the Advfn elements that no longer work? Specifically, I am looking for definitions that can provide 10 years worth of ROIC, EPS, Sales, Cash, and book value per share.
If anyone can help me find or create definitions for these, I am willing to share a worksheet I have created that calculates what a stock price should be based on a discounted cash flow method. You can then compare this against what the price is, and determine whether or not it's "on sale." It has worked REALLY well for me, but without the Advfn elements, I am a ship without a rudder.
This method is based on Phil Town's Rule #1 Investing and essentially takes his book and breaks it down into a spreadsheet - it automates (or it did) his process. This spreadsheet is a value investors dream. So if you have a source for this information and can help create some elements, let's talk.
Tidak ada komentar:
Posting Komentar