1. Guide To Excel For Finance: Introduction
  2. Guide To Excel For Finance: Goal Seek
  3. Guide To Excel For Finance: PV And FV Functions
  4. Guide To Excel For Finance: HLookup And VLookup
  5. Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel
  6. Guide To Excel For Finance: Ratios
  7. Guide To Excel For Finance: Technical Indicators
  8. Guide To Excel For Finance: Valuation Methods
  9. Guide To Excel For Finance: Advanced Calculations
  10. Guide To Excel For Finance: Conclusion

Today, there is literally a multitude of ways to link external stock market data into Excel. The point of downloading data is to be able to customize and manipulate it to create your own formulas, which can be refreshed throughout the day as stocks change in value, or as often as you would like to refresh the steady stream of market information coming in.

Yahoo! Finance offers the capability to download basic stock price information into Excel. For users who have created their own portfolios, in Yahoo! Finance there is a link or "Download" function to save the information into an Excel workbook. Data that can currently be downloaded includes current stock prices, the daily high and low prices and daily trading volume.

Additionally, it is possible to download just about any data from the Internet into Excel. In Excel under the "Data" menu, choose to download data from the web or "From Web," which is the specific menu item in Excel. A separate pop-up will open and allow the input of literally any website. Returning to Yahoo! Finance and the "Statistics" portion for Textron Corp, yellow areas show where you can download specific data. Clicking on the download will populate the data into Excel. Below is a screen shot of information that was downloaded.



Below is the specific table that Excel created:

Market Cap (intraday): 7.51B
Enterprise Value (Sep 3, 2012): 10.75B
Trailing P/E (ttm, intraday): 19.2
Forward P/E (fye Dec 31, 2013): 11.42
PEG Ratio (5 yr expected): 0.4
Price/Sales (ttm): 0.61
Price/Book (mrq): 2.36

Enterprise Value/Revenue (ttm): 0.9

Enterprise Value/EBITDA (ttm): 9.29


Guide To Excel For Finance: Ratios

Related Articles
  1. Tech

    Advisor Tools: To ‘Excel’ or Not Excel?

    Microsoft Excel has been a staple of the financial services industry for decades but specialized advisor software solutions have sprung up in recent years.
  2. Trading

    Improve Your Investing With Excel

    Excel is a useful tool to assist with investment organization and evaluation. Find out how to use it.
  3. Investing

    Yahoo! Finance Vs. Google Finance: Which Should You Use?

    Thanks to sites like Yahoo Finance and Google Finance, millions of investors are able to analyze markets on their own.
  4. Insights

    Buyers Want Yahoo Japan, Not Yahoo

    Buyers may be more interested in Yahoo’s Japanese counterpart than the company itself.
  5. Investing

    Yahoo's 3 Key Financial Ratios (YHOO)

    Understand key financial ratios that help explain Yahoo's current revenue and profit situations, as well as its P/E ratio for its potential valuation change.
  6. Investing

    Netflix Adds a Video Download Option to Mobile App

    Do you want to watch your favorite Netflix (NASDAQ: NFLX) show on your tablet or smartphone, but lack a decent internet connection at the moment? No problem. The streaming entertainment giant ...
  7. Investing

    Yahoo! Stock: An Earnings Case Study (YHOO)

    Discover the earnings analysis about Yahoo!, including comments on historical earnings and the breakdown of analysts' past and future earnings estimates.
  8. Investing

    How Yahoo (YHOO) Makes Money (For Now)

    Most of Yahoo’s current business model might sound redundant, but it remains the 5th most popular web site in the world. Here's how it generates revenue.
  9. Investing

    Yahoo Sets April 11 Deadline for Takeout Bids (YHOO)

    It is now clear Yahoo management no longer believes it can operate as a standalone company.
  10. Investing

    Yahoo's Stock: Only 8% Return in 10 Years (YHOO)

    Now that Yahoo's core business is being sold to Verizon, a look back at the drivers of its stock price history over the last ten years.
Frequently Asked Questions
  1. What is the difference between yield and return?

    While both terms are often used to describe the performance of an investment, yield and return are not one and the same ...
  2. What are the Differences Among a Real Estate Agent, a broker and a Realtor?

    Learn how agents, realtors, and brokers are often considered the same, but in reality, these real estate positions have different ...
  3. What is the difference between amortization and depreciation?

    Because very few assets last forever, one of the main principles of accrual accounting requires that an asset's cost be proportionally ...
  4. Which is better, a fixed or variable rate loan?

    A variable interest rate loan is a loan in which the interest rate charged on the outstanding balance varies as market interest ...
Trading Center