
Please try another search
I have been a long time reader of your blog but writing for the first time. To me a key part of the investment process for a generalist investor has to be a way to efficiently screen stocks to generate investment ideas and also measure historical returns and fundametals for various industry groups under various economic conditions. I am curious as to what data sources you use in your own work for historical stock market and fundamental data? Do you pull this into your own database and do you use Excel or a statistical package for any quantitative backtests for your screens?
In a previous job I used FactSet to pull historical monthly pricing and quarterly fundamental data for a universe of over 100 regulated utility stocks (both current and past public firms). I also taught myself a fair bit of statistics along the way including logistic regressions and discriminant analysis in order to backtest different models for identifying outperformers, dividend growth/cuts etc. Unfortunately I had to do this all in Excel, which made the whole process pretty painful right on from cleaning up outliers, sorting etc. I guess for simple queries of stock performance and tracking various fundamental metrics over time it would work touse Excel.
One motivation for asking is that I hope to one day become an investing blogger myself, and am wondering if there are low cost ways of accesing this kind of data. Additionally I am always interest in real world methods people follow to prune the thousands of possible stocks to invest in to a smaller more promising subset that people can invest more time analyzing on a fundamental basis. To me the hallmark of a successful investor is the willingness to unturn many investing stones until a promising idea is found.
I am a tightwad when it comes to paying up for data or software. I use the following:
AAII Stock Investor and Value Line are my main screeners. I pay $100/year for AAII, and nothing for Value Line. Oh, my library gives me Morningstar for free as well. Both subscriptions are very full, and very useful as well.
Now all that said, though it is important to be able to access the data, developing the ability to interpret it is far more important. There can be too much rigor in trying to analyze quantitative data. You need to identify the three most significant variables that affect the result being analyzed and focus on analyzing them. Most investment questions can be analyzed through the three most important variables.
Though I do backtests occasionally, I am happier to stick with theory, and base my actions off that. Backtests are fraught with all sorts of bias, and basically say that the future will be like the past, only more so.
It would be great to have Bloomberg, FactSet, and some off-the-shelf statistics/programming package that integrates with them. But life is tough, and we don’t always have that luxury, so we have to seek out data on the cheap, and analyze it cheaply also.
That’s how I do it now, but if I get more clients, I will start paying up for data and software.
As we enter a historically weak period for the stock market, negative investor sentiment has moved above its historical average Meanwhile, recent developments at Adobe have made...
Stocks took a hit last week, with the S&P 500 plummeting by more than 3% and the Nasdaq 100 by almost 3.5%. The Russell 2000 fared even worse, dropping nearly 4%. While markets...
The weekly chart formed an S&P 500 Futures two-legged pullback testing near the February 2 breakout point. The bulls see the move simply as a pullback and want a retest of the July...
Are you sure you want to block %USER_NAME%?
By doing so, you and %USER_NAME% will not be able to see any of each other's Investing.com's posts.
%USER_NAME% was successfully added to your Block List
Since you’ve just unblocked this person, you must wait 48 hours before renewing the block.
I feel that this comment is:
Thank You!
Your report has been sent to our moderators for review
Add a Comment
We encourage you to use comments to engage with other users, share your perspective and ask questions of authors and each other. However, in order to maintain the high level of discourse we’ve all come to value and expect, please keep the following criteria in mind:
Enrich the conversation, don’t trash it.
Stay focused and on track. Only post material that’s relevant to the topic being discussed.
Be respectful. Even negative opinions can be framed positively and diplomatically. Avoid profanity, slander or personal attacks directed at an author or another user. Racism, sexism and other forms of discrimination will not be tolerated.
Perpetrators of spam or abuse will be deleted from the site and prohibited from future registration at Investing.com’s discretion.