|
|
Re: DCA or one fell swoop?
08-16-2006, 06:05 AM
|
#21
|
Thinks s/he gets paid by the post
Join Date: Apr 2006
Location: North Bay
Posts: 1,246
|
Re: DCA or one fell swoop?
The market might go up. The market might go down. It might go sideways. There are too many fun things to do in this world to worry too long over whether to lump sum it or DCA it. I repeat my advice...lump sum it using whatever you think is about the right asset allocation, and then don't look at it again until the "I told you so" statute of limitations has expired within your investing conscience.
Easy for me to say, huh? :
|
|
|
|
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!
Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!
You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!
|
Re: DCA or one fell swoop?
08-16-2006, 06:31 AM
|
#22
|
Thinks s/he gets paid by the post
Join Date: Aug 2005
Posts: 1,375
|
Re: DCA or one fell swoop?
I was glad I was in the market yesterday Reminded me of the good old days <I had a typo: gold old days!>...a few months ago. But I rebalanced a little out of small cap.
__________________
You can't always get what you want, but if you try sometimes, you might find you get what you need.
|
|
|
Re: DCA or one fell swoop?
08-16-2006, 07:23 AM
|
#23
|
Dryer sheet aficionado
Join Date: Oct 2003
Posts: 29
|
Re: DCA or one fell swoop?
There's a fun spreadsheet:
http://www.gummy-stuff.org/Excel/DCA-stuff.xls
It's described here, at the bottom ... sort of:
http://www.gummy-stuff.org/DCA_for_masochists.htm
You click a button and get 12 consecutive months of S&P500 returns (selected from the returns for year 1928 to year 2001) and it compares your final portfolio with 12 equal monthly DCA instalments or all-at-once.
You can also ask for 1000 such scenarios, to see how often all-at-once wins.
|
|
|
Re: DCA or one fell swoop?
08-16-2006, 05:51 PM
|
#24
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Dec 2004
Location: the City of Subdued Excitement
Posts: 5,588
|
Re: DCA or one fell swoop?
gummy!
Nice to hear from you again!
I learned a lot from using your spreadsheets and reading your tutorials.
You used to have tutorials on how to make spreadsheets like yours, but the links got broken. Do you know if those links ever got restored?
Thanks again,
Ed
__________________
I have outlived most of the people I don't like and I am working on the rest.
|
|
|
Re: DCA or one fell swoop?
08-16-2006, 06:25 PM
|
#25
|
Moderator Emeritus
Join Date: Feb 2006
Location: San Francisco
Posts: 8,827
|
Re: DCA or one fell swoop?
Quote:
Originally Posted by gummy
There's a fun spreadsheet:
|
Thanks very much. I'll check them out.
I'd like to echo the sentiments of other posters that I enjoy your presence here as well as your own site. This place can get a little unruly at times, but I am glad to see you are still contributing.
__________________
Rich
San Francisco Area
ESR'd March 2010. FIRE'd January 2011.
As if you didn't know..If the above message contains medical content, it's NOT intended as advice, and may not be accurate, applicable or sufficient. Don't rely on it for any purpose. Consult your own doctor for all medical advice.
|
|
|
Re: DCA or one fell swoop?
08-17-2006, 02:34 AM
|
#26
|
Thinks s/he gets paid by the post
Join Date: Apr 2006
Location: North Bay
Posts: 1,246
|
Re: DCA or one fell swoop?
Gummy, nice spreadsheet. Do you have a simple generic VB routine that can be applied to other spreadsheets to collect the MC results? I've never bothered to learn enough about VB to write a MC routine.
|
|
|
Re: DCA or one fell swoop?
08-17-2006, 11:41 AM
|
#27
|
Dryer sheet aficionado
Join Date: Oct 2003
Posts: 29
|
Re: DCA or one fell swoop?
Ed:
There's some stuff on charting, here:
http://www.gummy-stuff.org/Excel_charts.htm
The spreadsheet is here (somewhere):
http://www.gummy-stuff.org/Excel/
Probably the ones that begin with "Excel".
scrinch:
The spreadsheet has monthly S&P data from 1928 to 2001 in columns A & B.
If'n y'all got your own data, you can paste 'em there.
Come to think of it, maybe I can fiddle to allow you to select a portfolio, something like this:
http://www.gummy-stuff.org/asset-correlation.htm
where you pick any four assets (provided Yahoo has the data), download and select allocations then do the DCA vs All-at-once thing with that portfolio.
I'll play with that when I get a chance.
|
|
|
Re: DCA or one fell swoop?
08-17-2006, 07:24 PM
|
#28
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Dec 2004
Location: the City of Subdued Excitement
Posts: 5,588
|
Re: DCA or one fell swoop?
Quote:
Merci beaucoup, mon ami!
[I forget. Are there commas in French?]
Quote:
scrinch:
The spreadsheet has monthly S&P data from 1928 to 2001 in columns A & B.
If'n y'all got your own data, you can paste 'em there.
|
Scrinch, how far back does the Scrinch 500 go?
__________________
I have outlived most of the people I don't like and I am working on the rest.
|
|
|
Re: DCA or one fell swoop?
08-17-2006, 07:41 PM
|
#29
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Dec 2004
Location: the City of Subdued Excitement
Posts: 5,588
|
Re: DCA or one fell swoop?
gummy,
The tutorial link was live again! Thanks very much!
Ed
__________________
I have outlived most of the people I don't like and I am working on the rest.
|
|
|
Re: DCA or one fell swoop?
08-17-2006, 10:18 PM
|
#30
|
Thinks s/he gets paid by the post
Join Date: Apr 2006
Location: North Bay
Posts: 1,246
|
Re: DCA or one fell swoop?
Quote:
Scrinch, how far back does the Scrinch 500 go?*
|
I was asking about a Visual Basic routine for Monte Carlo simulation in completely different Excel models, not for modeling DCA using other economic data.* As far as the Scrinch500, it goes back to 334 B.C. or so.* Why do you ask?* *
|
|
|
Re: DCA or one fell swoop?
08-23-2006, 07:00 AM
|
#31
|
Dryer sheet aficionado
Join Date: Oct 2003
Posts: 29
|
Re: DCA or one fell swoop?
Finally got around to doing that DCA or All-at-once stuff, here:
http://www.gummy-stuff.org/DCA-all-at-once.htm
You select an allocation of four assets and download a bunch of monthly returns and see which ritual would give the better result:
$12K invested All-at-once
or
$1K per month for 12 months.
It's great fun to play with
|
|
|
Re: DCA or one fell swoop?
08-23-2006, 07:21 AM
|
#32
|
Moderator Emeritus
Join Date: Feb 2006
Location: San Francisco
Posts: 8,827
|
Re: DCA or one fell swoop?
Quote:
Originally Posted by gummy
Finally got around to doing that DCA or All-at-once stuff, here:
http://www.gummy-stuff.org/DCA-all-at-once.htm
You select an allocation of four assets and download a bunch of monthly returns and see which ritual would give the better result:
$12K invested All-at-once
or
$1K per month for 12 months.
It's great fun to play with
|
Great way of looking at this question.
I'll have to play with different asset allocations, but it is surprising to me how all-at-once dominates the few scenarios I ran. I guess it's not surprising in retrospect: market's up more often than it's down.
Thanks for doing this.
__________________
Rich
San Francisco Area
ESR'd March 2010. FIRE'd January 2011.
As if you didn't know..If the above message contains medical content, it's NOT intended as advice, and may not be accurate, applicable or sufficient. Don't rely on it for any purpose. Consult your own doctor for all medical advice.
|
|
|
Re: DCA or one fell swoop?
08-23-2006, 08:37 AM
|
#33
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jul 2006
Posts: 11,401
|
Re: DCA or one fell swoop?
Time in the markets is the key. Hence it's not surprising that the "all at once" option is more likely to be successful. DCA is a useful strategy to use when investment is dependent on cash flow that dribbles in over the year.
Meadbh
|
|
|
Re: DCA or one fell swoop?
08-23-2006, 09:17 AM
|
#34
|
Dryer sheet aficionado
Join Date: Oct 2003
Posts: 29
|
Re: DCA or one fell swoop?
Quote:
I guess it's not surprising in retrospect: market's up more often than it's down.
|
That's what I would have said, but (of course) it depends upon whether the increases are bigger than the decreases.
Anyway, I decided to test this commonly held belief, here:
http://www.gummy-stuff.org/stocks-up-down.htm
Interesting, eh?
|
|
|
Re: DCA or one fell swoop?
08-23-2006, 10:04 AM
|
#35
|
Moderator Emeritus
Join Date: Dec 2002
Location: Oahu
Posts: 26,856
|
Re: DCA or one fell swoop?
Quote:
Originally Posted by gummy
Interesting, eh?
|
Ooh, yeah. Answers an important question, too.
Nice to see you posting here again Gummy!
__________________
*
Co-author (with my daughter) of “Raising Your Money-Savvy Family For Next Generation Financial Independence.”
Author of the book written on E-R.org: "The Military Guide to Financial Independence and Retirement."
I don't spend much time here— please send a PM.
|
|
|
Re: DCA or one fell swoop?
08-23-2006, 10:37 AM
|
#36
|
Thinks s/he gets paid by the post
Join Date: Feb 2003
Location: Mesa
Posts: 3,588
|
Re: DCA or one fell swoop?
DCA vs lump-sum decisions or more of a risk-return decision.
Lump-sum gives you the highest probability of maximum return, but also a higher probability of maximum loss. DCA smoothes that out.
|
|
|
Re: DCA or one fell swoop?
08-23-2006, 04:14 PM
|
#37
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jul 2005
Posts: 6,115
|
Re: DCA or one fell swoop?
your right about the rewards but im not so sure about the loss being greater...seems to me with 67% per cent more up than down years the dca may cut your gains more than they would cut your losses
|
|
|
Re: DCA or one fell swoop?
08-23-2006, 06:30 PM
|
#38
|
Thinks s/he gets paid by the post
Join Date: Feb 2003
Location: Mesa
Posts: 3,588
|
Re: DCA or one fell swoop?
Quote:
Originally Posted by mathjak107
your right about the rewards but im not so sure about the loss being greater...seems to me with 67% per cent more up than down years the dca may cut your gains more than they would cut your losses
|
If the security does go down, there will be a day when it reaches the highest price. If you lump sum on that day, you lose the maximum you can loose. If you DCA, you may still lose, but you lose less since some of the security is purchased at a lower cost. You can't lose as much if you DCA as it is possible to lose if you happen to invest on the worst possible day during a period.
|
|
|
Re: DCA or one fell swoop?
08-24-2006, 01:50 AM
|
#39
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jul 2005
Posts: 6,115
|
Re: DCA or one fell swoop?
statistically it would be very hard if not close to impossible to invest on the worst days only..especially when the deck is stacked against you....there have been quite a few studies done to evaluate the effectivness of dca assuming of course you have a choice of lump summing it in or dca....looking at my own portfolio track record in the last 19 years my porfolio was up 15 out of the 19 years....the odds of getting a better deal and buying lower on dips putting a little in each time say would have actually had you buying in higher and higher.... of course like monday morning quarterbacking its easy to select a few time frames where dca would pan out better but statistically its very hard to catch those moments....like selling tech before the bubble burst ,collecting interest from bonds and jumping back into the markets before the rise again...looks great on paper but near impossible to pull off successfuly
|
|
|
Re: DCA or one fell swoop?
08-24-2006, 02:42 AM
|
#40
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jul 2005
Posts: 6,115
|
Re: DCA or one fell swoop?
interesting reading:from at the dogberry patch site:
Does Dollar Cost Averaging Work?
Say you decided to put $4,000 into a Roth IRA for yourself and your spouse. Would it be smarter to dump the $8,000 in as a lump sum or would you be better off dividing it up in some fashion and for example put in $1000 a month over 8 months? The thinking behind splitting up the investment is that if the market is going up and down over the course of the year you have a good chance of buying some stocks at the drops as well as minimizing the chance that if you dropped the $8,000, today's price would turn out to be the highest for the whole year.
There is an interesting article at the moneychimp regarding dollar cost averaging a large sum of money into the stock market vs just dumping the whole amount in. He has a calculator in the article that you can pick the month and year you would have started and see if the money would have done better as a lump sum investment or spread out over a year using historical returns.
The moneychimp article says that dollar cost averaging will loose 2 out of 3 times according to the calculator.
Of course, dollar cost averaging will win if your start date falls right before a dramatic crash (like October 1987) or at the start of an overall 12 month slump (like most of 2000). But unless you can predict these downturns ahead of time, you have no scientific reason to believe that dollar cost averaging will give you an advantage.
I really liked his closing paragraph where he wonders why it is then that so many people persist in believing that dollar cost averaging is better. His answer:
Maybe because it has a psychological appeal: if the market dips, people will be happy because DCA will be saving them money; and if the market goes up, people will be happy regardless.
|
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|