Mutual Fund Investment Tracker
I have prepared an excel sheet to track the amount invested in Mutual Funds. Thought it might be useful to some of you :)
This excel sheet directly gets the NAV of selected mutual funds from ValueresearchOnline.com and can be used to calculate Gain/Loss of your ivestments.
Though some sites offer online tracking of Mutual funds, I though it will be good to maintain a personal tracker where we can keep about the purchase/redemption transaction number and other additional information.
It can be downloaded by at Mutual Fund Investment Tracker v1.0
Comments and suggestions are much appreciated.
This excel sheet directly gets the NAV of selected mutual funds from ValueresearchOnline.com and can be used to calculate Gain/Loss of your ivestments.
Though some sites offer online tracking of Mutual funds, I though it will be good to maintain a personal tracker where we can keep about the purchase/redemption transaction number and other additional information.
It can be downloaded by at Mutual Fund Investment Tracker v1.0
Comments and suggestions are much appreciated.
posted by Bala.G at 12:30 PM
25 Comments:
Hey...will download and check....feel that its a good tool man...gr8 :)
Aha...enna idhu..Mutual fund adhu idhunnu :P
Btw, neenga endha TAGum ezhudhalaye...Apram enna Happy? :P Check it...
periya periya vaarthai ellam sollareenga...edho engg economics padichadhala...i mean padichha maadhiri nadichadhala NAV na net asset value nu mattum theriyudhu...adhuvum thappa irukkalaam.... anyways sounds good...naanum dnld pannikkaren...futurela usefulah irukkalaam :))
Bharani,
Check pannitu, suggestions kodunga....
Marutham,
Adellaam apdi thaan..
Happy for scolding me....not for writing
Golmalgopal,
Useful-a irukumna enaku sandhosham....
btb, I dont remember that I studied NAV during my college days :)...
Good info bala! thanks :D
btw, ippa thaan madras to pondy post padichen, chanceee illa, sema comedy! Kudos! :D
g8 work...mutual fund la invest panravangaluku gud info vaa thaan irukanum...namma investment ellam bar la thaan athuku ethavathu tool iruka endha bar la cheap ah kidaikumnu :-)
nalla info bala.. i will try to use this..
Good work.Most of the indian banks have such tools in their websites :)
Hey Bala.. I checked the sheet and found how it is working.. Really it is quiet good. If you find any websites like this to track the individual shares, it will be fine to find its monthly and annual move easily. Thanks for giving the download.. I too will try it out after my investments.
Ambi,
THanks
Syam,
Bar-kum enakum romba dhooram :)
Karthikeyan,
Good.....tell me ur comments to improve it
Gopalan,
Yes I agree..I thought it will be used to check offline :)
Sasiprabha,
Thanks....Innum invest aarambikalaya?
Yenna yethetho post ellam podreeenga ;)
Yenna vishayam :)
Ponnarasi,
U will come to know abt this after a year ma'am :)
Nice blog you have. Am bookmarking it :-) am new to this world.. guess am bit late here!!
Reg. mutual funds, instead of all these, in most of the trading sites, they personalise and give you the sheets. Thats more useful.. try that sometime.
Naanum Syam maathiri than...Syam yethavathu tool kandu pudicha sollunga.... Ippothiku download pannikuren.... Bottle bala kelvi patturuken... neenga Banker bala'va irukeengale :)
enna idhu enavo kandupidipu ellam seiyaringalam? makkal ellam alari adichu vandhu en kitta azharanga.. nyayama idu? :)
good job Bala.. really useful tool.
Janitri,
Welcome here.
I am laready using that from Valueresearchonline.com
KK,
:)
Porkodi,
nyayam illainu solreengala??....yaarum azhara maadhiri enaku thonalaye :)
Kadal ganesan,
Thanx.
Nice One!
The Portfolio Trackers provided by the Web Sites are different from this.
This is really useful.
You have used column N in your formula on individual MF sheets but that was not defined and hence incorrect results in Consolidated work sheet.
Did you extend it to map variation of fund values as is promised by you.
g. Columns C to R and AA to AE are set to Roll
This is really nice.
May i know how it is programmed.
what is the method to get data from web when the sites require user name and password by web querry?
kindly send your suggestions to my e-mail address
rarevalue@gmail.com
Sorry.
I mistakenly placed my comment here which actually refers to some other excel sheet.
You may delete my comments.
Sorry again for the mistake.
Bala.G,
Not sure it works for me.
When I open I get "query refresh" dialog. When I select "Enable Automatic Refresh" (or select Disable Automatic Refresh and later select Query Refresh (!) icon) - the entered data in L24 to O34 vanishes and cells that have formulae have "#N/A" it seems you have used external web query and downloaded the NAVs once from valueresearchonline.com - but these links are failing now. It seems like a good if made to work again.
Great post as for me. I'd like to read more about that matter.
BTW check the design I've made myself Russian escorts
Hello !.
You may , perhaps curious to know how one can make real money .
There is no need to invest much at first. You may start to receive yields with as small sum of money as 20-100 dollars.
AimTrust is what you need
The firm represents an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.
It is based in Panama with structures everywhere: In USA, Canada, Cyprus.
Do you want to become a happy investor?
That`s your chance That`s what you really need!
I`m happy and lucky, I began to get real money with the help of this company,
and I invite you to do the same. It`s all about how to choose a correct companion who uses your funds in a right way - that`s the AimTrust!.
I take now up to 2G every day, and my first investment was 500 dollars only!
It`s easy to join , just click this link http://akalozawu.kogaryu.com/ozofiv.html
and lucky you`re! Let`s take our chance together to get rid of nastiness of the life
Hello !.
You re, I guess , perhaps curious to know how one can collect a huge starting capital .
There is no need to invest much at first. You may begin to get income with as small sum of money as 20-100 dollars.
AimTrust is what you thought of all the time
The company represents an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.
Its head office is in Panama with offices everywhere: In USA, Canada, Cyprus.
Do you want to become a happy investor?
That`s your choice That`s what you really need!
I feel good, I started to take up income with the help of this company,
and I invite you to do the same. If it gets down to select a proper partner utilizes your money in a right way - that`s AimTrust!.
I earn US$2,000 per day, and what I started with was a funny sum of 500 bucks!
It`s easy to start , just click this link http://ynebibyduk.the-best-free-web-hosting.com/qupemuq.html
and go! Let`s take our chance together to feel the smell of real money
Post a Comment
<< Home