(Msg. 1) Posted: Thu Mar 27, 2008 5:50 pm
Post subject: Template Archived from groups: microsoft>public>excel>templates (more info?)
Can anyone help me with my equity data.
I trade in stock exchange & at the day end it is very tire some to calculate
profit & loss.
If anybody can help me to design a template will be very helpful.
The column will design like:
On Buying Side it will have
PurchaseDate Name Of Equity Quantity PurchaseRate Amount
AveragePurchaseRate
On Selling side it will have
SellingDate Name Of Equity Quantity SellingRate Amount
AverageSellingRate
On reporting it should mention
01) Total Purchase by Name Of Equity, Quantity, Average Rate, Amount
02) Total Sell by Name Of Equity, Quantity, Average Rate, Amount
03) Balance by Name Of Equity, Quantity, Average Rate, Amount, Today's Rate,
Today's Amount
(Msg. 2) Posted: Tue May 06, 2008 2:27 am
Post subject: Re: Template [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Use pivot table to do this report.
If you dont know pivot, learn it. It can do your report in 1 min.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office