Subscribe to RSS feed
posted on 28 Dec 2018  -  43,530 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
- How do we bulk upload transaction (not payment) here https://stocks.cafe/personal/assets/transactions/toadd? Transaction is closer to reporting my option trades than payment, but there are a lot to enter manually if without the bulk upload/import function.
15 Dec 2020 20:17:23
Next Article >
< Previous Article
Net Worth & Financial Freedom Index
StocksCafe API and Customizable ...
List All Articles
Other articles by evankoh
Shares Quantity Now Supports Decimal Values!
Firstly, I would like to apologize to users who were affected by this "migration" last night and seeing errors on many StocksCafe pages. I was making a seemingly simple change, but is actually more complicated. I was making a database change for the field "shares quantity" from only accepting whole numbers (i.e. integers) to allow decimal values (i.e. floats). As integers and floats are considered ...
SGXcafe in 2017
Review of 2016 2016 have been a year with its ups and downs for SGXcafe. At one point, it is faced with the possibility of shutting down. However, with the support of many users, it managed to march on. I truly appreciate each and every one of you for using SGXcafe especially those whom also contributed financially and/or by sharing about SGXcafe. Looking back at the articles of 2016, I realized we ...
Start of Support for London Stock Exchange!
The current top request (i.e. the most likes) is for StocksCafe to support the London Stock Exchange (LSE), and I am very happy to share that StocksCafe now provides limited support for LSE! What does limited mean? It means that StocksCafe only has End of Day pricing data for LSE. We were unable to secure dividend nor fundamental data. However, with this, you can enter transactions for London stocks ...