Comparing my performance against S&P 500
-
- Posts: 27
- Joined: Wed Oct 10, 2018 1:07 pm
Comparing my performance against S&P 500
I am a software entrepreneur with a considerable amount of my assets in the stock market. I am wondering if you may know of any good websites where I can track how my individual stock purchase decisions are performing against a benchmark (say S&P 500).
As individual investors, we know that each and every buy/sell decision is an individual decision. So my goal is to easily understand how my decision to buy (for example) TSLA on 3/14/2018 fared, compared if I had just put the money straight into S&P 500 on 3/14/2018.
As individual investors, we know that each and every buy/sell decision is an individual decision. So my goal is to easily understand how my decision to buy (for example) TSLA on 3/14/2018 fared, compared if I had just put the money straight into S&P 500 on 3/14/2018.
Re: Comparing my performance against S&P 500
No web site will do this because your performance will depend on your transactions. You have to track your performance in something like MS Money (free download) by entering all your transactions and keeping them updated along with all the dividends that create transactions, too.
You can put in benchmark funds such as an S&P500 fund, but you probably have cash, bonds, other things that you want included in your performance, so your benchmark might be a LifeStrategy or balanced fund. That is, I would not compare to the S&P500 nor would I only track equities. I think you got to do the whole thing or you might fool yourself. For instance, if you are 90% cash and 10% equities, but only only compare your equities to the S&P500 that is not helpful.
You can put in benchmark funds such as an S&P500 fund, but you probably have cash, bonds, other things that you want included in your performance, so your benchmark might be a LifeStrategy or balanced fund. That is, I would not compare to the S&P500 nor would I only track equities. I think you got to do the whole thing or you might fool yourself. For instance, if you are 90% cash and 10% equities, but only only compare your equities to the S&P500 that is not helpful.
-
- Posts: 31
- Joined: Thu Oct 04, 2018 1:12 pm
Re: Comparing my performance against S&P 500
I wouldn't waste my time buying and selling individual stocks.
TSLA
1 year return of -27.75
3 year return of 5.19
5 year return of 8.24
Compared to VFIAX Vanguard S&P 500 index
1 year return of 15.34
3 year return of 14.95
5 year return of 13.98
Don't look for the needle in the haystack, just buy the whole haystack.
TSLA
1 year return of -27.75
3 year return of 5.19
5 year return of 8.24
Compared to VFIAX Vanguard S&P 500 index
1 year return of 15.34
3 year return of 14.95
5 year return of 13.98
Don't look for the needle in the haystack, just buy the whole haystack.
"Pain is the touchstone of all growth." - Bill W.
-
- Posts: 31
- Joined: Thu Oct 04, 2018 1:12 pm
Re: Comparing my performance against S&P 500
With that said, Morningstar is always fun to play around with...
https://www.morningstar.com/stocks/xnas/morn/quote.html
https://www.morningstar.com/stocks/xnas/morn/quote.html
"Pain is the touchstone of all growth." - Bill W.
Re: Comparing my performance against S&P 500
Boba, I'm not sure the S&P 500 is the appropriate index. Maybe you are holding lots of tech stocks or mid and small cap, so you have to find a benchmark that is similar to your holdings, and you also need to know the amount of risk you are taking. You also have to track trading costs and taxes if in a taxable account.
Paul
Paul
When times are good, investors tend to forget about risk and focus on opportunity. When times are bad, investors tend to forget about opportunity and focus on risk.
-
- Posts: 10843
- Joined: Thu Oct 15, 2015 3:53 pm
Re: Comparing my performance against S&P 500
I don't know of a site that would take into account all the purchase and sales over time. You can easily do this in Quicken or Excel. I'm not sure how useful comparing to a benchmark is if the benchmark has a lot of different key characteristics (diversification, risk, asset class, etc.).
Re: Comparing my performance against S&P 500
You need to decide if you want to compare just the change in the stock price to the change in the S&P500 price, or compare the total returns (which also includes reinvested dividends).
You can find the S&P500 index, either just the price or total return, easily with an internet search.
You can find the S&P500 index, either just the price or total return, easily with an internet search.
One thing that humbles me deeply is to see that human genius has its limits while human stupidity does not. - Alexandre Dumas, fils
-
- Posts: 27
- Joined: Wed Oct 10, 2018 1:07 pm
Re: Comparing my performance against S&P 500
Thanks for your reply. My goal is to compare a specific transaction vs some index. Comparing the performance of the overall fund (which includes cash, bonds, etc) is important too. I'm looking to create a website that can do this. Any interest in checking it out when it goes live?livesoft wrote: ↑Wed Oct 10, 2018 5:22 pm No web site will do this because your performance will depend on your transactions. You have to track your performance in something like MS Money (free download) by entering all your transactions and keeping them updated along with all the dividends that create transactions, too.
You can put in benchmark funds such as an S&P500 fund, but you probably have cash, bonds, other things that you want included in your performance, so your benchmark might be a LifeStrategy or balanced fund. That is, I would not compare to the S&P500 nor would I only track equities. I think you got to do the whole thing or you might fool yourself. For instance, if you are 90% cash and 10% equities, but only only compare your equities to the S&P500 that is not helpful.
-
- Posts: 27
- Joined: Wed Oct 10, 2018 1:07 pm
Re: Comparing my performance against S&P 500
S&P 500 was used just as an example. It could be another, more appropriate, index. Trading costs are fairly minimal. As for taxes, you'll have to pay taxes if you invest in an index or in an individual stock. So I think we can exclude taxes for now.pkcrafter wrote: ↑Wed Oct 10, 2018 5:48 pm Boba, I'm not sure the S&P 500 is the appropriate index. Maybe you are holding lots of tech stocks or mid and small cap, so you have to find a benchmark that is similar to your holdings, and you also need to know the amount of risk you are taking. You also have to track trading costs and taxes if in a taxable account.
Paul
-
- Posts: 2777
- Joined: Sat Feb 21, 2015 1:29 pm
Re: Comparing my performance against S&P 500
I certainly would not be interested in providing that level of detail about my investment transactions to a website. The web site could potentially do anything with the data. Of course, the brokerage that I use has the information, because they handle the transactions.BobaTeaGood wrote: ↑Wed Oct 10, 2018 5:59 pm Thanks for your reply. My goal is to compare a specific transaction vs some index. Comparing the performance of the overall fund (which includes cash, bonds, etc) is important too. I'm looking to create a website that can do this. Any interest in checking it out when it goes live?
Re: Comparing my performance against S&P 500
You shouldn't bother very much with benchmarking, because you are going to underperform anyhow. It's like playing in the casino, any money you make will eventually be taken back unless you stop playing.BobaTeaGood wrote: ↑Wed Oct 10, 2018 5:13 pm I am a software entrepreneur with a considerable amount of my assets in the stock market. I am wondering if you may know of any good websites where I can track how my individual stock purchase decisions are performing against a benchmark (say S&P 500).
As individual investors, we know that each and every buy/sell decision is an individual decision. So my goal is to easily understand how my decision to buy (for example) TSLA on 3/14/2018 fared, compared if I had just put the money straight into S&P 500 on 3/14/2018.
-
- Posts: 6993
- Joined: Mon Jan 03, 2011 8:40 am
Re: Comparing my performance against S&P 500
Seems you are quite the evidence based investor so why reinvent the wheel. Read the seminal articles (and the real last nail in the coffin) of active management. Beebower, Hood, and Brinson (BHB) wrote "Portfolio Determinants" or something like that. Then wrote a 10 year follow up article seemingly kicking Hood out and putting a guy named Singer in (BSB). The studies were based on looking at the LARGEST pension funds in the country (thinking they should/ do have access to the top money managers on the planet) and seeing how the previous 10 years of their returns were and what determined them. The found as a whole active management (alpha) via security selection (what you are asking) and market timing (likely based on some valuation metrics) gave a NEGATIVE return. 90%+ of the variability of returns were determined solely by asset allocation. Their follow up study showed the same thing.
SO...
IF you accept the studies were done correct. No real arguments of that exist as they were published in peer review journal ?JFA. Then if you STILL want to pursue active management you either think you are smarter then the Wall Street guys who are in charge of 100+ million dollar clients OR you are not evidence based and are overconfident in your ability (either are dangerous) and will result in a losers game.
Good luck.
SO...
IF you accept the studies were done correct. No real arguments of that exist as they were published in peer review journal ?JFA. Then if you STILL want to pursue active management you either think you are smarter then the Wall Street guys who are in charge of 100+ million dollar clients OR you are not evidence based and are overconfident in your ability (either are dangerous) and will result in a losers game.
Good luck.
"The stock market [fluctuation], therefore, is noise. A giant distraction from the business of investing.” |
-Jack Bogle
-
- Posts: 4801
- Joined: Sun Oct 22, 2017 2:06 pm
Re: Comparing my performance against S&P 500
portfoliovisualizer.com/backtest-portfolio
Re: Comparing my performance against S&P 500
Portfolio visualizer cannot do what the OP wants to do. At least right now it cannot. The backtesting only uses month-end prices.
-
- Posts: 4801
- Joined: Sun Oct 22, 2017 2:06 pm
Re: Comparing my performance against S&P 500
-
- Posts: 27
- Joined: Wed Oct 10, 2018 1:07 pm
Re: Comparing my performance against S&P 500
Month end prices are definitely not good enough. A lot can happen in one month. Ideally, I'm looking at near-real time (based on when TSLA was purchased). Worst case would be price of index at market close.HEDGEFUNDIE wrote: ↑Wed Oct 10, 2018 7:07 pmOP can let us know if month-end prices is not good enough.
-
- Posts: 27
- Joined: Wed Oct 10, 2018 1:07 pm
Re: Comparing my performance against S&P 500
I hear you on the "buy the index" vs "buy individual stocks" comment. Overall, I subscribe to buying the index. However, I do (and perhaps others here as well) buy and sell individual stocks. Just once, were you ever tempted?staythecourse wrote: ↑Wed Oct 10, 2018 6:18 pm Seems you are quite the evidence based investor so why reinvent the wheel. Read the seminal articles (and the real last nail in the coffin) of active management. Beebower, Hood, and Brinson (BHB) wrote "Portfolio Determinants" or something like that. Then wrote a 10 year follow up article seemingly kicking Hood out and putting a guy named Singer in (BSB). The studies were based on looking at the LARGEST pension funds in the country (thinking they should/ do have access to the top money managers on the planet) and seeing how the previous 10 years of their returns were and what determined them. The found as a whole active management (alpha) via security selection (what you are asking) and market timing (likely based on some valuation metrics) gave a NEGATIVE return. 90%+ of the variability of returns were determined solely by asset allocation. Their follow up study showed the same thing.
SO...
IF you accept the studies were done correct. No real arguments of that exist as they were published in peer review journal ?JFA. Then if you STILL want to pursue active management you either think you are smarter then the Wall Street guys who are in charge of 100+ million dollar clients OR you are not evidence based and are overconfident in your ability (either are dangerous) and will result in a losers game.
Good luck.
So that's really the end goal of this question -- to see if that one "slip" of buying an individual stock was worth it.
- happyisland
- Posts: 915
- Joined: Thu Oct 03, 2013 1:36 pm
- Location: nos baranca tan stima
Re: Comparing my performance against S&P 500
Thing is, even if it works out this time, it won't mean that it was a good idea. Don't confuse outcome with strategy.
Re: Comparing my performance against S&P 500
You could plug in a fake purchase of VFIAX (Vanguard S&P500) in the same dollar amount as your actual purchase and compare the two in a free M* account. You will have to update the fake amount for dividends each quarter.BobaTeaGood wrote: ↑Wed Oct 10, 2018 5:59 pm
Thanks for your reply. My goal is to compare a specific transaction vs some index. Comparing the performance of the overall fund (which includes cash, bonds, etc) is important too. I'm looking to create a website that can do this. Any interest in checking it out when it goes live?
-
- Posts: 6993
- Joined: Mon Jan 03, 2011 8:40 am
Re: Comparing my performance against S&P 500
Great question. I have thought about it 3-4 times. Looking back EACH of those times the decision I would have made would have given me at least a 300% gain.BobaTeaGood wrote: ↑Wed Oct 10, 2018 7:17 pmI hear you on the "buy the index" vs "buy individual stocks" comment. Overall, I subscribe to buying the index. However, I do (and perhaps others here as well) buy and sell individual stocks. Just once, were you ever tempted?staythecourse wrote: ↑Wed Oct 10, 2018 6:18 pm Seems you are quite the evidence based investor so why reinvent the wheel. Read the seminal articles (and the real last nail in the coffin) of active management. Beebower, Hood, and Brinson (BHB) wrote "Portfolio Determinants" or something like that. Then wrote a 10 year follow up article seemingly kicking Hood out and putting a guy named Singer in (BSB). The studies were based on looking at the LARGEST pension funds in the country (thinking they should/ do have access to the top money managers on the planet) and seeing how the previous 10 years of their returns were and what determined them. The found as a whole active management (alpha) via security selection (what you are asking) and market timing (likely based on some valuation metrics) gave a NEGATIVE return. 90%+ of the variability of returns were determined solely by asset allocation. Their follow up study showed the same thing.
SO...
IF you accept the studies were done correct. No real arguments of that exist as they were published in peer review journal ?JFA. Then if you STILL want to pursue active management you either think you are smarter then the Wall Street guys who are in charge of 100+ million dollar clients OR you are not evidence based and are overconfident in your ability (either are dangerous) and will result in a losers game.
Good luck.
So that's really the end goal of this question -- to see if that one "slip" of buying an individual stock was worth it.
The reason I never and will never do it is simply I just won't place a large enough bet from my portfolio to move the needle. At this point, to make a noticeable difference in my life I would have to make at least 100k+ bet on a single stock to really make a difference. For me, it wouldn't make much a difference. I will end up getting to where I want without taking unsystematic risks.
Now if I wasn't getting to where I needed to be financially that is a different story. Unlikely I would take lottery attempts like individual stock buying. I would probably make a larger attempt to either make MORE money in my current job, get a second job, start learning and buy rental real estate (same as getting a second job), etc...
Good luck.
"The stock market [fluctuation], therefore, is noise. A giant distraction from the business of investing.” |
-Jack Bogle