Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Profit % is not correct / Presence of (Blank) with -79% loss in Dashboard
Hi, my profit % seems to be way off. An example:
Qty Held Avg Book Value Cost Basis Total Value Capital Gain Dividends Profit Mgmt Fee $ Cost Basis per Unit Symbol Price Unrlzd Cap Gain Unrlzd Cap Gain % Mgmt Fee % First Buy Date Ever Profit % Annlzd RoR
12 1,262 1,262 1,266 4 3 7 105.15 105.49 4 0.33 % 2015-02-15 -19.23 % 200%
Also, there seems to be a (blank) with -79% loss in my dashboard.
Qty Held Avg Book Value Cost Basis Total Value Capital Gain Dividends Profit Mgmt Fee $ Cost Basis per Unit Symbol Price Unrlzd Cap Gain Unrlzd Cap Gain % Mgmt Fee % First Buy Date Ever Profit % Annlzd RoR
12 1,262 1,262 1,266 4 3 7 105.15 105.49 4 0.33 % 2015-02-15 -19.23 % 200%
Also, there seems to be a (blank) with -79% loss in my dashboard.
Comments
Profit % is calculated monthly and then linked geometrically. Sometimes one month abnormal values can affect your total value. For symbol with this problem - make sure:
1. First buy date is after your workbook min date.
2. You have quotes for that symbol at least once per month. You can go to \Quotes\ subfolder, find file with that symbol name and review.
Please check that. If all looks good to you, you can send me workbook just with that one symbol transactions - I'll investigate. My email: http://www.portfolioslicer.com/contact.html