financial

Calculate Age of Debt in SQL Server

I have three tables: Charges Payments Adjustments Each has a value, called Amount. There are no allocations done on this data, we are assuming the oldest Payments are paying the oldest Charges or Adjustments. Each Amount could be +ve or -ve. I need to produce a report which shows the age of the debt, based on the current balance bein...

Equivolume financial chart in Matlab

Can't find anywhere a Matlab code to plot Equivolume bars, does anybody knows how to? http://www.armsinsider.com/education/armsonthemarket/equiv_chart.asp Thanks, Alberto ...

How should I model these simple financial transactions?

I feel like I hit a wall trying to structure what I thought would be a simple database schema for modeling basic financial transactions. I'm hoping some of you with more experience can weigh in and point me in the right direction. My application has four distinctly different types of leases that customers can purchase. As such, each typ...

Rounding Standards - Financial Calculations

I am curious about the existence of any "rounding" standards" when it comes to the calculation of financial data. My initial thoughts are to perform rounding only when the data is being presented to the user (presentation layer). If "rounded" data is then used for further calculations, should be use the "rounded" figure or the "raw" fig...

OFX -- Second Level Security?

We're working on a site that will make use of the OFX standard to provide access to customer financial data. However, for security we make use of secret question/secret answer, machine tagging, etc. Does the OFX standard provide any mechanisms for security beyond just the simple username/password? I've taken a look at the schema and s...

Financial Market Data for commercial site

Hello, I have to get the following information but from an online api or service. Now before anyone mentions yahoo finance I can't go down that road as this has to be on the up and up. I know google doesn't care about commercial or non-commercial but they don't have all this info. I also looked into YQL however that just uses finance....