If this is not the right answer, what CAN we use for exact division in financial calculation? (I mean, I don’t have a finance major, but they still use division, right???). Then I was in primary school1, they taught me that when you divide by 1 by 3 you get a 0.33333… i.e. a recurring … Read more
I think you’ll find all you need to know by looking at this question: source of historical stock data I don’t know of any free data feeds other than Yahoo!, but it doesn’t offer tick-by-tick data, it only offers 1 minute intervals with a 15 minute delay. If you want to use an already existing … Read more
Martin Fowler considers money as a special case of “Quantity”, secondly he thinks the right Data Type for money should be the Big Integer. And he does have a point. Quantity and Money Pattern by Martin Fowler
The first and most important rule: use a decimal data type, never ever binary floating-point types. When exactly rounding should be performed can be mandated by regulations, such as the conversion between the Euro and national currencies it replaced. If there are no such rules, I’d do all calculations with high precision, and round only … Read more