Skip to main content
No. of Recommendations: 0
Thanks for your help with this, Robbie, Elan and the others. I had actually been able to get the adjusted closing prices back to the beginning of 2015 by array-entering Randy Harmelink's = smfGetYahooHistory(Ticker, DateFirst, DateLast, "d", "c", 0). However, I've been unable to get any earlier data, and GTR1 also only returned data back to the beginning of 2015. I suppose it all comes from Yahoo, and that's all they have on offer.

So I'm working on a macro that derives the adjusted prices from the unadjusted closing prices, given the fixed dividend, and using the data back to 2015 to confirm its accuracy.

Print the post  


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.