# Errata for Online Investing Hacks

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date Submitted Date Corrected
Printed
Page 20
Item #1

The Quicken full search screening tool at the listed URL is no longer active. A search found that Quicken now sends you to the Yahoo screener. Also the Quicken screener listed separate in the Hack are now going to the Yahoo screener. (must be tough to write a web book and keep up to date!)

Note from the Author or Editor:
This is confirmed, and this has been a rpoblem since a few months after publication.

Anonymous
Printed
Page 39
Example 2-3 and Example 2-4

Example 2-3: Current Price = VLOOKUP("Last Trade:",'Price Query'!\$A:\$B,2,) NOW READS: Current Price = VLOOKUP("Last Trade:",'Price Query'!\$A:\$B,2,FALSE) and Example 2-4: Price Range = VLOOKUP("52wk Range:",'Price Query'!\$A:\$B,2,) NOW READS: Price Range = VLOOKUP("52wk Range:",'Price Query'!\$A:\$B,2,)

Anonymous    Dec 01, 2004
Printed
Page 50
Example 2-19

{=EXP(LINEST(IF(Earnings>0,LN(Earnings),0) IF(Earnings>0,Years,0)))-1} NOW READS: {=EXP(LINEST(IF(Earnings>0,LN(Earnings),0),IF(Earnings>0,Years,0)))-1} [Comma was missing in equation after first "0)" before the second "IF"] (colophon) 7th paragraph, second sentence; "This book was converted Julie Hawks ..." NOW READS: "This book was converted by Julie Hawks ..."

Anonymous    Dec 01, 2004
Printed
Page 119-120
Equation in middle of page

The correct equation is (g7/b7)^(1/5)- 1 and results in a growth rate of 19.2%, close to the Logest result of 19.7%.

Anonymous
Printed
Page 174
under the heading Getting the Earnings Data You Need, fourth sentence:

"EPS is more meaningful than total earnings, because EPS can go up and down if a company issues more share... share should be shares

Anonymous  May 19, 2009
Printed
Page 465
the bottom of figure 9-12

For the row labeled "Investor B", the numbers in colums "Year 4", "Year 5", and "This year" are in the wrong order. It should be "\$3,325" for "Year 4", "\$3,355" for "Year 5", and "\$3,190" for "This year". Also, the "\$3.355" should be "\$3,355".

Anonymous