Online calculation of the interest payment as banks do, help

 Field Remark Savings deposits / withdrawals (Max. 1000) Enter on each line a value date followed by a delimiter and than a savings deposit / withdrawal. Max 1000 rows allowed. The rows are automatically sorted by date. If a line begins with a # symbol, then the entire line is considered a comment. The value date is the date on which a withdrawn amount ceases to earn interest or a deposited amount start to earn interest. The value date is not the same as the posting date. The posting date is the date on which deposits on the account is credited and withdrawals debited from the account. Allowed value date formats: dd-mm-yyyy (24-11-2013) or dd/mm/yyyy (24/11/2013) mm-dd-yyyy (11-24-2013) or mm/dd/yyyy (11/24/2013) If the day or month has only 1 digit, then you do not need to prefix the number with a 0. Allowed: 24-01-2013 or 24-1-2013 Allowed: 1-12-2013 or 01-12-2013 The date of the first savings deposit / withdrawal should start earlier than the final date. A delimiter. Allowed delimiters: ; [tab] | ~ = ^ _ A savings deposit / withdrawal Max 2 digits after decimal point (17.05) A comma (,) or point (.) may be used as decimal point (1125,01 or 1125.01) If it is a savings deposit, do not prefix the amount with the + sign (+235.12) If it is a savings withdrawal, prefix the amount with the - sign (-2342.25) Do not use a currency symbol (\$2342.25) On 1 day several savings deposits / withdrawals can take place. Put each on a separate line, eg: 24-01-2013;100.24 24-01-2013;200.25 24-01-2013;-10.00 Correct examples: #24-03-2013; 10000 24-03-2013; 10000 24/03/2013; 10000 24-3-2013; 10000 1-3-2013; 10000 03-24-2013; 10000 03/24/2013; 10000 28-03-2013; -500 28-03-2013; 500.56 28-03-2013; 500,56 Incorrect examples: 2013-03-23; 10000 -> Date has incorrect format (yyyy-mm-dd) 35-03-2013; 10000 -> Date does not exists 24-03-2013; 10,000.56 -> No thousand separator allowed 24-03-2013; 10000,561 -> Max 2 digits after decimal point 24-03-2013; +500 -> No + sign allowed 24-03-2013; \$500 -> No currecy symbol allowed