Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Excel
123quattro
charting
crashesgpfs
datamap
excel
interopoledde
links
misc
newusers
printing
programming
querydao
sdk
setup
templates
worksheet.functions
  
 
date: Thu, 27 Mar 2008 17:50:18 +0530,    group: microsoft.public.excel.templates        back       


Template   
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
date: Thu, 27 Mar 2008 17:50:18 +0530   author:   Sriradhagovindji

Re: Template   
Use pivot table to do this report.

If you dont know pivot, learn it. It can do your report in 1 min.
date: Tue, 6 May 2008 02:27:33 -0700 (PDT)   author:   Heera

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us