+612 9045 4394
Online Investing Hacks : Hacks - Bonnie Biafore

Online Investing Hacks


Paperback Published: 9th July 2004
ISBN: 9780596006778
Number Of Pages: 504

Share This Book:


RRP $39.95
Ships in 15 business days

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).

Creditsp. ix
Prefacep. xiii
Screening Investmentsp. 1
Screen Savings Ratesp. 2
Screen Fixed-Income Investmentsp. 7
Screen Loan and Mortgage Ratesp. 11
Fast and Free Stock Screening Toolsp. 17
Build Industrial Strength-Stock Screensp. 21
Weed Out Resultsp. 29
Hacking Excel for Financial Analysisp. 32
Download Data Using Excel Web Queriesp. 33
Make Good and Bad Values Stand Outp. 40
Make Nested Functions Work in Excelp. 43
Prevent Growth Calculations from Blowing Upp. 48
Flexible Techniques for Referencing Datap. 52
Add Conditional Commentaryp. 59
Create Financial Charts in Excelp. 61
Collecting Financial Datap. 68
Introduction: Fathoming Financial Statementsp. 68
Download Mutual Fund Datap. 75
Choose Your Favorite Flavor of Datap. 79
Obtain Price Quotesp. 81
Download Historical Price Filesp. 84
Download Financial Statementsp. 86
The Best Data for Freep. 89
The Best Data for a Feep. 91
Download Newsp. 92
Locate the Competitionp. 96
Obtain Averages for an Industry and the Competitionp. 99
Create Alertsp. 106
Analyzing Company Fundamentalsp. 111
Introduction: Investing in Growthp. 111
Introduction: Insisting on Qualityp. 115
Introduction: Buying Good Valuep. 115
Calculate Percentage Change for Growth and Returnp. 116
Calculate Compound Annual Rates of Growthp. 117
Calculate Price and Dividend Ratiosp. 122
Calculate Additional Valuation Ratiosp. 130
Calculate Financial Strength Ratiosp. 138
Calculate Management Effectiveness Ratiosp. 144
Calculate Turnover Ratiosp. 151
Calculate Profitability Ratiosp. 157
Compare Year-to-Year Resultsp. 164
Compare Several Competitors to Identify the Strongest Candidatep. 170
Measure Earnings Predictability in Excelp. 174
Use Rational Values to Buy and Sell Wiselyp. 180
Are You Walking on the Wild Side?p. 187
Use Ready-Made Fundamental Analysis Applicationsp. 198
Spot Hanky Panky with Cash Flow Analysisp. 203
Use Online Analysis Toolsp. 208
Find the Best Free Excel Tools for Fundamental Analysisp. 215
Find the Best Excel Tools for Fundamental Analysis for a Feep. 218
Analyze Real Estate Investment Trustsp. 219
Bank on Banksp. 224
Steps to Building a Financial Analysis Templatep. 230
Technical Analysisp. 235
Introduction: A Short History of Technical Analysisp. 236
Introduction: Computers and Technical Analysisp. 237
Introduction: Technical Chartsp. 237
Introduction: The Importance of Money Managementp. 238
Use Line and Bar Chartsp. 240
Light the Way with Candlestick Chartsp. 244
Point and Figure Chartsp. 246
Look for Patterns in Technical Chartsp. 250
What's Volume Got to Do with It?p. 256
How to Use Indicators and Oscillatorsp. 258
Support and Resistancep. 265
The Best Tools for Technical Analysisp. 267
Executing Tradesp. 270
Pick the Right Type of Tradep. 271
Execute After-Hours Tradesp. 276
Sell Fractional Sharesp. 279
Build Your Own Mutual Fundsp. 280
Buy Bonds Onlinep. 282
Investing in Mutual Fundsp. 284
Introduction: Mutual Funds Are Here to Stayp. 285
Introduction: It's Your Moneyp. 286
Introduction: Index Funds, Anyone?p. 286
Why Don't My Funds Perform as Well as Others?p. 287
Calculate the Damage of Mutual Fund Expensesp. 292
Analyze the Hidden Costs of Fund Turnoverp. 298
The Taxman Cometh for Your Fund Returnsp. 302
Evaluate Short-Term and Long-Term Returnsp. 307
Manage Interest Rate Risk with Bond Fund Durationp. 312
Evaluate Mutual Fundsp. 316
The Best Mutual Fund Screens for Freep. 319
The Best Mutual Fund Screens for a Feep. 323
Beware of the Closet Index Fundp. 326
Spot Mutual Funds That Don't Play Fairp. 331
Know When to Fold 'Emp. 335
Comparison-Shop for Mutual Fundsp. 340
Compare Mutual Funds Onlinep. 344
Managing Your Portfoliop. 347
Introduction: What Is Portfolio Management?p. 347
Introduction: Tracking Resultsp. 349
Build an Online Portfoliop. 351
Asset Allocation: Less Risk on the Road to Returnsp. 354
Keep Allocation in Linep. 360
The Best Portfolio Management Tools for Freep. 363
The Best Portfolio Management Tools for a Feep. 367
Portfolio Management with Excelp. 370
Take the Sting Out of Portfolio Managementp. 373
Use Bonds in a Portfoliop. 380
Calculate Investment Return Over Different Time Periodsp. 383
Compare Your Return to a Benchmarkp. 386
Forecast Future Returnsp. 391
Compare Returns for Alternative Investmentsp. 394
Assess Portfolio Qualityp. 398
Flag Fundamental Sell Signalsp. 402
Financial Planningp. 405
Choose the Right Type of Accountp. 406
Choose an Online Brokerp. 410
Pick the Best Broker for Your Trading Stylep. 415
Save Up for Something Goodp. 419
Up, Up, and Away: The Cost of Collegep. 424
Let Me Count the Ways to Save for Collegep. 430
A College Savings Plan in Every Statep. 433
Balance Risk and Return for College Costsp. 437
When It's Time to Break the College Savings Piggy Bankp. 443
Save for Retirement While Still Enjoying Yourselfp. 446
Juggle Multiple Objectivesp. 451
Get Out of Debt Before Debt Takes It Out of Youp. 454
Find a Financial Plannerp. 457
Build a Ladder of Fixed-Income Investmentsp. 463
Indexp. 467
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780596006778
ISBN-10: 0596006772
Series: Hacks
Audience: General
Format: Paperback
Language: English
Number Of Pages: 504
Published: 9th July 2004
Publisher: John Wiley & Sons Publishers
Country of Publication: US
Dimensions (cm): 22.8 x 15.8  x 2.5
Weight (kg): 0.69