Skip to Content
Online Investing Hacks
book

Online Investing Hacks

by Bonnie Biafore
June 2004
Beginner
504 pages
15h 36m
English
O'Reilly Media, Inc.
Content preview from Online Investing Hacks

The Best Data for Free

Data that helps you evaluate investments doesn’t have to cost an arm and a leg—or anything at all for that matter.

SEC filings, such as the 10-K and 10-Q forms, provide data as reported by the company. Without any value-added manipulation [Hack #15] and [Hack #20] , you have to judge for yourself whether data truly reflects a company’s performance. Many web sites provide information suitable for your initial research and qualitative evaluations. In addition, you can use Excel web queries [Hack #7] to extract data directly from web pages into a spreadsheet for processing and ratio analysis. The only time free data falls short is when you want to feed an investment analysis program [Hack #38] and [Hack #53] that runs on your computer. These programs require data in a specific format, and it’s just too much trouble to format free data to fit their specifications.

When you want to put financial ratios (see Chapter 4) to the test, you need data from financial statements—and lots of it. For almost effortless downloads of financial statement data, there’s only one free alternative: EdgarScan [Hack #18] .

Many web sites provide easy access to SEC filings, such as the 10-K and 10-Q reports. In most cases, you can view the filings on the screen or download them as Adobe PDF, HTML, or rich text format files. If the web site uses HTML tables to display the SEC filing, you can use Excel web queries to extract the data to a spreadsheet. The best web sites in this ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Start a Business for £99

Start a Business for £99

Emma Jones
What Successful Project Managers Do

What Successful Project Managers Do

W. Scott Cameron, Jeffrey S. Russell, Edward J. Hoffman, Alexander Laufer

Publisher Resources

ISBN: 0596006772Errata Page