$$$ KPO and CZM $$$: Syfe Transactions Parser

Monday, May 18, 2020

Syfe Transactions Parser

I did a Syfe REIT+ (100%) Review and decided to open an account. As I was preparing to import the transactions into StocksCafe for tracking over the weekends, I realized an annoying thing when I copy and pasted them into an excel - it is not properly formatted to be displayed in tabular manner -.-

Copy the transactions out

Paste into excel

My thoughts - TMD and spent about 15 minutes to code out a Python (version 2) script to parse and output those transactions into a csv. Regardless if you are using StocksCafe or your own spreadsheet for tracking, you should find it useful.

Firstly, download this script (syfe_parser.py) and save it whenever you want.

Next, copy and paste the transactions and save it as 'transactions.txt' (I hardcoded it, you can modify it if you know how to) in the same place you kept the script.


Last but not least, just run/execute the script (python syfe_parser.py) and you will get a syfe_transactions.csv that looks like this. I even computed the average price per transaction which was missing in Syfe dashboard.


With this, I transform the data further and was able to import all the transactions into StocksCafe! I like to track all my investments with StocksCafe as I get a lot more data/visibility. We can see this portfolio has a projected yield of ~5% which is in line with our goals! Oddly, there are only 19 stocks instead of 20 (iEdge S-REIT 20 Index) in the portfolio and I can't find the components online too.

Updated as Eliezer from Syfe reached out - Came across your post today on the Syfe transactions parser and your question on why there are 19 REITs. Briefly, while the iEdge S-REIT 20 index has 20 REITs, our REIT+ portfolio has 19 REITs because one of the REITs in the index (Manulife US REIT) is USD-denominated. At this point, we are keeping all the REITs in the REIT+ portfolio as SGD-denominated REITs. Even with 19 REITs, you can be assured that our portfolio is still tracking the index very well. Our stated aim is after all to replicate the performance of the iEdge S-REIT 20 index as closely as we can!

Overview

Report

Honestly, I am quite annoyed at how all these robos are not providing an option to export/download these transactions. I have made multiple requests to StashAway (not to Syfe yet) and was always brushed aside that it is not in their list of priorities. How long is it going to take your developer to implement a simple feature like this? Max 1 hour? Oh well, not going to stop me :)

If you are interested in signing up, do use our referral code (KPOBONUS) for some cash incentive! Invests $500 and more and we will receive a $10 bonus each. Invests $10,000 and more and we will receive a $50 bonus each. Invests $20,000 and more, we will receive a $100 bonus each!

If you are interested in the smart portfolio tracker (StocksCafe) which I am using as shown above, sign up using my link for a longer trial period :) Refer to our Referrals page for more information.

Do like any of the following for the latest update/post!
1. FB Page - KPO and CZM
2. Twitter - KPO and CZM
3. Click here to subscribe using email :)
4. Instagram - KPO_and_CZM (Did you see those delicious food photos to the right --> Unfortunately, you can't see it on mobile.)

9 comments:

  1. Thank you! Considering that I just started with SYFE this is a time-saver! I think a bunch of you guys who are techie bloggers dabbling with Python and coding can team up and do lots of good haha!

    Kevin, Turtle Investor

    ReplyDelete
    Replies
    1. Haha. You are welcome! Evan is doing lots of good with StocksCafe already.

      Delete
  2. Thank you so much! This is what I have been looking for

    ReplyDelete
    Replies
    1. Haha. You are welcome! Glad that you found it useful!

      Delete
  3. Thks a lot! Newbie here. How do you run/execute the script (python syfe_parser.py) in the excel?

    ReplyDelete
    Replies
    1. Hi Cryptocoin8088,

      You have to download and install python on your machine:
      https://www.python.org/download/releases/2.7/

      After that can just open a command prompt at the location where you store the script and run "python syfe_parser.py".

      Delete
  4. hi, can you show a sample how you further "massaged" the data before importing? not sure which columns to add/move, and how to handle the dividends and mgmt feets. thanks in advance!

    ReplyDelete
    Replies
    1. Hi Wx,

      You only need to import Buy/Sell transactions. You can refer to this - https://stocks.cafe/personal/portfolio/transactions/tobulkupload:
      Column 1) (-1 or 1 or 0 to indicate sell for -1, buy for 1 and fees for 0) OR (Buy or Sell or Fees text are also acceptable)
      Column 2) Exchange Code (i.e. SGX or HKEX)
      Column 3) Symbol
      Column 4) Units Purchased or Sold
      Column 5) Currency
      Column 6) Price Paid or Received (based on the currency this stock trades in)
      Column 7) Date of transaction (YYYY-MM-DD or MM/DD/YYY)
      Column 8) Total after fees (Blank is allowed) (based on the currency this stock trades in)
      Column 9) Anything you would like to note about the transaction (Blank is allowed)

      Example: 1, SGX, ES3, 1000, SGD, 3, 2015-01-03, 3003, "First trade of the year"

      You can refer to this post too - https://kpo-and-czm.blogspot.com/2020/05/stashaway-transactions-parser.html

      Dividends are automatically tracked by StocksCafe. As for mgmt fees, I add them manually.

      Delete