Subscribe to RSS feed
posted on 28 Dec 2018  -  31,213 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
Personalized grouping of Stocks
A feature that has been requested by various users is the ability to tag stocks. With that, one would be able to group stocks by their own definitions and a wide variety of possibilities would open up. One specific application would be to look at what percentage of your portfolio is in various groupings (for example, you can now see what percentage of your portfolio are made up of dividend stocks, ...
What to buy next? - Part 2
There exists hundreds of stocks in SGX and deciding what to buy next is not an easy task. In part one of the "What to buy next?" article, I shared a few tools in SGXcafe designed to help me with this problem, including a new screener tool, Screener added to SGXcafe about 3 weeks ago. Screener was met with very positive response and high usage, and I received comments on how useful it was and requests ...
Stay Alert with SGXcafe
Note: Instead of every minute, alerts will be check daily at the end of day due to licensing issues. In an ideal world, we would be able to monitor the stock market around the clock, so that we would know the instant the stock reaches a price we've been gunning for, or when the stock we've KIV-ed at the back of our minds is approaching the ex-dividend date. Alas, we don't live in an ideal world, and ...