StockFetcher Forums · General Discussion · Historical Data for Excel<< >>Post Follow-up
slebl29
2 posts
msg #73160
Ignore slebl29
3/30/2009 11:37:04 PM

Could anyone direct me to a historical data program for excel (possibly free)? thanks in advance!

19231017
4 posts
msg #73309
Ignore 19231017
4/4/2009 8:32:59 PM

Don't know if this is what you're looking for but Yahoo provides great historic data.
I keep it in my "Favorites" cuz I use it so much

http://finance.yahoo.com/q/hp?s=%5EDJI

Good Luck

rharmelink
81 posts
msg #73330
Ignore rharmelink
4/5/2009 9:30:16 PM

>> Could anyone direct me to a historical data program for excel (possibly free)?

Also not quite sure what you're looking for. However, I have a free open-source add-in for EXCEL that can grab a lot of information off the web via user-defined functions. The add-in, documentation on its functions, and examples and templates can be found in the files area of this Yahoo group:

http://finance.groups.yahoo.com/group/smf_addin

For example, to load historical quotes for ticker MMM, you could array-enter something as simple as:

=RCHGetYahooHistory("MMM")

Or, to get current quotes on MMM and IBM:

=RCHGetYahooQuotes("MMM,IBM")

Or, to grab the Market Capitalization of MMM from the Yahoo Key Statistics page:

=RCHGetElementNumber("MMM",941)

StockFetcher Forums · General Discussion · Historical Data for Excel<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus