How to use StocksCafe to track StashAway (and other similar investments)?

Q&A
1

Credits: @iamsq and @wei
Note: I do not personally use StashAway or other robot advisors. This guide is mainly contributed by awesome users like @iamsq and @wei. Please feel free to let me know if you have any suggestions/comments.

Steps

  1. Create a new portfolio (e.g. StashAway USD)

  2. Set USX Tax Rate to 30

  3. Every month, download the monthly statements (PDF) from StashAway.

  4. Copy & paste the “Buy/Sell” transactions and format into CSV
    – Tips: Use Google Sheet and to help with transforming the data into the right format for StocksCafe

  5. Copy the relevant rows from Google Sheet (e.g. exclude header row) into a new CSV file for import into StocksCafe.

Bonus: Set up your StashAway Portfolio to compare against US Indexes (e.g. USX:SPY) to see how it is performing against indexes.

Caveats

  1. Price and Total column in Transaction Overview tends to be highlighted. However, they are safe to be ignored.
    – Highlighted Price just means that day, the stock did not trade in that range. Likely due to time difference or StashAway have a different lobang etc. So far, seems like difference is small and can be safely ignored.
    – Highlighted Total just means that for buy action, Price x Shares < Total which is weird for buy transactions (and reverse for sell action). Again, so far, it seems like difference is small and likely due to floating points errors hence can be safely ignored.

  2. Cash Balance Tracking
    It is not easy to track amount of cash in StashAway with StocksCafe because StashAway do not always convert 100% of cash into USD for trading (e.g. I put in SGD5,000 but StashAway only converts SGD4,950 into USD for trading). In addition, dividends are automatically reinvested.

  3. Dividends Tracking
    StocksCafe is able to somewhat track the dividends received automatically plus/minus a few cents.

  4. Monthly Fees
    StashAway have monthly management fees which cannot be handled based on current features. Need to add new feature to handle such periodic fees that are not tagged to transaction. One workaround will be to create fake transactions with the charged fees.
    Note: There is a feature request which would likely fix this.
    Yes, you can now handle monthly fees easily in StocksCafe! (See this article for more details.)

3 Likes