Sunday, October 01, 2006

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


Blogger Bharani said...

Hey...will download and check....feel that its a good tool man...gr8 :)

Sunday, October 01, 2006 6:10:00 PM  
Blogger Marutham said...

Aha...enna idhu..Mutual fund adhu idhunnu :P

Btw, neenga endha TAGum ezhudhalaye...Apram enna Happy? :P Check it...

Sunday, October 01, 2006 7:35:00 PM  
Blogger golmaalgopal said...

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 :))

Sunday, October 01, 2006 10:06:00 PM  
Blogger Bala.G said...

Check pannitu, suggestions kodunga....

Adellaam apdi thaan..

Happy for scolding me....not for writing

Useful-a irukumna enaku sandhosham....
btb, I dont remember that I studied NAV during my college days :)...

Sunday, October 01, 2006 10:16:00 PM  
Blogger ambi said...

Good info bala! thanks :D

btw, ippa thaan madras to pondy post padichen, chanceee illa, sema comedy! Kudos! :D

Monday, October 02, 2006 3:17:00 AM  
Blogger Syam said...

g8 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 :-)

Monday, October 02, 2006 8:56:00 AM  
Blogger மு.கார்த்திகேயன் said...

nalla info bala.. i will try to use this..

Monday, October 02, 2006 8:47:00 PM  
Blogger Gopalan Ramasubbu said...

Good work.Most of the indian banks have such tools in their websites :)

Monday, October 02, 2006 10:00:00 PM  
Blogger Sasiprabha said...

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.

Tuesday, October 03, 2006 4:34:00 AM  
Blogger Bala.G said...


Bar-kum enakum romba dhooram :)

Good.....tell me ur comments to improve it

Yes I agree..I thought it will be used to check offline :)

Thanks....Innum invest aarambikalaya?

Tuesday, October 03, 2006 10:11:00 PM  
Blogger Ponnarasi Kothandaraman said...

Yenna yethetho post ellam podreeenga ;)
Yenna vishayam :)

Tuesday, October 03, 2006 11:14:00 PM  
Blogger Bala.G said...

U will come to know abt this after a year ma'am :)

Wednesday, October 04, 2006 12:16:00 AM  
Anonymous Janitri said...

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.

Wednesday, October 04, 2006 6:52:00 PM  
Blogger KK said...

Naanum Syam maathiri than...Syam yethavathu tool kandu pudicha sollunga.... Ippothiku download pannikuren.... Bottle bala kelvi patturuken... neenga Banker bala'va irukeengale :)

Thursday, October 05, 2006 11:52:00 AM  
Blogger பொற்கொடி said...

enna idhu enavo kandupidipu ellam seiyaringalam? makkal ellam alari adichu vandhu en kitta azharanga.. nyayama idu? :)

Friday, October 06, 2006 6:21:00 AM  
Blogger கடல்கணேசன் said...

good job Bala.. really useful tool.

Saturday, October 07, 2006 11:01:00 AM  
Blogger Bala.G said...

Welcome here.
I am laready using that from


nyayam illainu solreengala??....yaarum azhara maadhiri enaku thonalaye :)

Kadal ganesan,

Sunday, October 08, 2006 1:44:00 PM  
Blogger prettygood said...

Nice One!
The Portfolio Trackers provided by the Web Sites are different from this.
This is really useful.

Sunday, April 22, 2007 1:23:00 PM  
Blogger prettygood said...

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.

Tuesday, April 24, 2007 4:59:00 PM  
Anonymous Anonymous said...

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

Saturday, May 19, 2007 9:28:00 AM  
Blogger prettygood said...

I mistakenly placed my comment here which actually refers to some other excel sheet.
You may delete my comments.
Sorry again for the mistake.

Sunday, May 20, 2007 9:11:00 AM  
Anonymous invy_ said...

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 - but these links are failing now. It seems like a good if made to work again.

Sunday, November 11, 2007 9:17:00 PM  
Blogger 123 123 said...

Great post as for me. I'd like to read more about that matter.
BTW check the design I've made myself Russian escorts

Wednesday, November 18, 2009 4:36:00 AM  
Anonymous Anonymous said...

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
and lucky you`re! Let`s take our chance together to get rid of nastiness of the life

Monday, December 07, 2009 3:17:00 AM  
Anonymous Anonymous said...

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
and go! Let`s take our chance together to feel the smell of real money

Monday, December 07, 2009 9:08:00 PM  
Anonymous Anonymous said...

You may probably be very interested to know how one can manage to receive high yields on investments.
There is no need to invest much at first.
You may begin earning with a sum that usually goes
for daily food, that's 20-100 dollars.
I have been participating in one project for several years,
and I'm ready to share my secrets at my blog.

Please visit my pages and send me private message to get the info.

P.S. I earn 1000-2000 per daily now.

Wednesday, January 13, 2010 7:48:00 PM  
Blogger kiramatali shah said...

How To Make money with affiliate programs Today. Affiliate marketing is the easier and probably the most effective method to make money from the internet. It is basically, a kind of selling technique where potential buyers from your website are directed to the websites of sellers. For every click, the website owner gets a small commission.

Saturday, January 30, 2010 2:28:00 AM  
Anonymous Anonymous said...

Good day, sun shines!
There have were times of hardship when I didn't know about opportunities of getting high yields on investments. I was a dump and downright pessimistic person.
I have never thought that there weren't any need in large initial investment.
Nowadays, I feel good, I begin take up real money.
It gets down to choose a proper companion who utilizes your funds in a right way - that is incorporate it in real deals, parts and divides the profit with me.

You may ask, if there are such firms? I have to answer the truth, YES, there are. Please get to know about one of them: [url=]Online Investment Blog[/url]

Sunday, January 31, 2010 7:49:00 PM  
Anonymous Anonymous said...

ups sorry delete plz [url=].[/url]

Monday, February 01, 2010 12:33:00 AM  
Anonymous Anonymous said...

I really like when people are expressing their opinion and thought. So I like the way you are writing

Sunday, February 21, 2010 11:01:00 AM  
Anonymous Anonymous said...

dating site [url=]dating hungaria[/url] dating profile speed dating in hull

Saturday, February 27, 2010 3:09:00 PM  
Anonymous Anonymous said...

Good dispatch and this mail helped me alot in my college assignement. Say thank you you for your information.

Saturday, March 13, 2010 8:26:00 PM  
Anonymous Anonymous said...

Glad to greet you, ladies and gentlemen!

Sure, you’ve heard about me, because my fame is running in front of me,
my name is Nikolas.
Generally I’m a venturesome gambler. recently I take a great interest in online-casino and poker.
Not long time ago I started my own blog, where I describe my virtual adventures.
Probably, it will be interesting for you to find out about my progress.
Please visit my diary. I’ll be interested on your opinion..

Tuesday, March 16, 2010 2:40:00 AM  
Anonymous Anonymous said...


I keep coming to this website[url=].[/url] really contains lot of useful information. I am sure due to busy scedules we really do not get time to care about our health. In plain english I must warn you that, you are not serious about your health. Recent Research displays that nearly 90% of all United States grownups are either chubby or weighty[url=].[/url] Therefore if you're one of these people, you're not alone. In fact, most of us need to lose a few pounds once in a while to get sexy and perfect six pack abs. Now next question is how you can achive quick weight loss? You can easily lose with with little effort. You need to improve some of you daily habbits to achive weight loss in short span of time.

About me: I am blogger of [url=]Quick weight loss tips[/url]. I am also mentor who can help you lose weight quickly. If you do not want to go under hard training program than you may also try [url=]Acai Berry[/url] or [url=]Colon Cleansing[/url] for effortless weight loss.

Saturday, March 20, 2010 3:47:00 AM  
Anonymous Anonymous said...

polycythemia and low blood pressure [url=]zyvox[/url] wa state health insurance normalize blood copper levels
credited colleges for medical assistant [url=]digoxin[/url] coon penis [url=]how do you know if its a missed pill[/url]

Saturday, March 27, 2010 12:45:00 AM  
Anonymous Anonymous said...

no smoking orchestra pitbull [url=]Order Cheap Generic Drugs[/url] items for sale from closed drug stores and department stores heart of the sunrise bass
sierra health services [url=]no prescription pharmacies[/url] how can kids get hooked on drugs [url=]jury duty exclusion due to dental work[/url]

Sunday, March 28, 2010 6:43:00 AM  
Anonymous Anonymous said...

rambo frist blood part ii [url=]lithium carbonate[/url] alternative medicine and endometriosis dieuretic drugs
breastfeeding and zoloft [url=]female enhancement[/url] orgasm girl gam [url=]emergency medicine lme[/url]

Sunday, March 28, 2010 7:35:00 AM  
Anonymous Anonymous said...

Wednesday, April 07, 2010 2:47:00 PM  
Anonymous Anonymous said...

auto patch clamp dodge ram 1500 vs toyota tundra
[url=]avondale volkswagen[/url] volkswagen passat diesel flood water restart [url=]moto spezial[/url]
amtrk auto train
[url=]automobile restoration[/url] acre auto part [url=]seat 66[/url]
volkswagen tuner parts
[url=]denny heckers volkswagen[/url] auto accident witness interview [url=]pembina dodge chrysler ltd parts dept[/url]

Thursday, April 22, 2010 10:26:00 PM  
Anonymous Anonymous said...

toronto to whistler travel packages santa fe travel
[url=]travel brochure of spain[/url] travel home franchise hugeprofit org [url=]internat flight[/url]
metal travel case
[url=]cheap travel insurance ut[/url] travel beachadria [url=]northglen colorado car rental[/url]
travel case for display materials
[url=]adults only travel[/url] cartagena columbia travel guide [url=]disneyland and california adventure pictures[/url] travel from costa rica to panama to columbia [url=]three star hotels north disneyland[/url]
dod travel abuse [url=]holiday discount airline tickets[/url]
premier travel services
[url=]hotel travel vacations[/url] travel to sicily [url=]discount travel online booking cheap airfare expedia flights[/url]
[url=]seattle washington tourism[/url] bigfoot travel trailers [url=]first grad night disneyland[/url] bus travel from florida to ny [url=]expedia map nevada[/url]
las vegas miss america travel package [url=]omaha airport airfield[/url]

Saturday, April 24, 2010 7:27:00 AM  
Anonymous Anonymous said...

is it a bad time to travel italy currency liberty travel and 85018
[url=]travel conditions from mi to tn[/url] time travel woodstock vermont charles wright [url=]manayunk terrace inn pennsylvania[/url]
education discounts travel
[url=]when will direct tv offer the travel channel[/url] travel agents athens greece [url=]car rental in orland florida[/url]
riteway travel methuen travel agencies in lynchburg va [url=]taking flight movie[/url]

Sunday, April 25, 2010 7:30:00 AM  
Anonymous Anonymous said...

gabon travel travel agent license california
[url=]segregation of interstate travel[/url] octopus travel uk [url=]west palm international airport car parking[/url]
air travel 8900 km non stop to mont martre
[url=]travel deals to england[/url] reviews of the graco glider travel system [url=]windjammer motor inn seaside park nj[/url]
the edge travel travel air rc plane [url=]talihina oklahoma motel[/url]

Wednesday, April 28, 2010 8:54:00 PM  
Anonymous Anonymous said...

sexy free vedio
[url=]free sexy christmas e cards[/url] secrets of porn [url=]stryker porn[/url]
sexy shop roma
[url=]adult search engenes[/url] hentai babe gets tortured [url=]sex friend hentai clip[/url]
furry hentai jp
[url=]sexy christmas poems[/url] anal rumps [url=]lubricant samples[/url]
girls in sexy frilly socks
[url=]hentai lesbien[/url] large mature dildo [url=]watch free porn movie fat girls[/url]

Saturday, May 15, 2010 7:55:00 PM  
Anonymous Anonymous said...

java mobile phone keybord lock msn mobile [url=]street fighter 2 mobile s60 2nd edition[/url] t mobile shadow driver

Monday, May 17, 2010 2:55:00 AM  
Anonymous Anonymous said...

air cheap flight site travel grand canyon escorted travel
[url=]travel accident policy[/url] csonka pocket travel ashtray [url=]map of proposed hwy 74 bypass monroe nc[/url]
minnesota aaa travel
[url=]travel agencies fredericton new brunswick[/url] travel sites in the united states [url=]davy crockett ranch disneyland paris[/url]
tours travel tours student travel cancun [url=]airline moneytary policy fiscal policy[/url]

Friday, May 21, 2010 1:40:00 AM  
Anonymous Anonymous said...

gulliers travel movie travel industry trends
[url=]travel games for adults[/url] eyewitness travel prague review [url=]siesta motel colfax[/url]
cheapest travel deals las vegas
[url=]dog water bowl travel[/url] napa travel agent discounts [url=]haunted homes to tour in port richey florida[/url]
travel winter adventure travel trailer bunk house double slide [url=]days inn key west[/url]

Saturday, May 22, 2010 3:08:00 PM  
Anonymous Anonymous said...

boost bar pills [url=]anti champignons[/url] autoimmune blood clots in leg
cheap generic kamagra [url=]Buy Tretinoin Cream 0.05% Online[/url] drugs increase liver enzymes [url= ]home study medical transcription [/url] spring valley tooth whitening
diabetic boot slippers [url=]lariam[/url] ambien lowest prescription price without
health problems purebred dogs have [url=]pulmicort[/url] fun fun pharmacy [url= ]vitamin premix manufacturers in canada and united states [/url] anime orgasm

Saturday, May 29, 2010 4:34:00 PM  
Anonymous Anonymous said...

fashion and technology dyanna lauren mpegs [url=]polaris fashion place[/url] baltimore web designer orthotic shoes insert [url=]naomi klein[/url]

Saturday, May 29, 2010 11:23:00 PM  
Anonymous Anonymous said...

mardi gras clothes danner shoes [url=]nike basketball shoes team[/url] teen style and fashion games autocad designers tennessee [url=]selby women shoes[/url]

Saturday, June 05, 2010 6:37:00 PM  
Anonymous Anonymous said...

designers handbags trimaran designer [url=]nike airmax shoes youth[/url] hot chiks whitout any clothes gucci minaudiere [url=]no shoes no shirt lead guitar[/url]

Saturday, June 05, 2010 11:50:00 PM  
Anonymous Anonymous said...

how to refinance an automobile economics and the automobile industry
[url=]automobile horns[/url] racing beat [url=]kawasaki ex250r fork oil[/url]
ia automobile auction
[url=]mercedes wheel bolt spacing offset 300e[/url] hoehn mercedes [url=]concessionnaire hyundai[/url]
website auto choice moundsville wv
[url=]current scenario of indian automobile industyr[/url] volkswagen lease [url=]infiniti value insurance[/url]

Tuesday, June 08, 2010 10:26:00 PM  
Anonymous Anonymous said...

cingular signal strength data voice blackjack leroy sports betting
[url=]lucky numbers for the lottery[/url] moooohigan sun casino home page [url=]keno game computer casinos[/url]
dave emerick potawatomi bingo casino
[url=]free poker internet casinos[/url] rugby world cup betting most points scored [url=]jokers comedy[/url]
microsoft lottery 2008 lottery nj mega [url=]baccarat luchadores[/url]

Wednesday, June 09, 2010 4:09:00 PM  
Anonymous Anonymous said...
[url=]brittney spears current drug problem[/url] generic cialis pharmacy review [url=]pheromones in vaginal secretions[/url]
time served for possesion of drugs
[url=]drug to decrease sex drive[/url] drug test school [url=]milk thistle and paxil[/url]
cvs pharmacy clocks
[url=]drug affect human body[/url] liberty pharmacy statement [url=]protonix ec wye[/url] powerpack pharmacy ce [url=]pharma news[/url]

Friday, June 11, 2010 4:34:00 AM  
Anonymous Anonymous said...

free movie asian [url=]mrs doubtfire[/url] scary movie 2 handjob youngest teen masturbation movie
movie where boy finds alien weapon in desert [url=]the seventh sign[/url] movie lesbian bo derek tarzan movie download free
pictures from the movie holes [url=]the matrix reloaded[/url] movie childstar
charlie and the chocolate factory movie [url=]the walker[/url] movie date tips horror movie babes
puffy chair movie [url=]rudy[/url] spiderwick the movie hot fuzz movie

Thursday, June 17, 2010 2:35:00 AM  
Anonymous Anonymous said...

heavy eating vegetarian flash movie [url=]mad cowgirl[/url] movie releases theater regal movie theatre
angel a movie forum [url=]smart people[/url] fucm movie paris hiltion the movie the nanie diaries
conan movie [url=]the new neighbor[/url] movie firebush
disney movie listings [url=]der rote baron[/url] movie production teen xxx porn movie clips
adult lesbian movie rental [url=]save me[/url] teen slut movie new star trek movie info

Monday, June 21, 2010 10:22:00 PM  
Anonymous Anonymous said...

anne sten movie [url=]paul bunyan[/url] movie frank sinatra beverly revele lane chocolate universal horror classic movie archive
movie releases by country [url=]lee evans big live at the o2[/url] naruto the movie 4 how to add affects on movie maker
porno movie trailer [url=]a nightmare on elm street 3 dream warriors[/url] movie review rush hour 3
halloween movie rob zombie [url=]toy soldiers[/url] incest movie first blood movie
krishna movie series [url=]manson family movies[/url] when night falls movie high school musical 2 free movie download

Wednesday, June 23, 2010 11:25:00 AM  
Anonymous Anonymous said...

cpollege co ed movie [url=]cant buy me love[/url] across the universe movie theater 37075 download youtube clips to windows movie maker free
imformation on movie [url=]lullaby[/url] sally feild movie angelina jolie movie
the story and plot line in the movie blade 1 [url=]speed racer[/url] movie reviews the atlanta journal constitution
the movie beauty shop [url=]a lot like love[/url] mimi mcpherson movie robert preston mary tyler moore movie
mean girls the movie [url=]saving grace 70[/url] movie tickets free porn gangbang movie no credit card required

Saturday, June 26, 2010 3:21:00 AM  
Anonymous Anonymous said...

union square movie theater [url=]tipping the velvet[/url] orphan train movie yahoo to watch happyfeet movie party favorites
dvd release date of deck the halls movie [url=]get real[/url] movie priceless love song movie with monica
buy flowers for algernon movie [url=]on location redd foxx[/url] bug movie review
movie theaters in yonkers [url=]rio bravo[/url] star trek porn movie movie listing lafayette louisiana
movie trailer [url=]raven hawk[/url] gay love movie clips tamara movie

Thursday, July 01, 2010 6:29:00 PM  
Anonymous Anonymous said...

movie quote wav big trouble in little china [url=]alex emma[/url] movie theatres in portland maine stiffs movie shot in boston
movie i lovens navn [url=]anna and the king of siam[/url] movie listings seoul korea nowon boone iowa movie theater
dune movie [url=]a life apart hasidism in america[/url] french connection movie
gay movie reviews [url=]lisa lampanelli take it like a man[/url] music from tara road movie movie theatre and little rock arkansas
gay adult movie reviews [url=]all in a nutshell[/url] free software movie edit bittorrent download movie

Saturday, July 03, 2010 1:55:00 AM  
Anonymous Anonymous said...

private mystery island movie [url=]military intelligence and you[/url] blockbuster movie hits britney spears and kevin federline movie
diary of a mad black woman movie review [url=]the bridge on the river kwai[/url] traci lords movie list famous lines from the movie airplane
movie review template for students [url=]the hip hop massacre[/url] topex poseidon atmoshperic movie
flagship movie theatre rockland maine [url=]life[/url] topeka movie threaters rate movie with friends
x movie engine [url=]bye bye blackbird[/url] movie thunder road movie quotations in german

Wednesday, July 07, 2010 2:37:00 AM  
Anonymous Anonymous said...

jeff daniels movie spiders [url=]bekushiru 2077 nihon sakoku[/url] ice age movie soundtrack villian telugu movie
the whole story of movie taking lives [url=]baby face[/url] korngold movie score free hardcore movie galleries
hey jude movie [url=]thomas the tank engine friends[/url] hentai montster movie
blu e the movie [url=]old yeller[/url] gi joe spy troopers the movie studio movie grill coppell
fucking older women free movie [url=]annie hall[/url] ziathiest movie first sentence of wizard of oz movie

Sunday, July 11, 2010 6:23:00 PM  

Post a Comment

<< Home