Bank interest rate calculation

[arishy]

I need some general help in approaching this problem.
Let say the bank gives you 11.25 % on your saving account. The problem is your saving account balance VARIES during the physical month, so the rule is the bank apply the interest on the MINIMUM balance during the month.

For example ( taken from my bank statement)
The BOLD is the interest calculated on the min. balance

DB CR Blc

31/01/2017 31/01/2017 0 4.5 484.5
28/02/2017 28/02/2017 0 4.54 489.04

06/03/2017 06/03/2017 0 27000.00 27489.04
06/03/2017 06/03/2017 27000 0 489.04
07/03/2017 07/03/2017 40 0 449.04
29/03/2017 29/03/2017 0 2900 3349.04
30/03/2017 30/03/2017 15 0 3334.04
30/03/2017 30/03/2017 20 0 3314.04
30/03/2017 31/03/2017 0 4.2 3318.24

30/04/2017 01/05/2017 0 31.11 3349.35

31/05/2017 01/06/2017 0 31.4 3380.75

What I need to do is to run a macro on the csv file after importing it to excel
and extract the interest LINES after checking them for correct value.

 

[Marc L]

What is the link here for any VBA code, the purpose of this section ?​

 

[arishy]

The problem cannot be solved by formulas.....( in my view ), so VBA is the solution.
After all, it IS a programming language....So, I need an approach to the problem that can be implemented using VBA. Remember I asked for general help may be when I do some code I will come back with coding problem. And I believe that what you were expecting !!!

 

[Marc L]

As it seemed just about calculation so formula may be the key !

Yes any general help can't be a technical help …

Now after your edit, explain at least how to detect what you expect for
as we can't help when we have to guess …
​