1. #1
    Guardian Angel
    just4kix's Avatar
    Join Date
    Dec 2007
    Posts
    11,625

    Default Excel Sheet to track portfolio

    Thos who wih to track their portfolio manually, I am herewith attaching a spreadsheet that I use. I am also using moneycontrol.com to do the job, but money control gives latest figures only.

    To keep track of history, I use my spreadsheet. Some of you may find it useful (it is Excel 2007/xlsx format).

    If you do find it useful or bullshit, comments will most useful. And repo's too.
    Attached Files Attached Files

  2. #2
    Junior Member
    fms007's Avatar
    Join Date
    Jun 2009
    Posts
    63

    Default

    Hi
    Downloaded the file, worthwhile for manual config of data....personally use moneycontrol like yourself...repped u for the effort.

  3. #3
    Bronze Member

    Join Date
    Jan 2009
    Posts
    186

    Default

    Thank you

  4. #4
    kirankumargb
    Guest

    Default

    Nice kix, thats really good.

  5. #5
    Dragon
    Guest

    Default

    I am unable to extract excel file from zip

    This is what I am getting:



    Excel file Screenshot
    Last edited by Admin; 11th December 2009 at 08:07 AM.

  6. #6
    Junior Member
    fms007's Avatar
    Join Date
    Jun 2009
    Posts
    63

    Default

    Possible Solutions (i m sure you must have done it):
    (1.)Try downloading the zip file again....could be the download is corrupt....but before downloading the zip...delete the previous one.
    (2.)If it still doesnt open...than check your winrar program....its an evaluation copy...try to get a registered copy....Winrar 3.71 Corporate Edition or some registered copy of Winrar. Uninstall the previous one and than install the new one.
    (3.)Also if you are not using MS Office 2007....meaning if you are using MS office 2003 you will need a compatibility pack which you can get from MS
    Link:
    http://www.microsoft.com/downloads/d...displaylang=en

    Hope this helps

  7. #7
    Junior Member

    Join Date
    Sep 2009
    Posts
    1

    Red face Excel Sheet to track portfolio

    Hi,

    Pls let me know how to use this excel to extract real time stock value?

  8. #8
    Guardian Angel
    just4kix's Avatar
    Join Date
    Dec 2007
    Posts
    11,625

    Default

    This Excel is used to track historical prices. Everything has to be manually entered. Otherwise I would be creating an application to complete with those from the likes of Moneycontrol, Sharekhan, etc.

Similar Threads

  1. The universal spec sheet/price list idea!!
    By The Sorcerer in forum Suggestions and Complaints
    Replies: 4
    Last Post: 31st October 2010, 02:24 AM
  2. CBI files charge sheet on SajjanKumar
    By meetdilip in forum News discussions
    Replies: 0
    Last Post: 13th January 2010, 08:58 PM
  3. Creating a Portfolio!
    By krish_174 in forum Investment and Finance
    Replies: 4
    Last Post: 29th August 2009, 08:35 AM
  4. Excel Art - Brilliant
    By saurav_k in forum General offtopic discussions
    Replies: 5
    Last Post: 2nd May 2009, 09:32 PM
  5. Add overs in Excel
    By krishnakrkc in forum Computer hardware and software tips and tricks
    Replies: 0
    Last Post: 25th November 2008, 07:57 AM

Posting Permissions

Log in

Log in
BSNL Broadband Forum Airtel Broadband Forum Reliance Broadband Forum Tikona Broadband Forum MTNL Broadband Forum Tata Broadband Forum
BSNL 3G Forum MTNL 3G Forum Idea 3G Forum Airtel 3G Forum Reliance 3G Forum Vodafone 3G Forum
Airtel Mobile Forum Reliance Mobile Forum BSNL Mobile Forum Idea Mobile Forum Vodafone Mobile Forum Aircel Mobile Forum
Tata Sky Forum Dish TV Forum Reliance DTH Forum Videocon DTH Forum Airtel DTH Forum SUN DTH Forum