On a monthly basis, the formula is:100*(Amt_at_end_of_month - Amt_at_beginning_of_month + Amt_withdrawn - Amt_deposited)/Amt_at_beginning_of_monthHowever, there is obviously a time distortion, depending on when you made deposits or withdrawals.The *right* way to do it is to apply that formula on a daily basis. This gives you the daily return. Then you can accumulate this on a daily basis to get your return over any period of time.But just don't forget to update your spreadsheet every day!That is a bit too much even for me.
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Market data provided by Interactive Data.
Company fundamental data provided by Morningstar. Earnings Estimates, Analyst Rat