Posted by philosoraptor on 4th of Jun 2011 at 06:23 pm
Matt, if you follow the URL link provided in the spreadsheet and
scroll down to the bottom of the first page, you will see that the
programmer has provided an additional spreadsheet download that
analyses
monthly data
for longer time periods - the screengrab example shows the Dow back
to 1958!
[Indeed, you have to click on this screengrab in order to
download the spreadsheet]
that's great you found that philo. Assuming I downloaded the
proper sheet (compare-to-historical3) I'm having trouble getting
the data. I thought it might be because Yahoo only has weekly data
for SPY from late Jan of '93 so I changed the formula in cell B2 to
=B3-18.3*365-12 which sets the data to
start on Feb 7 '93 but I'm still getting Value errors. Any ideas?
BTW in case anyone else is having a problem I was not able to run
Matt's URL for the spreadsheet in Chrome however it worked with
IE.
Matt, if you follow the
Very cool spreadsheet
Posted by philosoraptor on 4th of Jun 2011 at 06:23 pm
Matt, if you follow the URL link provided in the spreadsheet and scroll down to the bottom of the first page, you will see that the programmer has provided an additional spreadsheet download that analyses monthly data for longer time periods - the screengrab example shows the Dow back to 1958!
[Indeed, you have to click on this screengrab in order to download the spreadsheet]
http://www.gummy-stuff.org/historical-compare2.htm
that's great you found that
Posted by bkout3 on 5th of Jun 2011 at 03:27 pm
that's great you found that philo. Assuming I downloaded the proper sheet (compare-to-historical3) I'm having trouble getting the data. I thought it might be because Yahoo only has weekly data for SPY from late Jan of '93 so I changed the formula in cell B2 to =B3-18.3*365-12 which sets the data to start on Feb 7 '93 but I'm still getting Value errors. Any ideas? BTW in case anyone else is having a problem I was not able to run Matt's URL for the spreadsheet in Chrome however it worked with IE.
Just remembered -- Chrome downloads
Posted by bkout3 on 5th of Jun 2011 at 05:42 pm
Just remembered -- Chrome downloads into the "Downloads" folder in Documents -- still getiing used to that