Stock Forum

Discuss value investing stock ideas

 You must be logged in to post
Search Forums:


 






Wildcard Usage:
*    matches any number of characters
%    matches exactly one character

Home Report Errors #VALUE! Error on Graham Intrinsic Value Tab

#VALUE! Error on Graham Intrinsic Value Tab
Page:   1  
No Tags
UserPost

1:32 pm
December 15, 2009


Jae Jun

Admin

posts 1336
5

Make sure you only enter the ticker in the summary tab and then Press F9 after you enter a new ticker to refresh.

For the growth %, if the yellow box has a number it will always override the calculation so make sure you use the Clear button to delete any user numbers.

Always press F9 afterwards.

1:20 pm
December 15, 2009


norrike

Member

posts 4
4

Hi Jae Jun

The formula correction worked OK yesterday, but today the sheet does not recalculate the "Per Share Value" in C29, "Purchase Price" in C31 and the "Normal Earnings" in C21 for new stock symbols.  The results are frozen at the last calculation from yesterday.  I checked to see if selecting unfreeze on the Window tab would help, but is still does not calculate.  Some other cells ubdate OK, such as stock name, symbol and stock price. 

However, another question, is the "Growth" value in C6 - is it updating properly?  It always selects the defalt value of 10% from C4 on the DCF Valuation and Graham Intrinsic Value work sheets.  The is regardless of whether value in K17 on the Graham worksheet or K48 on the DCF Valuation worksheet is zero or any percent greater.

Thanks  …   Kelly

12:55 pm
December 14, 2009


norrike

Member

posts 4
3

Thanks Jae Jun that fixed it error.

12:27 pm
December 14, 2009


Jae Jun

Admin

posts 1336
2

Yea sorry about that. Seems like you downloaded the spreadsheet when I accidently redid that error.

In C29, enter the following "=(C21*(7+1.5*C6*100)*4.4)/C23"

11:11 am
December 14, 2009


norrike

Member

posts 4
1

Hi Jae Jun

1.What version of excel I am using = 2003

2.Which spreadsheet I am using = 05yr_OSV_Stock_Valuation

3.The exact FULL path of the add-in you unzipped the files to = C:SMF

4.Screenshots of the directory containing the add in - N/A

5.What step of the install guide is not working – install worked OK 

6.Whether you have checked out the SMF add in Yahoo group – No

The 5yr OSV Stock Valuatiion Spreadsheet displays #ERROR! in cells E6, F6, G6, C29, C31, and C33.  It appears the error is in the cell formula of C29, "=(C16*(7+1.5*C1*100)*4.4)/C18", C16 is a Year Date Range and C1 is a blank cell.  There are no errors on the 10yr OSV Stock Valuation Spreadsheet.  Is C29 the error?  If so, how can I correct it?

Regards  …  Kelly
No Tags
Page:   1  


About the Stock Valuation Software forum

Most Users Ever Online: 147

Currently Online:
14 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 4
Forums: 40
Topics: 695
Posts: 3686

Membership:

There are 869 Members
There have been 8 Guests

There is 1 Admin
There are 3 Moderators

Top Posters:

somrh – 275
Graeme – 126
zehua – 96
valueinvestortoday – 75
nell – 67
krackerjack121 – 67

Recent New Members: kalidas, NathanB21, jademan10, romans122, vincentbston, mrpenguin

Administrators: Jae Jun (1336 Posts)

Moderators: Jae Jun (1336 Posts), VANYA (1 Post), djsun (0 Posts)