Navigator User Forums
  Investment Transactions
  Can't revalue security to 4 decimal places

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Can't revalue security to 4 decimal places
FN_User
Member
posted 08-19-2004 02:40 PM     Click Here to See the Profile for FN_User     Edit/Delete Message
I have 2,000 shares of stock currently valued at $150.1234. But when I try to enter that
share price in Enter Prices to Update Securities, FN ignores the last digit.
As a result, my FN reports don't match my broker statements.
How do I enter accurate prices?

IP: Logged

fni_support
Moderator
posted 08-19-2004 03:19 PM     Click Here to See the Profile for fni_support     Edit/Delete Message
You are right, FN uses about 6 digits to store prices. For instance, FN can use a price with 4 decimal places if the price is $99.9999 or under. But for a price with 3 digits before the decimal, FN only saves the first 3 digits after the decimal: $150.123.

Since FN uses at most four digits after the decimal, you would also have problems entering a price of $1.123456. FN would record it as $1.2345.

Sometimes it will look like you were able to enter the entire price. So it is important to tab after entering a price with many digits. After you tab you will see the price that FN has saved.

In both cases, the solution is simple:

  1. Enter the price normally, making note of any amount that is dropped. In your example, you would enter $150.123.

  2. Calculate the missing amount. In you example it is 2,000 shares x $0.0004 = $0.80.

  3. Enter a credit transaction in Unrealized Gains and losses for that amount. For instance:
  • CR 12/31/03

  • Payee/Payor: Revalue fractional amount

  • Account: [name of stock's account]

  • Memo: 2,000 sh @ $.0004

  • Credit: .80
The balance on the Asset and Liability Info screen and on balance sheets will now be correct, and you have a good audit trail. The change will show correctly

Investment reports will still show the wrong amount, since they calculate current value as shares x price. You can stop this calculation so that your investment reports match your balance sheet:

  1. Select Investments | Investment and Account Options.

  2. Remove the check mark from Calculate Balances for Investment Accounts.

See the topic "Price per Unit" Rounding for a related discussion about very large prices.

- David
FNI Support

[This message has been edited by David (edited 09-07-2007).]

IP: Logged

All times are PT (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | Home

Copyright 2010 Financial Navigator, Inc.


Ultimate Bulletin Board 5.47e