Money Excel - Personal Finance Blog

Menu
  • Home
  • Business Ideas
  • Stock Market
  • Mutual Funds
  • Incometax
  • Credit Card
  • Insurance
  • Downloads
Home
Personal Finance
Best Equity Portfolio Manager – Excel based tool

Best Equity Portfolio Manager – Excel based tool

Raviraj Parekh July 5, 2020

equity_portfolio_manager
Stock market investment is like taking ride of “merry go round”, it gives enjoyment of upward stock movement and worry of downward stock movement.

If you have invested your money in stock market it is extremely important for you to monitor your stock performance. Close monitoring will enable you to take appropriate action for buying and selling.

In order to monitor all these stock at single place you need to make your equity portfolio. Equity portfolio enables you to analyses your portfolio and track its movements at any point of time.

In our earlier post we have discussed about ETportfolio tool. Today we will discuss about our own customized Equity portfolio Manager Excel based tool.

Do not miss below posts -
  • How to save more money with limited income? – Practical …
  • How to get Free CIBIL Credit Score Report?
  • Income Tax Slabs FY 2019 | Budget 2019-2020 | Review

Equity Portfolio Manager –

We have made simple and extremely helpful tool to track your stock movements. This tool provides following facility

  • Access to Equity portfolio offline
  • Updating Stock price at single click
  • Updating Sensex and Nifty price movement
  • Total Gain/Loss in particular stock at given point of time
  • Stock Sector Allocation wise pie chart
  • Profit and loss summary pie chart

You can download Equity Portfolio Manager by clicking on link given below.

Download Now

How to use Equity Portfolio Manager-

This Equity portfolio manager contains three different spreadsheets. First spreadsheet named as Instruction contains instruction about how to use this portfolio.

Second sheet is named as Money_Excel contain information about your stock holding, profit and loss details. Third spreadsheet contains information about stock name and respective codes.  Please following steps to use this portfolio.

  • Please find out code of your stock and insert this code in first column A – “Stock”.
  • Input purchase price and stock quantity in column number I – “Purchase price” and J – “Qty”
  • Input Stock sector in column number N – “Sector”

Once you are done Press “Update Now” button and you will see that stock price is getting updated.

Note – In order to update stock price Internet connectivity is mandatory.

This portfolio manager also provide you additional facility in terms of giving visual representation about stock sector allocation percentage. This will enable you to check if you are exceeding investment in specific sector.

stock sector allocation

Another good feature of this portfolio manager is visual representation of profit and loss stock wise summary.

profit loss stock

Hope this portfolio manager will help you to manage your equity investment more effectively.

If you like this tool please share it with your friends and relatives.

Don’t forget to Like, share or tweet it if you like this.

Tweet
Share
Whatsapp
Pinterest
Prev Article
Next Article
Tags:best equity tracker equity portfolio equity portfolio manager equity tracker Portfolio Manager

About The Author

Raviraj Parekh

Raviraj is the man behind moneyexcel.com. He is PGDBA, engaged in blogging for 10 years. Moneyexcel blog is ranked as one of the Top 10 Personal Finance Blog in India. He is not affiliated with any financial product, service provider, agent or broker. The purpose of this blog is to spread financial awareness and help people in achieving excellence for money. Please note that the views expressed on this Blog/Comments are clarifications meant for reference and guidance of the readers to explore further on the topics. These should not be construed as investment advice or legal opinion.

5 Comments

  1. Abhishek

    Hi,

    On clicking the ‘Update Now’ button, I’m getting the following error –
    “The server name or address cannot be resolved”

    Kindly advise.

    April 25, 2014
  2. Raviraj Parekh

    Dear Abhishek,

    Make sure you are connected to Internet. Press Update Now button after connecting to Internet and it will surely work.

    Regards,

    April 25, 2014
  3. Biba

    Very nice one. It will save lot of time..
    Few questions:
    1.Whether there is option to add new rows to Money_Excel tab of the excel sheet? For me, the Insert Option is not coming up.
    2. Are you planning to upgrade this excel to include stock split and dividends to give more clarity on return and avoid manual intervention?

    June 15, 2014
  4. Raviraj Parekh

    Dear Biba,

    Thanks for pointing out very good improvement.

    1. Please download new Equity portfolio tracker and you will be able to insert more rows.
    2. We will make provision for stock split and dividend in our next version.

    Regards,
    Raviraj

    June 16, 2014
  5. Nandagopalan

    While using the equity portfolio manager sheet. I am getting an Error: The Operation Timed out

    i am connected to the internet

    December 17, 2014

Leave a Reply Cancel Reply

Search

Top Posts & Pages

  • Income Tax Calculator FY 2020-21 (AY 2021-22) – Excel Download
  • Rakesh Jhunjhunwala Portfolio Holdings - April 2021
  • Cash Deposit Machine Locator – How to find CDM Near You?
  • 235 Small Business Ideas with Low Investment in 2021-22
  • 20 small manufacturing business ideas with low cost
  • How to check Property Records and Land Records online in India?
  • Download Income Tax Calculator FY 2021-22 (AY 2022-23)
  • 10 Best Small Trading Business Ideas
  • 5 Penny Stocks that become Multibagger in 2021
  • How to Check EPF Balance via SMS EPFOHO

Subscribe to Blog via Email

Join 5,483 other subscribers

Follow MoneyExcel

Money Excel – Personal Finance Blog

Personal Finance Blog
Copyright © 2021 Money Excel - Personal Finance Blog
| About |Downloads | Contact Us | Sitemap | Disclaimer | Privacy Policy |