QUOTE(ironman16 @ May 29 2018, 08:49 PM)
Boss, the lastest version haven't upload?....
Not yet, still figuring out/working on some stuff like :
how to help existing users to migrate data to new template/windows + mac support / auto update currency table / fund updater on non FSM funds
Also to clean up some codes as it's still messy at the moment.
QUOTE(idyllrain @ May 29 2018, 11:31 PM)
Remove the 0.87 adjustment and you'll get a value that is exactly the same as the one in FSM.
QUOTE(WhitE LighteR @ May 29 2018, 11:45 PM)
FSM
[attachmentid=9830273]
Excel
[attachmentid=9830274]
If I remove the 0.87 the number will not tally with FSM. Hence why i need the correction.
If I remove it, the result will be as follows "
FSM shows Cost is at 25,524.24
Excel shows Cost/Transaction Amt is at 25,525.11
QUOTE(idyllrain @ May 30 2018, 12:50 AM)
Ah now I get what you mean.
Polarzbearz "Entrance Value" is not the same as FSM Cost; here if you buy RM10k @ RM1 NAV and sell all RM2 NAV, Entrance Value would be -RM10k (reflecting that you gained RM10k). Hence if you perform multiple buy/sell transactions, your Entrance Value would be below your original cost and thus "realizes" the profit. This isn't an error in the underlying calculations, just a different way of interpreting the data. Ideally though, you shouldn't be doing manual adjustments to the entries in the Excel sheet since that will introduce an
actual error to your data.
Converting the file to the FSM method would introduce a different effect to the ROI: realized profits would be counted as input cost. For example, buying RM10k @ RM1 NAV, then sell 5000 units at RM2 NAV, then use the proceeds to buy again would mean your input cost is now RM15k (RM5k remainder cost* + RM10k realized from the 5000 units sold). This sequence of actions would immediately reduce calculated ROI (increased cost, constant value); on the flip-side, in Polarzbearz's Excel the calculated ROI would immediately increase (decreased cost, constant value).
In summary, Polarzbearz treats realized profits as reducing cost, while FSM treats realized profits as increasing cost. Just two different perspectives. See also the bottom half of
this post for the different approaches.
* Remainder cost is calculated by: Total Cost - (Units Sold * Weighted Average Cost)
Thanks
idyllrain! You explained it better than I could
Just one thing to add on, usually to validate if there are any errors in excel which requires manual adjustments, check only on current values, nav price, current unit, roi amount (not %).
Been validating this way and it works for both FSM MY and FSM HK. Hence in the new version I added dynamic decimal places due to how FSM MY /HK performs unit calculation differently, ie FSM MY rounds to 2 decimal places whereby FSM HK rounds to 4 decimal places. Unfortunately I don't have FSM SG account transactions data to cross validate this.
One last thing, in case if anyone's interested, there was a long long discussion on the formula, calculations, rationales, etc. etc. in the FSM v8 thread which resulted into the current stable release version (v2.2b) :
https://forum.lowyat.net/topic/3450434?author=polarzbearzThis post has been edited by polarzbearz: May 30 2018, 08:28 AM 
May 28 2018, 12:11 AM
Quote
, but made some adjustments again. Hopefully can get more time to finish up the excel
0.0536sec
0.46
7 queries
GZIP Disabled