Average Balance

Friends,

I'm looking a program to generate average balance of all accounts for given start date and end date.

Can any one help me.

Regards,

Pranav.

I had tried from that enquiry but not getting result.

Hi,

In an enquiry , when it calls sub E.ACCT.AVERAGE.BAL it gets back a list ov values that enquiry then splits by 5 parts . Returning string format is :

CR.DAYS>CR.AV.BAL>DR.DAYS>DR.AV.BAL>ZERO.DAYS .

You can see all of them in the following fields.

Now, if you are looking for "REAL" average balance for the period all you need to do is to calculate in your enquiry the following :

ACCOUNT.AV.REAL = (CR.DAYS*CR.AV.BAL + DR.DAYS*DR.AV.BAL)/(CR.DAYS + DR.DAYS + ZERO.DAYS)

Thank you Jpb & Dublin.

Hi Dublin and Jpb,

One more question on same issue.

If we have to extract average balance for closed accounts, what shall we do ?

e.g START.DATE = 2011 Jan 1 END.DATE = 2011 Jul 1

Now, I need average balance of all accounts closed between these two dates.

Pranav.

Hi,

I don't think it does matter is accout closed or not , routine should work anyway .

Hi,

Actually once account is closed, account move to history file and this routine uses only account file not history file.

If it should work, I will try with using account history file by selecting closed accounts records.

Please correct me, If I need to modify any else.

Thanks,

Hi Pranav,

I think you are on the right way, generally ... All u need to do is to build a combined list of "LIVE" and "D..d" , sorry, "CLOSED" accounts. How to do it ? It's your choice ;) Sounds like you need a routine to build a selection list ... And I wouldn't go "ACCOUNT$HIS" way ...

ACCOUNT + ACCOUNT.CLOSED should work better unless there are some surprises ...
You don't need to use NOFILE either.