Does anyone use a macro to pull yahoo data? I'm trying to pull some simple open/close data on Yahoo and I have a basket of about 50 stocks. I don't want to manually pull each day but as you can see below in the link, the format is pretty straight forward. I have a spreadsheet of my tickers that I build each day and I have a macro to build out each of the links. Has anyone used a simple macro to automate pulling & saving these files? Thx. EDIT: http(space in brackets)://ichart.finance.yahoo.(dot com left out intentionally)/table.csv?s=IBM&a=00&b=2&c=1962&d=10&e=2&f=2010&g=d&ignore=.csv http://ichart.finance.yahoo.com/table.csv?s=IBM&a=00&b=2&c=1962&d=10&e=2&f=2010&g=d&ignore=.csv
as far as i remember-there is a few yahoo groups, dedicated to trading and excel..i'm pretty sure they know how to do that..i've done this many years ago,but can't find my code...search in yahoo groups here is one- http://finance.groups.yahoo.com/group/smf_addin/messages some third party- http://3d2f.com/tags/excel/download/yahoo/historical/stock/prices/
Yahoo! data have been known to contain misprints (unfiltered). Also, newly listed stocks might not "appear" on Yahoo! for some time. In fact, if you're in the business of serious trading, Yahoo! data is sh1t... Afterall, you ged wut you payd for...
I realize this. Thanks. I have 3 years of nice, neat, good, clean tick data however I need some quick & dirty 15yr historicals on a giant basket of 800-2800 names. One or two misprints won't really make that much of a difference when the basket will be Indexed and 5, 10 & 15yr performance will be evaluated generally.
try this http://www.volumedigger.com/Software/Data_Downloader.aspx I only tried for google data and it worked... creating txt files.