Join Early Retirement Today
Reply
 
Thread Tools Display Modes
Re: DCA or one fell swoop?
Old 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? :
scrinch is offline   Reply With Quote
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?
Old 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.
astromeria is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 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.
gummy is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 08-16-2006, 05:51 PM   #24
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Ed_The_Gypsy's Avatar
 
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.
Ed_The_Gypsy is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 08-16-2006, 06:25 PM   #25
Moderator Emeritus
Rich_by_the_Bay's Avatar
 
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.
Rich_by_the_Bay is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 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.
scrinch is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 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.
gummy is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 08-17-2006, 07:24 PM   #28
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Ed_The_Gypsy's Avatar
 
Join Date: Dec 2004
Location: the City of Subdued Excitement
Posts: 5,588
Re: DCA or one fell swoop?

Quote:
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".
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.
Ed_The_Gypsy is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 08-17-2006, 07:41 PM   #29
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Ed_The_Gypsy's Avatar
 
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.
Ed_The_Gypsy is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 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?* *
scrinch is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 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
gummy is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 08-23-2006, 07:21 AM   #32
Moderator Emeritus
Rich_by_the_Bay's Avatar
 
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.
Rich_by_the_Bay is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 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
Meadbh is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 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?
gummy is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 08-23-2006, 10:04 AM   #35
Moderator Emeritus
Nords's Avatar
 
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.
Nords is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 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.
sgeeeee is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 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
mathjak107 is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 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.
sgeeeee is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 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
mathjak107 is offline   Reply With Quote
Re: DCA or one fell swoop?
Old 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.

mathjak107 is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
DCA withdrawals WM FIRE and Money 22 05-03-2008 09:09 AM
Lump sum to invest, DCA in or go lump? Olav23 FIRE and Money 4 03-03-2007 03:22 PM
Promising cancer treatment or hoax? The "other" DCA samclem Health and Early Retirement 1 02-12-2007 10:12 AM
DCA into Retirement? wabmester FIRE and Money 4 10-06-2004 09:55 PM

» Quick Links

 
All times are GMT -6. The time now is 11:41 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.