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.http://personal.palouse.net/muellerj/FCExcel/BMWtemplateVer2_3.xlsWhile 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.gebin
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Market data provided by Interactive Data.
Company fundamental data provided by Morningstar. Earnings Estimates, Analyst Ra