SteveT
Member of DD Central
Posts: 6,875 
Likes: 7,924
|
Post by SteveT on Apr 7, 2018 7:13:33 GMT
Done some research but struggling to apply the formula on the 'account information' breakdown data...is that the data you are using? It is not coming up with the % The inputs you need are your account cashflows (cash deposits -ve, cash withdrawals +ve) and the dates they happened, plus a "current account value" (+ve) dated today. The question is what figure to use for your "current account value". If you include all your unpaid accrued interest and allow for no future capital losses then you're definitely overstating reality! A crude approximation could be to ignore accrued interest and assume that this will offset future capital losses (ie. just use the "Total funds" figure on your "Account information" page).
|
|
number5
Member of DD Central
Posts: 449
Likes: 98
|
Post by number5 on Apr 7, 2018 10:48:07 GMT
Done some research but struggling to apply the formula on the 'account information' breakdown data...is that the data you are using? It is not coming up with the % The inputs you need are your account cashflows (cash deposits -ve, cash withdrawals +ve) and the dates they happened, plus a "current account value" (+ve) dated today. The question is what figure to use for your "current account value". If you include all your unpaid accrued interest and allow for no future capital losses then you're definitely overstating reality! A crude approximation could be to ignore accrued interest and assume that this will offset future capital losses (ie. just use the "Total funds" figure on your "Account information" page). Awesome...thanks so much Steve T! Manage to get it working!
|
|
