hi guys
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