Excel Spreadsheet

EquityStock -ProfitLoss Calc.

You must be logged in to download this document
Description

This file will help in keeping track of all your equity investments. This file is made by me. I have put lot of thought process and though I dont know much about EXCEL but managed to make a pretty decent file.

Reviews
Shared by: Rajesh Sivapalan
Stats
views:
600
rating:
not rated
reviews:
0
posted:
2/8/2008
language:
English
pages:
0
EQUITY DATE 10-Oct-07 10-Oct-07 10-Oct-07 17-Oct-07 17-Oct-07 19-Oct-07 23-Oct-07 24-Oct-07 25-Oct-07 26-Oct-07 STOCK RELPET BSES KSOIL TCS PRAIN RELPET RELPET BSES KSOIL KSOIL BUY QTY. 154 19 125 5 19 46 COST PRICE TOTAL BUY BROKERAGE COST INCL. TAX 172 1603 76.3 1101.95 205 173 26488 30457 9537.5 5509.75 3895 7958 0 0 256.32 294.73 92.29 53.32 37.69 77.01 0.00 0.00 FINAL BUY COST 26744.32 30751.73 9629.79 5563.07 3932.69 8035.01 0.00 0.00 83845.25 Stock Name RELPET BSES KSOIL TCS PRAIN TOTAL BUY TOTAL SELL 34779.33 27451.75 30751.73 30613.85 9629.79 2792.71 5563.07 0.00 3932.69 0.00 84656.6205 60858.31932 PROFIT / LOSS -7327.58 -137.88 -6837.08 -5563.07 -3932.69 -23798.3012 Current Stock Name KSOIL HINCON Remain QTY.Avg. cost 90 14 50 199.73 Total of Avg. Current Price 4500 2796.22 70 190 Total 6300 2660 **Manual Addition is shown in blue color SELL QTY SEL PRICE TOTAL SEL COST 0 0 0 0 0 0 27720 30913 2000 820 58633 BROKERAGE FINAL SELL INCL. TAX PRICE 0.00 0.00 0.00 0.00 0.00 0.00 268.25 299.15 19.35 7.94 0.00 0.00 0.00 0.00 0.00 0.00 27451.75 30613.85 1980.65 812.06 154 19 25 10 180 1627 80 82 BROKERAGE 60.9651 25.74082 PROFIT / LOSS 1739.03 (161.96) 1577.07

Shared by: Rajesh Sivapalan
About
I am a Senior Web and graphic Designer working for a Indian company in India , Pune city. I work on GUI, icon designing, logo designing and htmls coding. I can design websites for you, prepare brochures, any print design as pe (More...)
Other docs by Rajesh Sivapal...
Some Indian and other website link names
Views: 1911  |  Downloads: 80