W
Wafa
Bismillah
Hi everyone, I have a little problem here with excel, I hope i can
find someone to help with it.
Now let us say that we have a portfolio that deals with more than on
broker, buying selling and so on, at the end of day we receive 2 or 3
reports from these brokers, and we discover that we used more cash than
we deposited in the stock market, how can we create a formula for the
following:
B/S Balance Wanted cash
(63,000.000) (63,000.000) (63,000.000)
12,600.000 (50,400.000) (63,000.000)
(40,000.000) (90,400.000) (90,400.000)
10,000.000 (80,400.000) (90,400.000)
12,000.000 (68,400.000) (90,400.000)
(80,000.000) (148,400.000) (148,400.000)
Now the day started short with 63,000 if there is more buying it will
accumulate but the moment we sell the wanted cash will be fixed, but if
we start buying again and the balance is more than the wanted cash as
seen then the wanted cash will be same as balance (90,400.000), and so
on and it will be fixed in the wanted cash and it will not change if
there is a selling like in the balance.
I used a formula which gave me the lowest amount in the balance which
is the wanted cash but this formula will fix the lowest amount from
cell one to the end. is there a way to fix the amount and add to it if
the balance is higher than wanted cash.
The formula i used was =MIN($F$7:$F$400) I want the result to appear
as in column 3
Help anyone
Thankyou in advance
Hi everyone, I have a little problem here with excel, I hope i can
find someone to help with it.
Now let us say that we have a portfolio that deals with more than on
broker, buying selling and so on, at the end of day we receive 2 or 3
reports from these brokers, and we discover that we used more cash than
we deposited in the stock market, how can we create a formula for the
following:
B/S Balance Wanted cash
(63,000.000) (63,000.000) (63,000.000)
12,600.000 (50,400.000) (63,000.000)
(40,000.000) (90,400.000) (90,400.000)
10,000.000 (80,400.000) (90,400.000)
12,000.000 (68,400.000) (90,400.000)
(80,000.000) (148,400.000) (148,400.000)
Now the day started short with 63,000 if there is more buying it will
accumulate but the moment we sell the wanted cash will be fixed, but if
we start buying again and the balance is more than the wanted cash as
seen then the wanted cash will be same as balance (90,400.000), and so
on and it will be fixed in the wanted cash and it will not change if
there is a selling like in the balance.
I used a formula which gave me the lowest amount in the balance which
is the wanted cash but this formula will fix the lowest amount from
cell one to the end. is there a way to fix the amount and add to it if
the balance is higher than wanted cash.
The formula i used was =MIN($F$7:$F$400) I want the result to appear
as in column 3
Help anyone
Thankyou in advance