Traderji.com - Discussion forum for Stocks Commodities & Forex

Portfolio Management & Tracking through MS Excel

Discuss Portfolio Management & Tracking through MS Excel at the Software within the Traderji.com - Discussion forum for Stocks Commodities & Forex; For every trade or investment done, it is suggested that one must have plan and ...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > TOOLS & RESOURCES > Software

Notices

Software Charting, trading & technical analysis software, trading system development and backtesting.


Advertise Here

Reply
 
Thread Tools
Sponsored Links
  #1  
Old 30th August 2005, 07:37 PM
Member
 
Join Date: Feb 2005
Posts: 547
Appreciation: 22
nkpanjiyar is on a distinguished road
Default Portfolio Management & Tracking through MS Excel

For every trade or investment done, it is suggested that one must have plan and tracking mechanism for portfolio.

Portfolio management and tracking gives lot of insight for doing future trading and investment. It provide valuable lessons provided one is ready to learn.

Based on my experience and reading I had designed a simple "Portfolio Tracker" in MS Excel. I am using it for more than a year. It has helped me a lot.

I am herewith attaching the "Portfolio Tracker" in MS Excel with some of my real time trades done. Hope someone may benefit from this. Constructive as well as destructive criticisms are most welcome.

cheers,
nkpanjiyar
Attached Files
File Type: zip Portfolio Management.zip (5.4 KB, 1036 views)
Reply With Quote
  #2  
Old 30th August 2005, 10:10 PM
Member
 
Join Date: Aug 2005
Location: Mumbai
Posts: 1
Appreciation: 20
drshoeb is on a distinguished road
Default Re: Portfolio Management & Tracking through MS Excel

Thanks nkpanjiyar, looks good at first look.
Reply With Quote
  #3  
Old 31st August 2005, 02:51 AM
Member
 
Join Date: Aug 2005
Posts: 6
Appreciation: 20
mayureshpote is on a distinguished road
Default Re: Portfolio Management & Tracking through MS Excel

Thanks buddy
Reply With Quote
  #4  
Old 31st August 2005, 08:07 AM
Member
 
Join Date: Aug 2005
Posts: 272
Appreciation: 20
ragh_ash is on a distinguished road
Default Re: Portfolio Management & Tracking through MS Excel

Quote:
Originally Posted by nkpanjiyar
For every trade or investment done, it is suggested that one must have plan and tracking mechanism for portfolio.

Portfolio management and tracking gives lot of insight for doing future trading and investment. It provide valuable lessons provided one is ready to learn.

Based on my experience and reading I had designed a simple "Portfolio Tracker" in MS Excel. I am using it for more than a year. It has helped me a lot.

I am herewith attaching the "Portfolio Tracker" in MS Excel with some of my real time trades done. Hope someone may benefit from this. Constructive as well as destructive criticisms are most welcome.

cheers,
nkpanjiyar
hi nk,
i am new to trading. so pl tell me whether this is just for intra day trading.
also how do i retieve some quotes.
regards
ragh_ash
Reply With Quote
  #5  
Old 31st August 2005, 08:13 AM
Member
 
Join Date: Aug 2005
Posts: 309
Appreciation: 20
VICKY_SEEKINGINR is on a distinguished road
Default Re: Portfolio Management & Tracking through MS Excel

Its Looking Nice Man..

Vicky
Reply With Quote
  #6  
Old 31st August 2005, 10:48 AM
Member
 
Join Date: Mar 2005
Posts: 8
Appreciation: 20
bceianonline is on a distinguished road
Default Re: Portfolio Management & Tracking through MS Excel

Quote:
Originally Posted by nkpanjiyar
For every trade or investment done, it is suggested that one must have plan and tracking mechanism for portfolio.

Portfolio management and tracking gives lot of insight for doing future trading and investment. It provide valuable lessons provided one is ready to learn.

Based on my experience and reading I had designed a simple "Portfolio Tracker" in MS Excel. I am using it for more than a year. It has helped me a lot.

I am herewith attaching the "Portfolio Tracker" in MS Excel with some of my real time trades done. Hope someone may benefit from this. Constructive as well as destructive criticisms are most welcome.

cheers,
nkpanjiyar
Its really wonderful. I was looking for such comprehensive portfolio management in simple terms. Thanks buddy. Great and kind work.
Reply With Quote
  #7  
Old 31st August 2005, 11:09 AM
Member
 
Join Date: Feb 2005
Posts: 547
Appreciation: 22
nkpanjiyar is on a distinguished road
Default Re: Portfolio Management & Tracking through MS Excel

Thanks drshoeb, mayureshpote, VICKY_SEEKINGINR for your kind words.

cheers,
nkpanjiyar
Reply With Quote
  #8  
Old 31st August 2005, 11:14 AM
Member
 
Join Date: Feb 2005
Posts: 547
Appreciation: 22
nkpanjiyar is on a distinguished road
Default Re: Portfolio Management & Tracking through MS Excel

Quote:
Originally Posted by ragh_ash
hi nk,
i am new to trading. so pl tell me whether this is just for intra day trading.
also how do i retieve some quotes.
regards
ragh_ash
Dear ragh_ash,

The attached "Portfolio Tracker" is not meant for intra day trading as of today. But it can be incorporated if required. Primarily I designed it see my investment patterns, returns generated and identifying mistakes.

cheers,
nkpanjiyar
Reply With Quote
  #9  
Old 31st August 2005, 05:03 PM
Member
 
Join Date: Aug 2005
Posts: 81
Appreciation: 20
xtiger is on a distinguished road
Default Re: Portfolio Management & Tracking through MS Excel

Hmm...... useful for beginners like me. thanks boss...
Reply With Quote
  #10  
Old 31st August 2005, 06:16 PM
Member
 
Join Date: Jul 2005
Location: mumbai
Posts: 20
Appreciation: 20
pr_shetty is on a distinguished road
Default Re: Portfolio Management & Tracking through MS Excel

hi nk,

good format would help a lot of people.

VinodP
Reply With Quote
Sponsored Links


Reply

Bookmarks


Advertise Here


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads for: Portfolio Management & Tracking through MS Excel
Thread Thread Starter Forum Replies Last Post
Portfolio Management Software ash927 Software 9 10th July 2008 05:22 PM
What is money management CreditViolet Risk & Money Management 64 6th July 2008 07:06 PM
Put Options to protect your stock portfolio Mohan Options 10 23rd June 2008 03:16 PM
Money Management nkpanjiyar Equities 6 16th July 2007 01:48 AM
Need advise on portfolio management rags Equities 3 18th June 2005 06:48 PM


All times are GMT +5.5. The time now is 03:56 AM.

Indemnity, Disclaimer & Disclosure Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum Rules Disclaimer & Disclosure and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum.
Disclaimer: Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of this information.
Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
• All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy of information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. If you find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
 


Copyright © 2001 - 2008, Traderji.com All Rights Reserved.

Recommended Websites - www.TradersEdgeIndia.com - www.TradingPicks.com - www.MasterOfTrading.com