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

Values 100 times of using Swedish version

UserPost

6:42 pm
December 27, 2009


Jae Jun

Admin

posts 1333

3

Glad you figured it out.

Number settings in windows has to be set to US dollars.

7:04 am
December 27, 2009


bjoel

Member

posts 3

2

I seemed to solve this myself, by going into the Windows control panel and changing the regional settings (in Swedish: "Nationella inställningar") to use the dot as the decimal separator and the comma as the thousand separator.

Now I'm a happy camper.  :)

6:49 am
December 27, 2009


bjoel

Member

posts 3

1

Hi!

Just purchased and downloaded the spreadsheet.

  1. What version of excel you are using = Microsoft Office 2007, Swedish version
  2. Which spreadsheet you are using = 05yr_OSV_Stock_Valuation_v6.1.0.xls
  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
  5. What step of the install guide is not working
  6. Whether you have checked out the SMF add in Yahoo group = searched but did not find anything relevant

The basic installation seems to work fine, but all numbers seem off by a factor 100.  For instance, when looking at figures for Microsoft MSFT on the Summary page, I get a market cap of 27 525 000 and a 52 week high of 3100,00.  Graphs and numbers all over seems off by this factor too

I guess this has something to do with different decimal separators (comma is used in swedish excel) but I do now know enough excel to tell how to fix this.  Any hints?

/Björn



About the Stock Valuation Software forum

Most Users Ever Online: 147

Currently Online:
15 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 4
Forums: 40
Topics: 693
Posts: 3674

Membership:

There are 868 Members
There have been 8 Guests

There is 1 Admin
There are 3 Moderators

Top Posters:

somrh – 271
Graeme – 120
zehua – 96
valueinvestortoday – 75
nell – 67
krackerjack121 – 67

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

Administrators: Jae Jun (1333 Posts)

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