Fundsupermart.com v8, The MS Excel Masterclass version!
|
|
 Jan 11 2015, 07:35 PM
Return to original view | Post
#1
|
 
Senior Member
2,516 posts Joined: Feb 2007 From: Uarla Umpur   
|
QUOTE(David83 @ Jan 11 2015, 06:00 PM) =(POWER(G5/C5,1/(YEARFRAC(A5,TODAY())))-1)*100 I'm running several nested formula: G5: Current valuation of the fund C5: Capital invested A5: First date where the fund is bought   hmm cagr of 7.. not bad i guess  |
|
Topic ClosedOptions
|
| Change to: |  0.0430sec
 0.78
 7 queries
 GZIP Disabled
Time is now: 30th November 2025 - 02:58 AM |
Quote