Excel Sheet to track portfolio

Discussion in 'Investment and Finance' started by just4kix, Jun 5, 2009.

  1. just4kix

    just4kix Guardian Angel Staff Member

    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:

  2. fms007

    fms007 New Member

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

    pshrinivasan Member

  4. kirankumargb

    kirankumargb Guest

    Nice kix, thats really good.
  5. Dragon

    Dragon Guest

    I am unable to extract excel file from zip:confused:

    This is what I am getting:

    Excel file Screenshot
    Last edited by a moderator: Dec 11, 2009
  6. fms007

    fms007 New Member

    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

    Hope this helps
  7. becool

    becool New Member


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

    just4kix Guardian Angel Staff Member

    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. krish_174

Share This Page