No. of Recommendations: 2
For any Google Sheets users, this seems to be a simple enough way to extract the historical adjusted close from Yahoo for a single ticker and date at a time. I won't guarantee that this will continue to work but it works today …

In my case:

Cell A2 contains the ticker symbol
Cell B1 contains the date for which I want the adjusted close price
Cell B2 contains the following formula

=index(importHTML("" & $A2 & "/history?period1=" & B$1*86400-2209078800 & "&period2=" & B$1*86400-2209078800 & "&interval=1d&filter=history&frequency=1d", "table",1),2,6)

If you had a list of tickers in column A and a list of dates in row one, you can copy this formula across and down.

So far, I have been unsuccessful in getting Excel (using VBA to parse the data) to pull in similar data starting with the same basic URL.

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.