Mental Block please help

[Mcgrco]

I havent been using Access for 3 weeks now and Ive been given a task to do by the end of today. I cant see the wood from the trees here. Can anyone give me some pointers.

Here is a sample of data from my table. What I need in field NewTotal example .for 001 would show (1,990,763,192)-(892,395)+ (3,598) (Move on three days each time).

002 would show NewTotal for .001-411,714,195 +(1,729,080,236)(Move on three days each time).

And on and on.

Can anyone give me a few pointers as to where to get started. I just can visualise how to do this. Much apprciated


Daycount SumOfTotal£ NewTotal
0.00 (892,395)
0.01 (1,990,763,192)
0.02 411,714,195
0.03 0
0.04 (3,598)
0.05 (1,729,080,236)

 

[pdx_man]

Sorry, need more info. I don't understand 'move on three days each time'
What is 1,990,763,192)-(892,395)+ (3,598) ?
I don't understand where you are at and where you need to go.

 

[Mcgrco]

Sorry,

I realise its a bit hard to understand. It is basically a liquidity forecast. The database works out our firms liquidity (Cashflows and projected cashflows) and show them as a percentage of our deposit's. This daily calculation shows us our liquidity up to two days (if we liquiditate all out asset and liabilities on any particular day can we still run our business) and then from two days to eights days. What the forecast should do is work out the difference between each days new assets and liabilities.

0.00 is todays net total so to work out the change tomorrow (forecast) we would need to take .01 and subtract .00. 00 has now passed (in the forecast so we to add in a new day (move three days).

Day 1 range is from

.01 to .04 NewTotal = (1,990,763,192) - (892,395) + (3,598)

Next day Forecast

.02 to .05 NewTotal = (411,714,195 ) - (1,990,763,192) + (1,729,080,236)


Daycount SumOfTotal£ NewTotal
0.00 (892,395)
0.01 (1,990,763,192)
0.02 411,714,195
0.03 0
0.04 (3,598)
0.05 (1,729,080,236)
I hope this hasn't confused you even more. Any suggestion would really appreciated

 

[pdx_man]

Sorry, I am still confused (and I work in the financial industry ...). Can you address this issue more abstractly? Saying that 'today is .00 and tomorrow is .01 so we need to take .01 and subtract .00', just doesn't make sense to me. What are your inputs?

Deposits
Withdrawl
Outstanding liability
???

Are these input daily then you need to forcast out X number of days where .0X represents the day?

So we have:

(OutStand_Lia + Deposits - Withdrawl) * .0X

 

[Mcgrco]

00 represents demand : ie the sum of all our cash inflows and cash outflows that are due for settlement today. FSA or SEC as they are known in the states also require us to check out liquiquidity in the following time bands.

Demand .00
8 Days and under
I month and under


So this is where the movement comes in:

To forecast 8 Days and under from tomorrow we will obviously loose demand and day nine will become day 8. 8 Days and under - Demand .00 + take the next day just outside 8 Days and under .
Does that help.

Your patience is appreciated

 

[Mcgrco]

00 represents demand : ie the sum of all our cash inflows and cash outflows that are due for settlement today. FSA or SEC as they are known in the states also require us to check out liquidity in the following time bands.

Demand .00
8 Days and under
I month and under


So this is where the movement comes in:

To forecast 8 Days and under from tomorrow we will obviously loose demand and day nine will become day 8. 8 Days and under - Demand .00 + take the next day just outside 8 Days and under .
Does that help.

Your patience is appreciated

 

[pdx_man]

Boy, sorry, I am just not getting it. If you could write some psuedo-code to illustrate the business rules, that would help. Use variables instead of real values. Tell us where those variables are populated.