B

#### barbarebop

although i have had excel on my laptop for years this is the first

time i have ventured to use it. i am trying to do a stock /share

portfolio, so i can tell at a glance my positions, so far the layout

as follows:-

a6 buy/sell, input b6 amount buy,input

c6 amount sell,input

d6 name stock/share,input

e6 epic code,input

f6 buy date,input

g6 sell date,input

h6 purchase price per share,(bid)input

i6 sell price per share,input

j6 sub total [=h6*b6],calc

k6 buy commission £,input

l6 sell commission £,input

m6 stamp duty tax,=((h6/100)*b6)*/0.5 ,calc

n6 total cost =j6+k6+m6 ,calc

o6 current price per share,input

p6 current value, =06*b6 ,calc

q6 sold profit/loss, =if(a6="sell"(c6*o6)-l6) ,calc

r6 sold profit/loss%, =(q6/n6)-100% ,calc

s6 dividend from share,input

t6 dividend date,input

u6 total profit/loss including dividend, =q6+s6 ,calc

all the complicated (to me)formulas are what's been used from other

spreadsheets found elsewhere, i am trying to get a formula for

subtracting, for instance if after buying 400 shares in b6, sold 200

in c6 then i imagine the formula should go something like

=if(a6="sell",(b6-c6), but that does not work for some reason.can

anyone help please. on a not too important point,is it possible to

have the live date and time displayed in a selected cell? and is

anyone aware of portfolio template with more than the basic features

that i can look at to compare with this one?

thanks in advance for any help