Thread: 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.

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

Thank you

Nice kix, thats really good.

I am unable to extract excel file from zip

This is what I am getting:



Excel file Screenshot

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

Hi,

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

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.