Online Investing Hacks. 100 Industrial-Strength Tips & Tools - Helion

ebook

Autor: Bonnie Biafore
ISBN: 978-14-493-9097-6
stron: 506, Format: ebook
Data wydania: 2004-06-17
Księgarnia: Helion

Cena książki: 72,24 zł (poprzednio: 84,99 zł)
Oszczędzasz: 15% (-12,75 zł)

Osoby, które kupiły tę książkę, wybierały także »

For the geek who's an investor, and the investor who's a geek, we present Online Investing Hacks, 100 industrial-strength, bleeding edge tips, tools and techniques for analyzing and managing online portfolios.Individual investors have become more computer-literate and technology-dependent than ever before. Whether you're looking for suitable investments, studying alternatives, or managing your portfolios, you need data. The Internet can be a goldmine of financial data and research, but today's online investors also use spreadsheets, databases, and financial applications to select, study and manage investments. If your proficiency has grown to the point where you crave industrial-strength tips and tools to turbo-charge your efforts, this is the book for you.Online Investing Hacks covers:

Screening Investments
Collecting Data
Fundamental Analysis
Technical Analysis
Executing Trades
Investing in Mutual Funds
Portfolio Management
Updating Stock Data
Financial Planning

Other books for managing online investing are either out of date, are for beginners and don't go beyond the most basic advice, or are so dull and boring they squeeze that last bit of fun out of the topic. Online Investing Hacks is for the customer who wants to know the latest techniques, to go beyond the basics, who gets jazzed by cool online tools and services, and who actually wants to have a bit of fun while trying to strike it rich (or at least not lose their shirt).

Osoby które kupowały "Online Investing Hacks. 100 Industrial-Strength Tips & Tools", wybierały także:

Windows Media Center. Domowe centrum rozrywki 66,67 zł, (8,00 zł -88%)
Ruby on Rails. Ćwiczenia 18,75 zł, (3,00 zł -84%)
DevOps w praktyce. Kurs video. Jenkins, Ansible, Terraform i Docker 190,00 zł, (39,90 zł -79%)
Przywództwo w świecie VUCA. Jak być skutecznym liderem w niepewnym środowisku 58,64 zł, (12,90 zł -78%)
Scrum. O zwinnym zarządzaniu projektami. Wydanie II rozszerzone 58,64 zł, (12,90 zł -78%)

Spis treści

Online Investing Hacks. 100 Industrial-Strength Tips & Tools eBook -- spis treści

Online Investing Hacks
- SPECIAL OFFER: Upgrade this ebook with OReilly
- A Note Regarding Supplemental Files
- Credits
  - About the Author
  - Contributors
  - Acknowledgments
- Preface
  - Why Online Investing Hacks?
  - How to Use This Book
  - How This Book Is Organized
  - Conventions
  - How to Contact Us
  - Got a Hack?
- 1. Screening Investments
  - Hacks #1-6
  - Hack #1. Screen Savings Rates
    - See Also
  - Hack #2. Screen Fixed-Income Investments
    - Consider Bond Variables Before Screening
    - Screening Bonds
    - See Also
  - Hack #3. Screen Loan and Mortgage Rates
    - Unraveling Mortgage Costs
    - Screening Mortgages
    - HSH Calculators
  - Hack #4. Fast and Free Stock Screening Tools
    - The Best of the Bunch
    - Using Quicken.coms Full Search Screening Tool
  - Hack #5. Build Industrial Strength-Stock Screens
    - Using the MSN Money Deluxe Screener
  - Hack #6. Weed Out Results
    - Tinkering with Results in a Spreadsheet
      - Sorting
      - Filtering
- 2. Hacking Excel for Financial Analysis
  - Hacks #7-13
  - Hack #7. Download Data Using Excel Web Queries
    - Creating an Excel Web Query
    - Making a Web Query Work for Any Ticker Symbol
    - Hacking the Hack
  - Hack #8. Make Good and Bad Values Stand Out
    - Applying Conditional Formatting
    - Hacking the Hack
  - Hack #9. Make Nested Functions Work in Excel
    - Using Named Cells
    - Creating Stubs
    - Creating Excel Subroutines
    - Hacking the Hack
  - Hack #10. Prevent Growth Calculations from Blowing Up
    - Calculating Growth Between Start and End Dates
    - Protecting Regression Calculations
    - Calculating R-Squared Without Mishap
  - Hack #11. Flexible Techniques for Referencing Data
    - Searching Labels in a Column
    - Searching Labels in a Row
    - Retrieving Values When Rows and Columns Change
    - Retrieving Data Near a Label
  - Hack #12. Add Conditional Commentary
  - Hack #13. Create Financial Charts in Excel
    - Using the Excel Chart Wizard
    - Getting Charts Right
    - Matching Charts to Objectives
- 3. Collecting Financial Data
  - Hacks #14-24
  - Fathoming Financial Statements
    - The Income Statement
    - The Balance Sheet
    - The Statement of Cash Flow
  - Hack #14. Download Mutual Fund Data
    - Picking the Data Behind Door Number One or Door Number Two
    - Building a Mutual Fund Data Workbook
  - Hack #15. Choose Your Favorite Flavor of Data
    - Types of Financial Data
    - Choosing a Data Source
  - Hack #16. Obtain Price Quotes
  - Hack #17. Download Historical Price Files
  - Hack #18. Download Financial Statements
    - Financial Statements from EdgarScan
  - Hack #19. The Best Data for Free
  - Hack #20. The Best Data for a Fee
  - Hack #21. Download News
    - News Delivery
    - The Best Free News Services
    - News for a Fee
    - See Also
  - Hack #22. Locate the Competition
  - Hack #23. Obtain Averages for an Industry and the Competition
    - Calculate Competitors Averages Using Stock Screen Results
    - Hacking the Hack
  - Hack #24. Create Alerts
    - Free Alert Services
    - Alerts for a Fee
- 4. Analyzing Company Fundamentals
  - Hacks #25-45
  - Investing in Growth
    - Starting with Simple Percentages
    - The Value of Compounded Growth
  - Insisting on Quality
  - Buying Good Value
  - Hack #25. Calculate Percentage Change for Growth and Return
    - Taking Dividends and Commissions into Account
  - Hack #26. Calculate Compound Annual Rates of Growth
    - Estimating Compounded Annual Growth Rates
    - Calculating Growth with the LOGEST Function
    - Hacking the Hack
    - See Also
  - Hack #27. Calculate Price and Dividend Ratios
    - Dividend and Yield
    - The Payout Ratio
    - Going Beyond the P/E Ratio
    - Viewing Price and Dividend Ratios and Trends
      - Historical price and dividend charts
      - Comparing historical price ratios
      - Comparing ratios to the competition
  - Hack #28. Calculate Additional Valuation Ratios
    - P/E to Growth Ratio
    - Price/Book Value Ratio
    - Price/Sales Ratio
    - Price/Cash Flow Ratio
    - Hacking the Hack
    - See Also
  - Hack #29. Calculate Financial Strength Ratios
    - Current Ratio
    - Quick Ratio
    - Debt-to-Equity Ratio
    - Long-Term Debt-to-Equity Ratio
    - Interest Coverage Ratio
    - See Also
  - Hack #30. Calculate Management Effectiveness Ratios
    - Evaluating Return on Equity
    - Evaluating Return on Assets
  - Hack #31. Calculate Turnover Ratios
    - Asset Turnover Ratio
    - Inventory Turnover Ratio
    - Receivables Turnover Ratio
    - See Also
  - Hack #32. Calculate Profitability Ratios
    - Key Profit Margins
      - Gross margin
      - Operating profit margin
      - Pre-tax profit margin
      - Net profit margin
    - Analyzing Profitability
    - Hacking the Hack
    - See Also
  - Hack #33. Compare Year-to-Year Results
  - Hack #34. Compare Several Competitors to Identify the Strongest Candidate
    - See Also
  - Hack #35. Measure Earnings Predictability in Excel
    - Getting the Earnings Data You Need
    - Understanding the R-Squared Measure
    - Using Excel to Calculate R-Squared
    - Hacking the Hack
  - Hack #36. Use Rational Values to Buy and Sell Wisely
    - The Signature PE
    - The Historical Value Ratio
    - Rational Price and Rational Value
    - Code
  - Hack #37. Are You Walking on the Wild Side?
    - Understanding Risk
    - Risk Measures
    - An Online Tool for Checking Risk Versus Return
      - Evaluating individual investments
      - Evaluating your portfolio
      - Another view of risk
  - Hack #38. Use Ready-Made Fundamental Analysis Applications
    - NAIC Software
      - NAIC Classic
      - Take Stock
      - Investors Toolkit
      - NAIC Stock Analyst
      - Value Line Investment Analyzer
      - Expert Investor
    - See Also
  - Hack #39. Spot Hanky Panky with Cash Flow Analysis
    - Enrons Financial End Run
    - WorldComs Approach to Cooking the Books
  - Hack #40. Use Online Analysis Tools
    - Research Wizards
    - DividendDiscountModel.com
    - Quicken One-Click Scorecards
    - ValuePro.net
    - See Also
  - Hack #41. Find the Best Free Excel Tools for Fundamental Analysis
    - Analyzing Ratios
    - Data Requirements
    - See Also
  - Hack #42. Find the Best Excel Tools for Fundamental Analysis for a Fee
  - Hack #43. Analyze Real Estate Investment Trusts
    - What Is a REIT?
    - REIT Analysis: Something Old, Something New
    - Obtaining REIT Data
    - See Also
  - Hack #44. Bank on Banks
    - Revenue Measures for Banks
    - The Lowdown on Loan Loss
    - Evaluating Bank Profitability
    - Flavors of Data
  - Hack #45. Steps to Building a Financial Analysis Template
    - Asking Questions and Documenting Decisions
      - Qualitative steps
      - Quantitative steps
      - Action items
    - Using a Checklist
- 5. Technical Analysis
  - Hacks #46-53
  - A Short History of Technical Analysis
  - Computers and Technical Analysis
  - Technical Charts
  - The Importance of Money Management
    - See Also
  - Hack #46. Use Line and Bar Charts
    - Line Charts
    - Bar Charts
  - Hack #47. Light the Way with Candlestick Charts
    - See Also
  - Hack #48. Point and Figure Charts
    - See Also
  - Hack #49. Look for Patterns in Technical Charts
    - Recognizing Reversal Patterns
      - Head and shoulders patterns
      - Double top and bottom reversal patterns
    - Recognizing Continuation and Consolidation Patterns
      - Head and shoulders continuation patterns
      - Flags and pennants
    - See Also
  - Hack #50. Whats Volume Got to Do with It?
    - How Volume Confirms Price
    - On-Balance Volume
  - Hack #51. How to Use Indicators and Oscillators
    - An Introduction to Indicators
    - Moving Averages
    - See Also
  - Hack #52. Support and Resistance
  - Hack #53. The Best Tools for Technical Analysis
    - Online Trading Tools
    - Standalone Software Applications
- 6. Executing Trades
  - Hacks #54-58
  - Hack #54. Pick the Right Type of Trade
  - Hack #55. Execute After-Hours Trades
    - Placing an Extended Hours Trade
    - Drawbacks of Extended Hours Trading
    - See Also
  - Hack #56. Sell Fractional Shares
  - Hack #57. Build Your Own Mutual Funds
  - Hack #58. Buy Bonds Online
    - Keep an Eye on Online Bond Trading Fees
    - See Also
- 7. Investing in Mutual Funds
  - Hacks #59-72
  - Mutual Funds Are Here to Stay
  - Its Your Money
  - Index Funds, Anyone?
  - Hack #59. Why Dont My Funds Perform as Well as Others?
    - The Good, the Bad, and the Ugly: How Expenses Impact Returns
    - See Also
  - Hack #60. Calculate the Damage of Mutual Fund Expenses
    - Calculating Mutual Fund Costs and Return
  - Hack #61. Analyze the Hidden Costs of Fund Turnover
    - The Direct Costs of Turnover
    - Neutralizing Turnover
    - See Also
  - Hack #62. The Taxman Cometh for Your Fund Returns
    - Tax Avoidance Strategies
  - Hack #63. Evaluate Short-Term and Long-Term Returns
    - Hacking the Hack
    - See Also
  - Hack #64. Manage Interest Rate Risk with Bond Fund Duration
    - Bonds Versus Bond Funds
    - Using Duration to Evaluate Risk
    - Where to Find Duration Information Online
  - Hack #65. Evaluate Mutual Funds
    - The Index Advantage
    - Management, Cost, and Turnover
    - Past Performance
    - Tools for Evaluating Mutual Funds
  - Hack #66. The Best Mutual Fund Screens for Free
    - Sifting Through Fund Criteria
  - Hack #67. The Best Mutual Fund Screens for a Fee
    - What You Pay For
  - Hack #68. Beware of the Closet Index Fund
    - Using Data to Spot an Index-Hugger
  - Hack #69. Spot Mutual Funds That Dont Play Fair
    - Staying Current
    - What You Can Do
  - Hack #70. Know When to Fold Em
    - When Funds Go Bad
    - When to Sell
  - Hack #71. Comparison-Shop for Mutual Funds
    - The Mutual Fund Checklist
    - Hacking the Hack
  - Hack #72. Compare Mutual Funds Online
    - Fund Comparisons for a Fee
    - Fund Comparisons for Free
- 8. Managing Your Portfolio
  - Hacks #73-86
  - What Is Portfolio Management?
  - Tracking Results
  - Hack #73. Build an Online Portfolio
  - Hack #74. Asset Allocation: Less Risk on the Road to Returns
    - Determining Your Risk Tolerance
    - Managing Risk
    - Asset Allocation Saves the Day
    - Online Tools for Asset Allocation
    - Dont Put All Your Eggs in One Basket
    - See Also
  - Hack #75. Keep Allocation in Line
    - How Often Should I Rebalance?
    - Rebalancing Strategies
    - Tools to Help Rebalance Your Portfolio
  - Hack #76. The Best Portfolio Management Tools for Free
  - Hack #77. The Best Portfolio Management Tools for a Fee
  - Hack #78. Portfolio Management with Excel
  - Hack #79. Take the Sting Out of Portfolio Management
    - Playing Defense
    - Playing Offense to Increase Returns and Reduce Risk
  - Hack #80. Use Bonds in a Portfolio
    - Understanding Bonds
    - Bonds Versus Bond Funds
    - Putting Bonds to Work
  - Hack #81. Calculate Investment Return Over Different Time Periods
    - Using Internal Rate of Return to Calculate Performance
  - Hack #82. Compare Your Return to a Benchmark
    - Comparing Returns Based Only on Initial Investment
    - Comparing Returns Using Cash Flows
    - See Also
  - Hack #83. Forecast Future Returns
  - Hack #84. Compare Returns for Alternative Investments
    - Comparing One-Time Investments
    - Decision Making with Risk
    - Comparing Investments with Multiple Cash Flows
  - Hack #85. Assess Portfolio Quality
    - How to Recognize Quality
    - Measuring Quality
    - Using Quality Measures
  - Hack #86. Flag Fundamental Sell Signals
- 9. Financial Planning
  - Hacks #87-100
  - Hack #87. Choose the Right Type of Account
    - Types of Savings Accounts
    - Types of Investment Accounts
    - Tax-Advantaged Accounts
  - Hack #88. Choose an Online Broker
    - A Rundown on Online Brokerage Features
    - Find Your Perfect Broker
  - Hack #89. Pick the Best Broker for Your Trading Style
    - Estimating Commissions
    - Choosing the Best Deal
  - Hack #90. Save Up for Something Good
    - Choosing the Right Investment
    - Calculating the Time Value of Money
      - How much will you have if you invest a lump sum today?
      - How much will you have if you invest some money each month?
      - How much do you have to invest each month to reach your target?
  - Hack #91. Up, Up, and Away: The Cost of College
    - The Actual Costs
    - See Also
  - Hack #92. Let Me Count the Ways to Save for College
    - See Also
  - Hack #93. A College Savings Plan in Every State
    - See Also
  - Hack #94. Balance Risk and Return for College Costs
    - Get a Head Start on College Costs
    - The Middle Years
    - Hacking the Hack
  - Hack #95. When Its Time to Break the College Savings Piggy Bank
    - Spending Assets to Qualify for Financial Aid
    - Spending College Savings When Financial Aid Isnt an Issue
    - See Also
  - Hack #96. Save for Retirement While Still Enjoying Yourself
    - Online Retirement Planners
    - What You Need to Know to Plan Your Retirement
    - Analyzing the Results
  - Hack #97. Juggle Multiple Objectives
  - Hack #98. Get Out of Debt Before Debt Takes It Out of You
    - Keeping Debt in Check
    - Bringing Debt Back in Line
  - Hack #99. Find a Financial Planner
    - Different Strokes for Different Folks
    - Finding and Hiring a Planner
  - Hack #100. Build a Ladder of Fixed-Income Investments
    - The Benefits of Fixed-Income Investment Ladders
- Index
- About the Author
- Colophon
- SPECIAL OFFER: Upgrade this ebook with OReilly