No. of Recommendations: 18
Hi all,

Here is a slightly tweaked version of my spreadsheet. The major change is that the range of data to be plotted should now be set automatically. What this results in is the data being plotted, even if it does not extend all the way back for 30 years. Previously in this situation, you would have to change the ending row for each plot by hand to get them to display.

While this spreadsheet would not serve Mike's needs with his weekly update of dozens of stocks, it does have accurate prices. Neither MoneyCentral or BigCharts has the split adjustment problems that Mike has noted for Yahoo. In addition, their data often extend further back than Yahoo's does, so companies with 30 years of trading will show the whole 30 years.

I'm trying to figure out how to do updated spreadsheets, adding in missing data from when it was last updated, without having to run the whole thing again. Also wanting to add in the last closing price so a comparison can be made using yesterday's price rather than the end of last month (kind of like what hildy just posted). Will post these as I figure out the macro coding and as time permits.

Print the post  



The 2009 BMW Method Conference has been cancelled, due to minimum attendance numbers not being met. We hope to continue the annual BMW Method Conference tradition next fall.

Learn about the first four conferences on the BMW Method Website.

The BMW Method FAQ

BMW Method Website
Annual Conference Videos and Other Resources & Services
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.
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
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.