Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel
  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

Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel

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

  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
RELATED TERMS
  1. Trailing Twelve Months - TTM

    The timeframe of the past 12 months used for reporting financial ...
  2. Big Data

    The growth in the volume of structured and unstructured data, ...
  3. Beta Alpha Psi

    An honorary organization for financial information students and ...
  4. Enterprise Multiple

    A ratio used to determine the value of a company. The enterprise ...
  5. Last Twelve Months - LTM

    A period of time commonly used to evaluate financial results ...
  6. Enterprise Value (EV)

    A measure of a company's value, often used as an alternative ...
RELATED FAQS
  1. How do I perform a financial analysis using Excel?

    Find out how to perform financial analysis through Microsoft Excel, which is probably the most widely used software among ... Read Answer >>
  2. Why is the TTM (trailing twelve months) important in finance?

    Learn about trailing 12 month financial data, and find out how TTM controls seasonality for equity research, financial planning ... Read Answer >>
  3. How can you calculate your cash budget in Excel?

    Using Excel to track income and spending, estimate the effects of lifestyle changes, and present the information in ways ... Read Answer >>
  4. Why would you use the TTM (trailing twelve months) rather than the data from the ...

    Learn why investors use trailing 12 months rather than the numbers from the last annual report. Learn what cannot be calculated ... Read Answer >>
  5. Is there an easy way to do financial forecasting in Excel?

    Find out how to use Excel to conduct financial forecasting. Learn how to build a complex financial model, and discover functions ... Read Answer >>
  6. How can I calculate the hurdle rate in Excel?

    Learn how to evaluate potential investments. Common desktop software provides functions that can help make the decision with ... Read Answer >>

You May Also Like

Hot Definitions
  1. Cost Of Debt

    The effective rate that a company pays on its current debt. This can be measured in either before- or after-tax returns; ...
  2. Yield Curve

    A line that plots the interest rates, at a set point in time, of bonds having equal credit quality, but differing maturity ...
  3. Stop-Limit Order

    An order placed with a broker that combines the features of stop order with those of a limit order. A stop-limit order will ...
  4. Keynesian Economics

    An economic theory of total spending in the economy and its effects on output and inflation. Keynesian economics was developed ...
  5. Society for Worldwide Interbank Financial Telecommunications ...

    A member-owned cooperative that provides safe and secure financial transactions for its members. Established in 1973, the ...
  6. Generally Accepted Accounting Principles - GAAP

    The common set of accounting principles, standards and procedures that companies use to compile their financial statements. ...
Trading Center