Click here to Login








Morningstar Annual Fundamentals 2.0 for US and International Stocks

by Chaim6, 2048 days ago
Share |






This downloader gets 10 years of annual fundamentals from Morningstar's free fundamental ratios.

New features:
* It now works with non-USD financial statements.
* Balance sheet items such as Cash & Equivalents are converted from % of total assets to a dollar (or other currency) figure.
* Income Statement items such as COGS and Gross Profit are also converted from % of sales to a dollar (or other currency) figure.
* It lags the fiscal periods by 45 days + 2 weeks.

Limitations:
* Uses the name3 field as the symbol name.
* These numbers are taken from the annual statements which only get updated once a year. It does not record the most recent data from that web page.
* This downloader uses a different database layout than the original Morningstar downloader.

Usage notes -- Important!
* Before downloading data, the 'Name3' field must be filled in with a ticker recognizeable to Morningstar. For US companies this usually means the US ticker. However for most foreign traded stocks the Name3 field format is "[ticker]®ion=[region]".


Suggested uses:

* This downloader is useful to screen for free global (or international) Benjamin Graham Net Nets or for other fundamental factors.
* Free screening and/or ranking pased on fundamentals such as PE, Price to Book ratio, Price to Sales ratio etc. for US and international stocks.

Wonk Notes:
* Many of the numbers are derived from ratios and are therefore approximate due to rounding errors.
* For international stocks you will need to convert the currencies so that the fundamentals and the price are of the same currrency.
* The default curency is the same as net income unless specified there is a special field in the database for the currency of that item.

Some of the fundamental data included is:
Sales (revenue)
Gross Margin
Operating Income
Net Income
Earnings Per Share
Dividends
Shares Mil
Book Value Per Share
Operating Cash Flow
Cap Spending
Free Cash Flow
Free Cash Flow Per Share
Working Capital
COGS
Gross Margin
SG&A
R&D
Other
Net Int Inc & Other
EBT
Profitability
Tax Rate %
Net Margin %
Asset Turnover (Average)
Return on Assets %
Financial Leverage (Average)
Return on Equity %
Return on Invested Capital %

Key Ratios -> Growth
Revenue %
Year over Year
3-Year Average
5-Year Average
10-Year Average
Operating Income %
Year over Year
3-Year Average
5-Year Average
10-Year Average
Net Income %
Year over Year
3-Year Average
5-Year Average
10-Year Average
EPS %
Year over Year
3-Year Average
5-Year Average
10-Year Average

Key Ratios -> Cash Flow
Cash Flow Ratios
Operating Cash Flow Growth % YOY
Free Cash Flow Growth % YOY
Cap Ex as a % of Sales
Free Cash Flow/Sales %
Free Cash Flow/Net Income

Balance Sheet Items
Cash & Short-Term Investments
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Net PP&E
Intangibles
Other Long-Term Assets
Total Assets
Accounts Payable
Short-Term Debt
Taxes Payable
Accrued Liabilities
Other Short-Term Liabilities
Total Current Liabilities
Long-Term Debt
Other Long-Term Liabilities
Total Liabilities
Total Stockholders' Equity

Total Liabilities & Equity
Liquidity/Financial Health
Current Ratio
Quick Ratio
Financial Leverage
Debt/Equity

Key Ratios -> Efficiency Ratios
Efficiency
Days Sales Outstanding
Days Inventory
Payables Period
Cash Conversion Cycle
Receivables Turnover
Inventory Turnover
Fixed Assets Turnover
Asset Turnover


Share This ->
Share |


You have to log in to bookmark this object
What is this?




Type: Download Script

Object ID: 1543


Country:


Market:

Style:

Reviews
You must log in first

Join now
and get instant access for free to the trading software, the Sharing server and the Social network website.
Click here


Related objects

Empty

Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object

Technical Analysis


Fundamental Analysis



Random Blog Posts

QuantShare Trading Software: New Features in the 3.3.1 Version

3 Items To Get and Trade the News In QuantShare Platform

How to Create a Custom Real-Time Table using QS Trading Software

Let me Show You How to Create Hundreds of Profitable Trading Systems

How to Backtest a Strategy from a Chart

How to Reference Drawing Studies in QS Formulas

Let QuantShare Manage your List of Securities

The Ultimate Guide to Create Trading Systems in QuantShare

Show All

Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object






QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright © 2024 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.