Skip to main content
Message Font: Serif | Sans-Serif
 
No. of Recommendations: 1
I am sure there is a better way to do this. But what I did was simply find quotes for DJIA on the quarterly dates where I do a portfolio summary. (The last day of the month of the specified quarter).

You can go here to get historic quotes:

http://bigcharts.marketwatch.com/historical/

type in DJIA where it says "enter symbol"
enter a date like 3/28/2003 (the 30th was a Sunday)

And you get back 8,145

Alternatively, you can eyeball the values from bigcharts
http://www.bigcharts.com - choose a five or ten year span and just look with your eye and estimate.

Then type these values into your spreadsheet as a new row.

I normalized these values - I made a new row which is the value of the DJIA normalized to the first date of the portfolio. For example, if my portfolio was worth 80,000 on 3/28/2003 then I would apply a multiplication factor about 10, so it matched the value of my portfolio on this starting date. Then drag this multiplication across all cells (if you want help on how to do this ask) and it will show the value of the DJIA through time (without dividends) compared to your port performance.

This is most helpful when you are graphing it so you can see it in the context of the ups and downs of your port.
Print the post  

Announcements

What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.