MY PORTFOLIO version: 2014.

1
You need to enter only about your transactions & get your portfolio value in real time
Compitability:
Ø  Excel 2003 or higher Version
Ø  Internet Connection

Features:
Ø  This sheet gets updated automatically in every 2 minutes to give realtime position

Ø  If your stock is todays gainer Current price will automatically become green otherwise red

Ø  Set target to sell or watch, Cell become green & fonts bold & red when it reaches
Ø  It will calculate your shares profit/ loss & your portfolios. Even its shows netoff brokerage
Profit or Loss if you put brokerage % applicable to you.

Ø  It shows you your Investment as on date, your just needed to fill Ledger column in your sheet

Ø  Its also calculate BEP of any share purchased when you put brokerage % applicable to you.

Ø  Its also calculate every shares monthly return %

For any Query you can contact at [email protected]

Blog: commerceclub.in
GO
 By CA Prasenjit Paul

MY PORTFOLIOversion: 2014.1 By CA Prasenjit Paul ([email protected]) 9/6/2021 Instruction

Purchase Qty Current Select the stock name From Drop
Name Pur Dt Target Profit/Loss Brokerag Actual P/L Ret % Investment Current Value BEP Ret % PM Down List, Put your Purchase
Price Price e
Price, Qty, Date of Purchase & the
Castrol India 300.50 15 5/2/2011 410.80 400.00 1654.50 46.95 1607.55 36.71% 4,507.50 6,162.00 303.17 0.29% brokerage % applicable to you in
ABB India 1000.00 7 6/5/2012 1085.55 1,200.00 598.85 64.23 534.62 8.56% 7,000.00 7,598.85 1,008.88 0.00% their columns. Maintain your
ledger of fund in next sheet
Dish TV India Ltd. 65.00 100 6/6/2013 58.90 75.00 (610.00) 54.52 (664.52) -9.38% 6,500.00 5,890.00 65.58 0.00%
Balrampur Chini 70.00 150 1/4/2014 56.05 80.00 (2092.50) 83.19 (2175.69) -19.93% 10,500.00 8,407.50 70.62 -0.01%
Infosys 3000.00 20 5/5/2014 4166.60 3,300.00 23332.00 630.66 22701.34 38.89% 60,000.00 83,332.00 3,026.63 0.01%
20 Microns Ltd. 30.65 0.00 0.00 0.00 #DIV/0! - - - #DIV/0! Brokerage% 0.44%
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0! Portfolio Value
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0! Hold 111,390.35
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0! Cash 100.00
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0! Total 111,490.35
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0! Investment 89,515.00
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0! Profit/ Loss 21,975.35
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0! Ret % 24.55%
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0! - - - #DIV/0!
Total 292 22882.85 879.55 22003.30 25.85% 88,507.50 111,390.35

For any Query you can contact at [email protected]

Blog: commerceclub.in
 Ledger Of Funds
Date Particulars of fund Amount Deposited Amount Withdrawn
4/1/2014 Fund Transfer 20000.00
4/2/2014 Fund Transfer 1000.00
4/3/2014 Fund Transfer 10000.00
4/4/2014 Fund Transfer 10000.00
4/5/2014 Fund Transfer 13200.00
4/6/2014 Fund Transfer 7500.00
4/7/2014 Fund Transfer 4500.00
Back
4/8/2014 Fund Transfer 7700.00
4/9/2014 Fund Transfer 7250.00
4/10/2014 Fund withdrawn 12300.00
4/11/2014 Dividend received 20.00
4/12/2014 Fund Transfer 4500.00
4/13/2014 Fund Transfer 2850.00
4/14/2014 Fund Transfer 3100.00
4/15/2014 Fund Transfer 7310.00
4/16/2014 Fund Transfer 75.00
4/17/2014 Fund Transfer 3000.00
Total 101910.00 12395.00
Balance 89515.00
Cash with Broker 100.00
Back