Value Investing 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 Bug in Excel 2007 Spreadsheet

Bug in Excel 2007 Spreadsheet
Page:   1  
No Tags
UserPost

9:25 am
December 1, 2010


Jae Jun

Admin

posts 1453
2

Thanks for letting me know.

It has been fixed and is ready for next months release.

5:27 am
December 1, 2010


tanhanyen

New Member

posts 2
1

Post edited 4:33 am – December 1, 2010 by tanhanyen

Dear JaeJun,

I think there is a bug in the Dashboard worksheet under Key Statistics. Currently it is as follows:-

Market Cap (millions)     =Competitors!C13

52-Week High     =Competitors!C14

52-Week Low     =Competitors!C15

% off 52-Week Low =Competitors!C16

However, when I compare the competitors, the competitors data is sorted, the Key Statistics is not displayed correctly. I think it should be :-

Market Cap (millions)     =CompData!C5

52-Week High     =CompData!C7

52-Week Low     =CompData!C8

% off 52-Week Low =CompData!C9

I hope this is correct. Please correct me if I overlook something else. Thanks again.

 

Kind regards,

Han Yen
No Tags
Page:   1  


About the Stock Valuation Software forum

Forum Timezone: America/Los_Angeles

Most Users Ever Online: 170

Currently Online:
14 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 4
Forums: 40
Topics: 763
Posts: 4096

Membership:

There are 956 Members
There have been 9 Guests

There is 1 Admin
There are 3 Moderators

Top Posters:

somrh – 336
Graeme – 180
nell – 100
zehua – 96
valueinvestortoday – 80
krackerjack121 – 69

Recent New Members: jman, matias091, foundos, pberardi, JohnnyB, Style

Administrators: Jae Jun (1453 Posts)

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