Yahoo finance vs SEC filings fundamentals
"Sure, Yahoo Finance makes mistakes from time to time.  That's the nature of free data. However, I think the issue here is that yahoo is aggregating several line items into one.  Like maybe reporting cash equivalents plus total investment securities minus loans as ""cash equivalents.""  This aggregation is done by a computer program somewhere and may or may not be appropriate for a particular purpose and firm. For this reason, if you are trying to do top quality research, it's always better to go to the original SEC filings, if you can.  Then you will know for sure which items you are looking at.  The only mistakes will be the ones made by the accountants at the firm in question. If there's a reason you prefer to use yahoo, like if it's easier for your code to scrape, then spend a little time comparing to the SEC filing to ensure you know where the numbers really come from before using it."
I also searched for some time before discovering Market Archive, which AFAIK is the most affordable option that basically gives you a massive multi-GB dump of data.  I needed sufficient data to build a model and didn't want to work through an API or have to hand-pick the securities to train from.  After trying to do this on my own by scraping Yahoo and using the various known tools, I decided my time was better spent not dealing with rate-limiting issues and parsing quirks and whatnot, so I just subscribed to Market Archive (they update the data daily). Well, it also discusses other traditional valuation techniques such as the economic profit model and it has a chapter on real option valuation. But I would not label those exotic valuation methods. However, I would say that the CFA challenge is much about standard valuation methods due to the limited page limit and considering that there should properly also be an analysis of the external and internal environment to determine the future prospects of the given company. "The SEC requires a certain format when submitting filings, which generally does not line up with how documents are typeset for printing.  Rather than typeset the entire document again, it's just sort of accepted that the format in EDGAR will suck.  Typesetters actually call the process ""EDGARizing.""  (I'm not making this up, I used to work in the department at a mutual fund company that put together the financial reports for the funds.)  My guess is it's a relic from legacy systems at the SEC that can't handle newer formats like PDF." You will need to merge CRSP with the Compustat Annual Fundamentals database, since CRSP only contains stock price/return data, whereas Compustat has data on total assets and other accounting variables.   What software are you using? It's usually very easy to filter the data after loading it into your software. "SEC filings do not contain this information, generally. You can find intangible assets on balance sheets, but not as detailed as writing down every asset separately, only aggregated at some level (may be as detailed as specifying ""patents"" as a separate line, although even that I wouldn't count on). Companies may hold different rights to different patents in different countries, patents are being granted and expired constantly, and unless this is a pharma industry or a startup - each single patent doesn't have a critical bearing on the company performance." "Google Docs spreadsheets have a function for filling in stock and fund prices.  You can use that data to graph (fund1 / fund2) over some time period. Syntax: =GoogleFinance(""symbol"", ""attribute"", ""start_date"", ""num_days|end_date"", ""interval"") where: This analysis won’t include dividends or distributions. Yahoo provides adjusted data, if you want to include that." The 15% Alibaba stake was invested in way before Mayer's came on board.  It's worth $51.75B right now.  Yahoo Japan is an autonomous company, that Yahoo has a 36% stake in, spun off well before Mayer's came on board and that stake is conservatively worth$10B.  Yahoo market cap is only $49B right now.  If anything, Marissa Mayers tenure just killed off the core value of Yahoo itself to the level that it's a liability and it's asset portfolio is the only thing holding it aloft. the financial information is generally filed via SEDAR (Canada) or SEC (US) before the conference call with the investment community.  This can take before either before the market opens or after the market closes.  The information is generally distribute to the various newswire service and company website at the same time the filing is made with SEDAR/SEC. You'd have to buy that information. Quoting from this page, Commercial Historical Data Higher resolution and more complete datasets are generally not available for free. Below is a list of vendors which have passed our quality screening (in total, we screened over a dozen vendors). To qualify, the vendor must aggregate data from all US national/regional exchanges as only complete datasets are suitable for research use. The last point is especially important as there are many vendors who just get data from a couple sources and is missing important information such as dark pool trades. They offer some alternatives for free data: Daily Resolution Data 1) Yahoo! Finance– Daily resolution data, with split/dividend adjustments can be downloaded from here. The download procedure can be automated using this tool. Note, Yahoo quite frequently has errors in its database and does not contain data for delisted symbols. 2) QuantQuote Free Data– QuantQuote offers free daily resolution data for the S&P500 at this web page under the Free Data tab. The data accounts for symbol changes, splits, and dividends, and is largely free of the errors found in the Yahoo data. Note, only 500 symbols are available unlike Yahoo which provides all listed symbols. And they list recommendations about who to buy the data from. This is correct. The most rapidly expanding areas in finance resemble computer science more than they resemble traditional finance. The compliance and legal side of things, however, is only getting more and more complicated. At my firm, the compliance personnel outnumber the traders three to one. I use and recommend barchart.com. Again you have to register but it's free. Although it's a US system it has a full listing of UK stocks and ETFs under International > London. The big advantage of barchart.com is that you can do advanced technical screening with Stochastics and RS, new highs and lows, moving averages etc. You're not stuck with just fundamentals, which in my opinion belong to a previous era. Even if you don't share that opinion you'd still find barchart.com useful for UK stocks. "P/E is Price divided by Earnings Per Share (EPS). P/E TTM is Price divided by the actual EPS earned over the previous 12 months - hence ""Trailing Twelve Month"". In Forward P/E is the ""E"" is the average of analyst expectations for the next year in EPS. Now, as to what's being displayed. Yahoo shows EPS to be 1.34. 493.90/1.34 = P/E of 368.58 Google shows EPS to be 0.85. 493.40/0.85 = P/E of 580.47 (Prices as displayed, respectively) So, by the info that they are themselves displaying, it's Google, not Yahoo, that's displaying the wrong P/E. Note that the P/E it is showing is 5.80 -- a decimal misplacement from 580 Note that CNBC shows the Earnings as 0.85 as well, and correctly show the P/E as 580 http://data.cnbc.com/quotes/BP.L A quick use of a currency calculator reveals a possible reason why EPS is listed differently at yahoo. 0.85 pounds is 1.3318 dollars, currently. So, I think the Yahoo EPS listing is in dollars. A look at the last 4 quarters on CNBC makes that seem reasonable: http://data.cnbc.com/quotes/BP.L/tab/5 those add up to $1.40." "First, don't use Yahoo's mangling of the XBRL data to do financial analysis.  Get it from the horse's mouth: http://www.sec.gov/edgar/searchedgar/companysearch.html Search for Facebook, select the latest 10-Q, and look at the income statement on pg. 6 (helpfully linked in the table of contents).  This is what humans do. When you do this, you see that Yahoo omitted FB's (admittedly trivial) interest expense.  I've seen much worse errors. If you're trying to scrape Yahoo... well do what you must.  You'll do better getting the XBRL data straight from EDGAR and mangling it yourself, but there's a learning curve, and if you're trying to compare lots of companies there's a problem of mapping everybody to a common chart of accounts. Second, assuming you're not using FCF as a valuation metric (which has got some problems)... you don't want to exclude interest expense from the calculation of free cash flow.  This becomes significant for heavily indebted firms. You might as well just start from net income and adjust from there... which, as it happens, is exactly the approach taken by the normal ""indirect"" form of the statement of cash flows.  That's what this statement is for.  Essentially you want to take cash flow from operations and subtract capital expenditures (from the cash flow from investments section).  It's not an encouraging sign that Yahoo's lines on the cash flow statement don't sum to the totals. As far as definitions go... working capital is not assets - liabilities, it is current assets - current liabilities.  Furthermore, you want to calculate changes in working capital, i.e. the difference in net current assets from the previous quarter.  What you're doing here is subtracting the company's accumulated equity capital from a single quarter's operating results, which is why you're getting an insane result that in no way resembles what appears in the statement of cash flows.  Also you seem to be using the numbers for the wrong quarter - 2014q4 instead of 2015q3. I can't figure out where you're getting your depreciation number from, but the statement of cash flows shows they booked $486M in depreciation for 2015q3; your number is high. FB doesn't have negative FCF." Option tiers are broker specific, according mostly to their business model and presumably within the bounds of FINRA Rule 2111 (Suitability). The tier system can be as complex as E*Trade or as simple as none with Interactive Brokers. The suitability is determined presumably by compliance presumably by the legal history of the rule. The exact reasoning is political, effected by the relevant party composition of the legislature and executive. The full legal history will have the judiciary's interpretations of legislation and policy. Cash and margin rules are dictated primarily by the Federal Reserve and more precisely by FINRA and the SEC.  This is the only distinction made by IB. "Although is not online, I use a standalone version from http://jstock.sourceforge.net It got drag-n-drop boxes, to let me design my own indicators. However, it only contain technical analysis information, not fundamental analysis information. It does come with tutorial http://jstock.sourceforge.net/help_stock_indicator_editor.html#indicator-example, on how to to build an indicator, to screen ""Stock which Its Price Hits Their 14 Days Maximum"""