QUOTE(polarzbearz @ Feb 1 2015, 12:58 PM)
Sifus-sifus sekalian,
Currently I'm working on the data importer (converts FSM historic transaction into my spreadsheet format) as you all know, I'm pretty new to FSM platform and thus, limited amount of data.
Appreciate if any of you (with mass amount of transactions) to share with me the "Transaction Types" available in your "Historic Transactions @ FSM" (not your data. but small sample of your data is appreciated too for testing, if you don't mind

) available in FSM? Currently this is what I'm aware and confirmed of based on my historic transaction + the sample data sent by
jutamind for analysis:
For PURCHASES
- Buy
- Switch Buy
- [GUESSING] I'm guessing there's nothing else here
For SALES
- Switch Sell
- Platform Fee Sell (<<<< basically equivalent to "Sell" in my spreadsheet)]
- [GUESSING] I'm guessing there will be Sell
Appreciate if any of you could provide inputs as I need to know "Remarks" available in FSM to convert / map it to the "Transaction Type" in the spreadsheet

For me...
Buy (by cash)
Switch Buy (switch from other fund or from CMF)
Dividend / Unit Split
Sell (receive cash)
Switch Sell (switch into other fund or back to CMF)
Know why I distinguish between cash and CMF transactions?
I actually maintain 2 spreadsheets. 1 is my main spreadsheet as in Post #1, and another 1 which records all TRANSACTIONS, in date order. With use of Data Filter, I can easily see things like...
How much cash I actually pumped into my UTs...
How much cash I actually received from my UTs...
Sum up this 2, I get my NET
cash invested into UTs
Compare that with my current portfolio valuation, I get sum check for my total profit
This transactions worksheet is also useful in case in future I wanna migrate to other worksheets, all historical transactions are there for future use
This post has been edited by Pink Spider: Feb 1 2015, 01:22 PM