India Broadband Forum


Excel Sheet to track portfolio

This is a discussion on Excel Sheet to track portfolio within the Investment and Finance forums, part of the General offtopic discussions category; Thos who wih to track their portfolio manually, I am herewith attaching a spreadsheet that I use. I am also ...

Go Back   India Broadband Forum > General > General offtopic discussions > Investment and Finance

India Broadband Forum


                      

Reply

 

LinkBack Thread Tools Display Modes
Old 06-05-09, 12:55 PM   #1
Platinum Member
 
just4kix's Avatar
 
Join Date: Dec 2007
Location: Pune
Posts: 8,899
Blog Entries: 6
Rep Power: 19
just4kix is a splendid one to beholdjust4kix is a splendid one to beholdjust4kix is a splendid one to beholdjust4kix is a splendid one to beholdjust4kix is a splendid one to beholdjust4kix is a splendid one to beholdjust4kix is a splendid one to beholdjust4kix is a splendid one to behold
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
File Type: zip Portfolio Tracker.zip (11.3 KB, 91 views)
__________________
*** Never argue with an idiot ***


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

-------------------------------------------------------------------------------------------
just4kix is offline   Reply With Quote
Old 06-10-09, 04:17 AM   #2
Junior Member
 
fms007's Avatar
 
Join Date: Jun 2009
Posts: 63
Rep Power: 1
fms007 is on a distinguished road
Default

Hi
Downloaded the file, worthwhile for manual config of data....personally use moneycontrol like yourself...repped u for the effort.
fms007 is offline   Reply With Quote
Old 06-10-09, 08:48 AM   #3
Junior Member
 
Join Date: Jan 2009
Location: Mysore,Karnataka
Posts: 81
Rep Power: 1
pshrinivasan is on a distinguished road
Default

Thank you
pshrinivasan is offline   Reply With Quote
Old 06-10-09, 09:43 AM   #4
kirankumargb
Guest
 
Posts: n/a
Default

Nice kix, thats really good.
  Reply With Quote
Old 06-10-09, 08:37 PM   #5
Dragon
Guest
 
Posts: n/a
Default

I am unable to extract excel file from zip

This is what I am getting:

untitled.bmp

2.bmp

Excel file Screenshot

exl.bmp
  Reply With Quote
Old 06-11-09, 10:04 AM   #6
Junior Member
 
fms007's Avatar
 
Join Date: Jun 2009
Posts: 63
Rep Power: 1
fms007 is on a distinguished road
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
fms007 is offline   Reply With Quote
Old 09-23-09, 03:46 PM   #7
Junior Member
 
Join Date: Sep 2009
Posts: 1
Rep Power: 0
becool is on a distinguished road
Red face Excel Sheet to track portfolio

Hi,

Pls let me know how to use this excel to extract real time stock value?
becool is offline   Reply With Quote
Old 09-23-09, 09:36 PM   #8
Platinum Member
 
just4kix's Avatar
 
Join Date: Dec 2007
Location: Pune
Posts: 8,899
Blog Entries: 6
Rep Power: 19
just4kix is a splendid one to beholdjust4kix is a splendid one to beholdjust4kix is a splendid one to beholdjust4kix is a splendid one to beholdjust4kix is a splendid one to beholdjust4kix is a splendid one to beholdjust4kix is a splendid one to beholdjust4kix is a splendid one to behold
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.
just4kix is offline   Reply With Quote
Reply

Tags
excel, portfolio, sheet, track

Thread Tools
Display Modes

Posting Rules
You may post new threads
You may 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 On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Choose your track meetdilip General offtopic discussions 11 05-14-09 06:29 PM
Try Netmeter to track down your net usage xwhyz BSNL broadband 16 04-24-09 07:34 PM
track a device behind a ADSL CPE veer_raj BSNL broadband 7 03-31-09 01:28 AM
is it possible to track which website i visited on what date and on what tim tomas BSNL broadband 3 05-14-08 12:56 PM
Jodha Akbar (2 Min Edited Track) nansurabhi Bollywood movies 0 12-30-07 01:32 PM


All times are GMT +5.5. The time now is 07:02 AM.


India Broadband Forum