Help to create Mutual Fund spread sheet

Currently I am with a broker to manage my retirement.i need help to create a excel spreadsheet to monitor my MF daily. something like ammozation chart
previous bal,moneymarket ,ending,% of daily change, balance. If I had some thing like this I would have got out in 08. I throught he would let me know that my fund is dropping. But i was wrong so, I need to take care of myself.

Please help with this problem for me You guys know want I am talking about
Thanks rivitbob

Hi,

Try this.

http://chandoo.org/wp/2008/04/18/tracking-mutual-fund-stock-portfolios-using-excel-howto/

Thank you so much Nava for the wonderful link.

Thanks a lot :thumb:

PS: do u have any other links for the excel related stuff.
i want to learn how to use Excel for data analysis and plotting various charts etc.

Hi,

Me too intrested in learning Excel. I found that link here in Traderji only.
I have some knowledge in Excel macros but not in charting.

Regards,
Nava,