SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : LastShadow's Position Trading -- Ignore unavailable to you. Want to Upgrade?


To: tom pope who wrote (3774)12/5/1998 8:36:00 PM
From: LastShadow  Read Replies (1) | Respond to of 43080
 
Mutual Fund and 401k in Excel Spreadsheets

WalterG emailed me the following:

Here is a great explanation from PC World about how to use the XIRR
command to find the Internal Rate of Return for 401K plans.

The first URL is the explanation and formulas:
www2.pcworld.com

The second URL is a figure showing where the formulas go in an Excel
spreadsheet:
www2.pcworld.com

You can use some ofthe web queries in the zipped file on my website at home.earthlink.net to bring fund data into those spreadsheets - but in only works in Excel 97. Post #84
( Message 5625447 ) on this thread 'splains Web queries (thanks for that reference too Walter!)

lastshadow