Question on rounded numbers in calculations

[Djobydjoba]

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]

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.

[Mark]

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.

[Djobydjoba]

Thanks for these details.