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)
|