Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Question on rounded numbers in calculations

General questions about using Fund Manager that do not fit into any other forum.

Postby Djobydjoba » Sun Jan 28, 2018 3:47 am

Hi Mark,

To be sure, can you confirm that with the command Create Investment from Investments prices are not calculated with rounded numbers? For example, if a price 0,000006 is displayed (rounded because it comes from another "Create Investment from Investments" command), much more decimals are handled internally, and for the following calculations too? ("floating point numbers" at any steps?)

Thanks.
Djobydjoba
 
Posts: 711
Joined: Tue Mar 09, 2010 9:39 am

Postby Djobydjoba » Sun Jan 28, 2018 7:25 am

Another question: is it possible to export (Excel...) prices not rounded? The prices with copy/paste are rounded (as displayed in the Data Register dialog).

Thxs.
Djobydjoba
 
Posts: 711
Joined: Tue Mar 09, 2010 9:39 am

Postby Mark » Sun Jan 28, 2018 11:13 am

Hi Djobydjoba,

There is no rounding done to the prices during "Create Investment from Investments...". Prices are stored as double precision floating point numbers. This means you have about 15 total places of precision, including the whole number portion. So, if you have a number like 1000, you will have 11 places to the right of the decimal that is stored accurately, since you have 4 places used by the whole number portion. Calculations like yields would use this full resolution, but if you're calculating something like market value, it will use the whole number, but round to the nearest 0.01 when displaying.

Sorry, no, there isn't a way to export more than 6 digits to the right of the decimal. It is stored internally to more than this, but FM limits the display to 6 maximum.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Djobydjoba » Sun Jan 28, 2018 11:48 am

Thanks for these details.
Djobydjoba
 
Posts: 711
Joined: Tue Mar 09, 2010 9:39 am


Return to General

Who is online

Users browsing this forum: Google [Bot] and 17 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.