Subscribe to RSS feed
posted on 28 Dec 2018  -  24,159 views
Regularly, I would receive requests asking, "When will StocksCafe include XXX?". They are typically other exchanges like London Stock Exchange or Australia Stock Exchange. Occasionally, it would be about commodities or other assets such as insurance, mutual funds, etc.
Ideally, StocksCafe would be able to include at least all major exchanges, commodities, and funds in the future. However, I am not sure when that will happen, if it happens at all. And even then, StocksCafe cannot realistically include every single asset that exists in the world.
Hence, I decided to work around it and support all possible assets in another way - DIY style.
It only takes a few simple steps to add any asset to your account:
Define the asset - Define a new asset on
Input transactions - Input transactions that you have performed with the new asset on
this page (e.g. when you buy/sell).
Input payments received - Input payments you received from this asset on
this page (e.g. dividends, interest, rental, etc).
Overview - Finally,
this page gives an overview of the assets added, just like our
stock portfolio page.
Bonus: Update the market value - You can also update the market value of your asset over time by going to the individual asset page and clicking on "Add new price". To reach an individual asset page, you can start from the
list of assets page and clicking on the asset name.
I hope that with this new feature, you can now track all your assets using StocksCafe!
As always, I am more than happy to receive questions and suggestions.
- Hi Evan possible to include calculation of any asset to be taken with the stocks portfolio as well?
28 Dec 2018 13:54:19
- Thanks! Let me figure out how to input options :)
28 Dec 2018 14:09:31
- @urameshi85 - Sure. That is certainly in the pipeline
@azael - sure. I will add options and futures as asset classes. Let me know if there are other things needed to support them.
28 Dec 2018 14:58:43
- @azael, okie. Added options and futures asset class.
28 Dec 2018 16:51:35
- Looking forward to when we can bulk import/enter (in simple format, I think 2 columns like date and price is enough for now) the list of prices of asset at various point of times. (e.g. monthly closing price, and we can copy and paste from sites like yahoo)
WIll be good if there is option to be include in portfolio performance calculation as well! Thanks for the improvement!
28 Dec 2018 21:10:13
- @zzsg - Bulk import/enter sounds good. Would you like to create a feature request for that?
"WIll be good if there is option to be include in portfolio performance calculation as well!" => This might be more complicated because of potential lack of price points in some assets leading to inaccurate computation/reduced volatility of asset. However, certainly doable is simply add up the total value between stocks portfolio and other assets.
29 Dec 2018 05:59:35
- I may have missed this but I am inputing holdings in USD. Able to key in the exchange rate for that particular trade so that I see my stocks performance in SGD?
29 Dec 2018 23:39:02
- You can see in SGD but you cannot set your own exchange rate :(
29 Dec 2018 23:51:06
- The SGD amount is just the total amount in USD converted to SGD at the current spot price? Thanks for this new addition though! :)
29 Dec 2018 23:55:25
- I based it on this -> https://stocks.cafe/exchangerate?exchange=XSES
The source is supposedly from ECB though I got it from a data provider.
Transaction price would be based on the exchange rate of when the transaction is made.
And the current value would be based on the latest exchange rate.
Hope that make sense.
30 Dec 2018 05:42:57
- Evan, thanks for clarifying. So if I am understanding correctly, the P&L in SGD is based off the current SGD value of my USD holdings minus the cost in SGD at the time/date of each transaction?
30 Dec 2018 10:24:04
- "So if I am understanding correctly, the P&L in SGD is based off the current SGD value of my USD holdings minus the cost in SGD at the time/date of each transaction?" => Hmm.. Actually, not true. Sorry, I think I was wrong earlier. Assuming that the stock is traded in USD and you entered the trade in USD, then the P&L in SGD should simply be the P&L in USD converted into SGD at current USD/SGD rate.
30 Dec 2018 16:03:35
- " Assuming that the stock is traded in USD and you entered the trade in USD, then the P&L in SGD should simply be the P&L in USD converted into SGD at current USD/SGD rate."
To seek further clarification, if I buy a stock at USD1.00 1 year ago (USD1=SGD1.40), and currently the stock is USD1.50 (USD1=SGD1.50. My profit is USD0.50. I presume the P&L in SGD is based on today's price, ie 0.50 x 1.50.
I think whilst this is simple for the purpose of calculation, it didn't account for currency shifts (which is in itself affecting P/L) and assumes that the buyer already had USD at that time instead of converting SGD to USD to buy, which is more common,
Could the system base it on (USD1.00 x 1.40) against USD1.50 x 1.50 to get the SGD P/L instead?
If not, then perhaps we should all be entering the transactions based on SGD we paid at the time of transaction rather than in USD.
2 Jan 2019 09:30:31
- "If not, then perhaps we should all be entering the transactions based on SGD we paid at the time of transaction rather than in USD." => Yes, you are right. I believe in this case, it is best to enter the transactions (buy and sell) in SGD to have everything be considered in SGD.
2 Jan 2019 16:58:18
- Hi, in the case of stocks input from, say, LSE... would it be possible to define the current price as pulled from google finance, for example? At least that way, there's some measure of auto updating. Though in hindsight, this would definitely break if Google Finance changes their accessibility terms etc.
4 Jan 2019 13:39:45
- @dchieng, technically, it is possible but legally I am not sure how it plays out.
4 Jan 2019 13:45:01
- I may have missed it, but is there a way to remove an asset that was accidentally added to the list?
4 Jan 2019 14:14:31
- @bubbles123, it is deliberately made so that one cannot delete assets because otherwise, there could be potentially orphan transactions, prices or payments etc. Is that a wrong design? Do you think you can repurpose it by editing it to something else?
4 Jan 2019 14:17:05
- Oh right! Didnt thought about the orphaned transactions etc. And yes okay, will repurpose it to something else. Thanks Evan!
4 Jan 2019 14:21:15
- Sure. No problem. Honestly, another approach would be to "nuclear" everything related to deleted assets but I prefer not to delete user contents as much as possible.
Anyway, glad it would work out (at least for now)
4 Jan 2019 15:30:24
- Thanks a lot for that, this new feature to track other assets is really great. Just waiting for the ability to have it also calculated with your portfolio then it would be even better! Thanks Evan.
12 Jan 2019 23:44:00
Next Article >
< Previous Article
Net Worth & Financial Freedom Index
StocksCafe API and Customizable ...
List All Articles
Other articles by evankoh
SGXcafe to Expand to APAC!
After a round of voting and discussion with Friends of SGXcafe, I am happy to share that we have decided to support APAC markets in the upcoming expansion! I have already started work to include Hong Kong exchange data. You should start to see changes within this week. Supporting a brand new market is not easy and would take time to iron out all the details, especially since I developed SGXcafe previously ...
One Less Password with Facebook Login
StocksCafe has integrated Facebook login to allow for quicker login (bonus: you have one less password to remember)! For existing users, please go this page and click on the continue with Facebook button to associate your existing StocksCafe account with your Facebook account. Once you have done that, you will be able to login either via Facebook or StocksCafe username/email. For new users, you can ...
Hong Kong Stock Exchange Information Now Available!
After many hours of coding, I am happy to share that Phase 1 (of 3) of the expansion to Hong Kong is now complete! Information about Hong Kong stocks is now available in SGXcafe (e.g. CK Hutchison). At the moment, it hasn't been incorporated into the search yet, but you can find the full list of active stocks in Hong Kong Stock Exchange here. In Phase 2, I will focus on features revolving around adding ...