DATAQUEST (2024)

I am a strong believer in the advantages of DCA (dollar-cost-averaging).I recommend it to anyone making a substantial move from cash to mutualstock funds (unless they fancy themselves to be market-timers). In particular,if you have recently received an inheritance that increases your worthby over 50%, you should use DCA instead of putting it all in at once. Ifyou have a large amount of money that you know you really ought to putinto the stock market but you can't bring yourself to do it because youare afraid the market is too high, you should use DCA for 12 months insteadof waiting.

However, I find that using DCA for any period longer than 12 months isa bad strategy. It may even be a good idea to DCA over a period as shortas 6 months; the choice depends on an individual's balance between riskand return (6 months is a little more risky and a little more profitablein the long run).

I compare two alternative strategies: LUMP-SUM, where you move a substantialamount of money from your money market account to a mutual stock fund today,and DCA-N, where you move one Nth of that substantial amount at the beginningof each of N months starting today. I give historical data to support myconclusions, and I present a full analysis for DCA-6, DCA-12, DCA-18, DCA-24,and DCA-36 in the appendix.

The Logic

DCA is not for people who consider themselves competent market-timers.Market-timers lump-sum in at whatever time they judge that the market isvery likely to go up in the near future. And they get back out of the marketwhen they judge that the market is very likely to go down in the near future.The DCA choice is for people who fear that the market may drop drasticallyat any time, but do not feel competent to judge whether that is more orless likely now than at some other time.

I feel that the purpose of DCA is to avoid the damage from a substantialdrop happening in the first few months after a lump-sum investment. 6-monthDCA works fine if the drop happens in the first two or three months, becausehalf of the money is invested at a lower cost. But DCA-6 is not effectiveif the drop happens in the fifth or sixth month. 12-month DCA gives goodresults for drops that happen in the first 7 or 8 months. My feeling isthat, beyond that point, there is generally no substantial problem anyway,because when a drop does not happen for say 8 months, the market usuallyrises enough in those first 8 months that the net result is a gain.

An additional point is that, if you use say a 24-month DCA period in aparticular instance and it is successful, i.e., the stock market fallssignificantly in the first 6 months, then the loss is more often than notmade up in the following 6 months. But that means that the last half ofthe money is being DCAd into the market at ever high prices. The operationis a success but the patient dies. Your caution is vindicated but you loseanyway. Logically, then, DCA should not be used over periods of 2 or 3years, not even 18 months. A DCA period between 6 and 12 months is probablybest.

Historical Support for DCA-6 Versus DCA-36

But all of the above is theoretical, a subjective opinion based on vagueconcepts of how stock markets behave. It is helpful to look at some concretehistorical data to see how various periods would have turned out. For this,I need a well-defined process for investing. I implement e.g. DCA-12 asfollows: Move 1/12 of the assets into the stock market on the first dayof the first month and let the rest stay in the money market. One monthlater, move 1/11 of the remaining money market balance into the stock market,etc., for 12 months.

Equivalently: Divide the initial amount into N equal parts. Move the firstpart in immediately. Let the second part sit in the money-market for onemonth and then move it plus its interest into the stock market. Let thethird part sit in the money-market for two months and then move it plusits interest into the stock market; etc. Thus the amounts moved in aresteadily increasing in nominal dollars, but they are equal in time-value-adjustedterms.

Question: How do we measure the RISK against which we are insuring by DCA?I figure that the main thing to avoid is lump-summing an amount into thestock market and finding out some months later that its value is LESS thanwe started with. Normally, if we move $10,000 into the stock market ina lump-sum, then we hope to have $11,000 or $12,000 one year later. Ifwe have $10,500, that isn't bad; we would have had the same in a moneymarket. If we have just $10,000, that is disappointing and irritating,but we knew that stock investing wasn't a sure thing. Panic, depression,anger, and regret set in only if we actually have significantly less innominal dollar terms than we started with.

For DCA-36, I looked at the 493 rolling 36-month periods within the 44years 1953-1996. I calculated that each use of DCA-36 cost on average 7.40%of total assets compared with lump-summing (computed using the geometricmean, as is normal for computing returns). That is not 7.40% per year for3 years, but 7.40% for the one decision to use DCA-36 instead of lump-summing.

But the cost is not the only consideration. We have to consider the RISKof severe loss. Note: Stock market returns in the following are based ontotal returns of the S&P500 including reinvested dividends. Money marketreturns are estimated using 3-month treasuries, to adjust for interestearned on the money not yet moved into the stock market using DCA. Thestock market earned slightly over 5% more per year on the average in this44-year period; the average dollar in DCA-36 is kept out of the marketfor 17.5 months, almost 1.5 years, so of course lump-summing beats DCA-36by roughly 1.5 times 5%.

Unfortunately, there is no really good single number to measure the risk.We all know how unsatisfactory the standard deviation is as a measure ofthe risk involved in investing in stocks. So the following provides enoughstatistics to let you make your own decision as to the risks and rewardsand costs involved in DCA.

There were only 30 of those 493 DCA-36 cases where a lump-sum had lessat the end of 36 months than at the beginning. We want to ameliorate those30 cases. But it doesn't help to DCA in those disastrous cases if DCA doesn'tmake it BETTER. So, I set the criterion of effectiveness that DCA shouldproduce results at least 5% better than lump-summing in cases where lump-summingloses money, otherwise it does not offer much protection.

In the 30 cases where lump-summing lost money over 36 months, DCA-36 cameout more than 5% better than lump-summing in only 16. Those 30 are easyto categorize: 7 began on 5/1/67 through 11/1/67; 1 of the 30 began on12/1/68; The other 22 began on 5/1/71 through 2/1/73 (all periods starton the first-of-the-month). Note that the S&P500 lost 25.2% in the3 months July-Sept 1974.

In the 22 cases involving 1974 where lump-summing lost money, DCA-36 didn'thelp much for the first 8 of those periods (it was WORSE in 6 cases, 0.2%and 2.1% better in 2 cases), came out 7.7% to 18.4% better for the next8 periods, and came out 20.8% to 27.5% better than lump-summing for thelast 6 of the 22 periods.

That is not a very effective insurance policy, considering the premium:an average loss of 7.40% of total assets for each use of DCA-36 insteadof lump-summing. 14 of the 16 "effective" cases included thesummer of 1974; the other two began 10/67 when lump-summing lost only 3.33%and 12/68 when lump-summing lost only 3.97%. In other words, DCA-36 isa moderately effective way of guarding against a re-occurrence of the summerof 1974 and is pretty much useless otherwise.

But the main problem is that most of the time DCA-36 doesn't even do whatpeople expect of a DCA strategy: If you DCA-36 and the market tanks inthe first 3 or 6 months, sure, you get to gloat that the lump-summer tooka 15% loss and you didn't. Then for the next 30 months, you gradually feedpiddling little amounts into the market while the lump-summer is makingmoney hand-over-fist. Then when you are completely in, the market tanksagain. Is that insurance???

Matters are quite different for DCA-6. I looked at the 523 rolling 6-monthperiods within the 44 years 1953-1996. Lump-summing came out only 1.11%better on average than DCA-6 (per use of DCA-6, not per year). DCA-6 cameout better than lump-summing in 199 of the 523 cases. But that is not thepoint. We have to consider the RISK of severe loss.

There were 143 cases where a lump-summer had less at the end of 6 monthsthan at the beginning. We want to ameliorate those 143 cases. In 122 ofthem, DCA-6 came out better than lump-summing. There were only 56 of the523 cases in which DCA-6 came out more than 5% better than lump-summing,but 55 of those were cases where lump-summing lost money. So DCA-6 helpsmost where it is most needed.

Of the 32 cases where lump-summing lost over 10%, DCA-6 did better in 30of them; in fact, in 26 of them, DCA-6 did more than 5% better. And ineach of the 3 cases where lump-summing lost over 20%, DCA-6 did 6 to 11%better.

Conclusions

DCA-6 offers some significant protection against lump-summing into thestock market and losing more than 10% in the next 6 months, and it is ata small cost (1.11%). However, since there were only 15 cases in whichDCA-6 gave at least 10% more than lump-summing, and in the best case gavejust 19.9% more, you are in effect paying a 1.11% premium for an insurancepolicy that will only pay off well (10 to 20%) 3% of the time. Those arenot really great odds.

The payoff is higher for a 12-month period of DCA. Lump-summing lost moneyin 114 12-month periods, and DCA-12 beat lump-summing in 100 of them, 64by more than 5%. DCA-12 sometimes beat lump-summing by over 20%. Therewere 40 12-month periods where lump-summing lost over 10%; DCA-12 beatlump-summing in 39 of those 40. The only drawback is that each use of DCA-12costs you an average of 2.50% of what you would have if you lump-summed;in general, you come out ahead when lump-summing loses, but gain less whenlump-summing wins. But that is what you expect when you dollar-cost-averageanyway.

Since I defined effectiveness as meaning that DCA beats lump-summing bymore than 5% in those instances where lump-summing loses money, we have:DCA-6 is effective in 55 of 143 cases; DCA-12 is effective in 64 of 114cases; DCA-18 is effective in 46 of 77 cases; DCA-24 is effective in 31of 45 cases; and DCA-36 is effective in 16 of 30 cases. Thus DCA-12 clearlyproduces the highest number of effective cases, but DCA-6 costs half asmuch and produces the second-highest number of effective cases.

NOTE 1: These results imply that the best timing for people who DCA quarterlyis that the last of N equal quarterly payments should be made 6 to 12 monthsafter the first. Thus there should be 3 to 5 equal quarterly payments.NOTE 2: If you DCA into a stock fund with a few hundred dollars a monthfrom your paycheck over a period of many years, because that is all youcan afford to save, that is DCA perforce and not something that the aboveanalysis contra-indicates. Personally, I prefer to save it up in a short-termbond fund that I empty once each 6 months, because it simplifies my book-keeping;but I know that slightly reduces my returns vis-a-vis DCA. NOTE 3: DCAis only valuable for moving from cash or bonds into stocks. If you aremoving from one stock investment to another, DCA is pointless, becausethe chances of moving in to a market top are the same as the chances ofmoving out from a market top, so the risks balance out. On the other hand,it doesn't hurt either.

My conclusion is that DCA for 6 to 12 months is the most that one shoulduse, and then only if moving more than 5% of your total assets (since eventhe worst case would cut your overall total returns by only 1% or so).If you are shifting 30% or more of your total assets from cash to stock,you could take up to but no more than 18 months; this once-in-a-lifetimesort of situation merits overly-excessive caution. But I provide the databelow on which you can base your own opinion.

Appendix (uniform presentation for 5 different timeperiods)

DCA-6 beat lump-summing 199 of the 523 instances; the lump-summer gained1.11% on average. Of the 143 instances where lump-summing lost money, DCA-6beat lump-summing 122 times, 55 of them by at least 5%, and 15 of themby at least 10%. Of the 32 instances where lump-summing lost more than10%, DCA-6 beat lump-summing 30 times, 26 of them by at least 5%, and 11of them by at least 10%. Of the 3 instances where lump-summing lost over20%, DCA-6 did 6.0% (1/62), 9.0% (3/74), and 11.2% (4/74) better. The 6biggest relative gains for DCA-6 were 13.6% (5/74), 13.6% (6/74), 15.1%(7/74), 13.5% (8/87), 19.3% (9/87), and 19.7% (10/87) more than lump-summing.

DCA-12 beat lump-summing 175 of the 517 instances; the lump-summer gained2.50% on average. Of the 114 instances where lump-summing lost money, DCA-12beat lump-summing 100 times, 64 of them by at least 5%, and 30 of themby at least 10%. Of the 40 instances where lump-summing lost more than10%, DCA-12 beat lump-summing 39 times, 34 of them by at least 5%, and20 of them by at least 10%. Of the 8 instances where lump-summing lostmore than 20%, DCA-12 beat lump-summing every time, all of them by morethan 5%, and 7 of them by more than 10%. The 6 biggest relative gains forDCA-12 were 20.9% (11/73), 18.6% (2/74), 19.9% (3/74), 18.7% (4/74), 20.1%(9/87), and 19.4% (10/87) more than lump-summing.

DCA-18 beat lump-summing 170 of the 511 instances; the lump-summer gained3.84% on average. Of the 77 instances where lump-summing lost money, DCA-18beat lump-summing 69 times, 46 of them by at least 5%, and 33 of them byat least 10%. Of the 27 instances where lump-summing lost more than 10%,DCA-18 beat lump-summing all 27 times, 26 of them by at least 5%, and 22of them by at least 10%. Of the 12 instances where lump-summing lost morethan 20%, DCA-18 beat lump-summing every time, all of them by more than12%. The 6 biggest relative gains for DCA-18 were 22.5% (8/73), 21.0% (9/73),24.7% (10/73), 25.4% (11/73), 18.2% (9/87), and 19.7% (10/87) more thanlump-summing. DCA-24 beat lump-summing 158 of the 505 instances; the lump-summergained 5.06% on average. Of the 45 instances where lump-summing lost money,DCA-24 beat lump-summing 39 times, 31 of them by at least 5%, and 21 ofthem by at least 10%. Of the 24 instances where lump-summing lost morethan 10%, DCA-24 beat lump-summing every time, 21 of them by at least 5%,and 15 of them by at least 10%. Of the 9 instances where lump-summing lostmore than 20%, DCA-24 beat lump-summing every time, all of them by at least5%, and 7 of them by at least 10%. The 6 biggest relative gains for DCA-24were 24.0% (1/73), 24.4% (2/73), 23.7% (4/73), 23.2% (8/73), 24.1% (10/73),and 24.5% (11/73) more than lump-summing. 9/87 had a gain of 17.6% and10/87 had a gain of 15.4% more than lump-summing.

DCA-36 beat lump-summing 127 of the 493 instances; the lump-summer gained7.40% on average. Of the 30 instances where lump-summing lost money, DCA-36beat lump-summing 22 times, 16 of them by at least 5%, and 14 of them byat least 10%. Of the 14 instances where lump-summing lost more than 10%,DCA-36 beat lump-summing 10 times, 9 of them by at least 5%, and 8 of themby at least 10%. Of the 2 instances where lump-summing lost more than 20%,DCA-36 beat lump-summing only once, by 7.7%. The 6 biggest relative gainsfor DCA-36 were 22.2%, 26.2%, 27.5%, 26.6%, 24.1%, and 24.1% more thanlump-summing for the 6 periods beginning 11/72 through 4/73, respectively.9/87 had a gain of 13.7% and 10/87 had a gain of 11.6% more than lump-summing.

Alternative Criterion

We could use an alternative definition of effectiveness based on the amountof protection provided in the worst 50 cases (out of the 500 or so, thusroughly 10% of cases). Here are the results:

DCA-06 beat lump-sum 46 times, 34 by 5%, 11 by 10%. Lump-sum lost over7.3% 50 times.

DCA-12 beat lump-sum 48 times, 40 by 5%, 22 by 10%. Lump-sum lost over8.2% 50 times. DCA-18 beat lump-sum 47 times, 34 by 5%, 26 by 10%. Lump-sumlost over 3.6% 50 times.

DCA-24 beat lump-sum 41 times, 33 by 5%, 22 by 10%. Lump-sum gainedunder 1.2% 50 times.

DATAQUEST (2024)

FAQs

Are Dataquest courses worth it? ›

The flexibility can be helpful to learners who may be short on time and unable to complete a course shortly after starting it. So, if your question is, “Is Dataquest worth it in terms of career development?”, the answer is definitely yes.

Can I get Dataquest for free? ›

Our free plan gives you access to the first three lessons in each path and basic technical support, while our premium plan unlocks everything on the platform. You get unlimited access to all of our learning paths, downloadable datasets, and over 700 practice problems and guided projects.

How much is Dataquest per month? ›

Dataquest Courses and Curriculum

Several Dataquest courses are free, so you can have a smooth introduction to the data science world. However, the Dataquest online platform also offers a paid subscription at $49 per month, which provides students with additional resources and a certificate of completion.

What does Dataquest do? ›

Dataquest's project-based learning paths give learners real world experience in Python, SQL, Excel, PowerBI, Tableau, data analysis, and machine learning.

Is Dataquest enough to get a job? ›

Can Dataquest Help You Get a Data Analyst/ Data Scientist Job? Yes, Dataquest can help you get a data analyst job or a data scientist job, thanks to its wide variety of learning paths that provide students with the data analysis skills needed for a data analytics career.

Does Dataquest give a certificate? ›

Yes, Dataquest gives certificates. The certificates are offered after successful completion of an online course or a path.

How long does it take to finish Dataquest? ›

Data Analyst with Python takes 240 hours to complete all 24 courses on Python, data visualization, and SQL. Data Engineer runs for 155 hours with 19 courses covering Python, time/space complexity, and data pipelines. Business Analyst is the newest path and takes 161 hours to complete.

Are DataCamp courses free? ›

DataCamp Classrooms is 100% free for educators and their students. Once you successfully apply for Classrooms, you gain free access for an entire semester (six months, then you are allowed to re-apply) to DataCamp's 400+ course curriculum, certifications, and more.

Is Dataquest Ltd legit? ›

Data Quest is a licensed, fully-insured (General Liability and Worker's Compensation coverage) and bonded private investigations agency and an active member of the MSPA-NA, the trade association representing the customer experience industry throughout North America.

What is the difference between Dataquest and DataCamp? ›

The delivery is different – Dataquest uses project-based learning from the start, while Datacamp starts with videos and fill-in-the-blank assessments before moving onto project work. Dataquest offers access to its active Slack community with every subscription level.

How much is a Dataquest lifetime subscription? ›

DataCamp vs. Dataquest
OfferingsDataCampDataquest
CertificatesShareable certificatesShareable certificates
Free coursesFree introductory coursesFree introductory courses
Premium Membership$300 paid annually (the platform offers discounts)$49 per month, $399 annually, $1,176 lifetime (the platform offers discounts)
5 more rows

What is the difference between Dataquest and 365 data science? ›

Practical Case Studies. Dataquest and 365 Data Science both focus extensively on practical examples. The main difference is that many of the challenges and tasks by Dataquest are not centered around business applications.

Is Dataquest lifetime plan worth it? ›

Yes, the Dataquest subscription is worth it. If you want to gain data-related skills and improve your career prospects, signing up for the Dataquest subscription plan will help you reach your career goals faster. Dataquest will help you switch your career or find a job you enjoy.

Which one is better, Codecademy or DataCamp? ›

📌 Our Takeaway: Codecademy offers a great value if you're on a budget or want skills courses with more comprehensive content. Datacamp is more expensive, but offers more detailed, nitty-gritty skills courses as well as a wider variety of skill and career paths.

Does Dataquest have videos? ›

Efficient Learning

The largest expense when it comes to learning is time. Dataquest courses maximize learning time by eliminating videos, setup, and fill- in-the-blank exercises.

Is it worth doing a data analytics course? ›

One of the best things about data analytics is that it offers you an opportunity to work with some industry giants. For instance, you may end up working with a global brand like Oracle, Microsoft, or IBM. Here are some other premium organisations and companies that actively hire data analyst professionals.

Can an IBM certificate get you a job? ›

IBM Data Science Professional Certificate is definately one of the top-ranked data sciences certificates While your job prospects depend on various factors, including location, IBM Data Sciences Professional Certificate exhibits that you are job ready. It reflects your skills as a 'Data Scientist.

Is paid course worth it? ›

More flexibility and added benefits.

There's a lot to think about and consider when it comes to paid courses vs free courses. Which one to pick? But you get what you pay for. If you want to master your skills and excel in your career, investing in a paid and recognised course is the best way.

Is it worth doing a data science course? ›

While earning a master's degree in data science comes with certain costs—in terms of both tuition and time—it can be a worthwhile investment when you're interested in furthering your abilities to work with and parse data.

Top Articles
Bearer Authentication
Restricted Key System – TopLock
Cranes For Sale in United States| IronPlanet
Form V/Legends
Tabc On The Fly Final Exam Answers
FFXIV Immortal Flames Hunting Log Guide
Craigslist Pet Phoenix
Crime Scene Photos West Memphis Three
Swimgs Yung Wong Travels Sophie Koch Hits 3 Tabs Winnie The Pooh Halloween Bob The Builder Christmas Springs Cow Dog Pig Hollywood Studios Beach House Flying Fun Hot Air Balloons, Riding Lessons And Bikes Pack Both Up Away The Alpha Baa Baa Twinkle
litter - tłumaczenie słowa – słownik angielsko-polski Ling.pl
Erin Kate Dolan Twitter
Ssefth1203
The Weather Channel Facebook
Nonuclub
A Guide to Common New England Home Styles
Michaels W2 Online
Https://Store-Kronos.kohls.com/Wfc
Scenes from Paradise: Where to Visit Filming Locations Around the World - Paradise
Google Flights Missoula
10-Day Weather Forecast for Santa Cruz, CA - The Weather Channel | weather.com
How Much Is Tay Ks Bail
Grayling Purnell Net Worth
Www Craigslist Milwaukee Wi
1773X To
Days Until Oct 8
Shopmonsterus Reviews
Rs3 Eldritch Crossbow
Ford F-350 Models Trim Levels and Packages
Mtr-18W120S150-Ul
Jayah And Kimora Phone Number
Low Tide In Twilight Ch 52
14 Top-Rated Attractions & Things to Do in Medford, OR
Dashboard Unt
Restaurants In Shelby Montana
Nearest Ups Ground Drop Off
Grave Digger Wynncraft
Nikki Catsouras: The Tragic Story Behind The Face And Body Images
Rush County Busted Newspaper
Eaccess Kankakee
Walter King Tut Johnson Sentenced
Google Jobs Denver
Ludvigsen Mortuary Fremont Nebraska
Bartow Qpublic
Improving curriculum alignment and achieving learning goals by making the curriculum visible | Semantic Scholar
Dyi Urban Dictionary
Unit 11 Homework 3 Area Of Composite Figures
Keci News
552 Bus Schedule To Atlantic City
Treatise On Jewelcrafting
Bones And All Showtimes Near Emagine Canton
The Ultimate Guide To 5 Movierulz. Com: Exploring The World Of Online Movies
Latest Posts
Article information

Author: Horacio Brakus JD

Last Updated:

Views: 6527

Rating: 4 / 5 (51 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Horacio Brakus JD

Birthday: 1999-08-21

Address: Apt. 524 43384 Minnie Prairie, South Edda, MA 62804

Phone: +5931039998219

Job: Sales Strategist

Hobby: Sculling, Kitesurfing, Orienteering, Painting, Computer programming, Creative writing, Scuba diving

Introduction: My name is Horacio Brakus JD, I am a lively, splendid, jolly, vivacious, vast, cheerful, agreeable person who loves writing and wants to share my knowledge and understanding with you.