In our previous article we used a simple method for importing stock quote data into Excel. Today we will look at a robust automated method for querying more data sources then just Yahoo finance. The Stock Market Functions Add-in for Excel is a free tool developed by by Randy Harmelink. The stock market functions Add-In allows you to import data from sites like Yahoo, Business Week, Reuters, Google, Bloomberg, MSN and many more. In the latest release there are beta features for several technical analysis functions like
- Accumulation Distribution Line
- Average True Range
- Commodity Channel Index
- Simple Moving Average
- Moving Average Convergence Divergence
- Exponential Moving Average
- On Balance Volume
- Rate of Change
- Relative Strength Indicator
- Stochastic’s
In order to download the Excel SMF Add-in you will need to sign up to the Yahoo finance group. After signing up you will be able to download the Add-in, templates and documentation. The documentation for free software programs is usually somewhat lacking however Randy and the community have done a phenomenal job documenting the functions of this Add-in.
Installing SMF under Vista and Excel 2007
As the documentation does not go into detail about the install under Excel 2007 I will quickly go over the process.
Step One
Download RCH_Stock_Market_Functions.zip from the files section of the Yahoo finance group.
Step Two
Create a new folder called “SMF Add-In” in the directory “C:\Program Files\”.
Note: You will need to have admin access to carry out this operation.
Step Three
Extract the file to the folder you created as highlighted below.
Note: You will need to have admin access to carry out this operation.
Step Four
You will now need to enable the Add-In to do this you will need to open the Excel options dialog window as shown below:
In the Excel options dialog select Add-Ins and then Manage Add-Ins.
Another dialog window will open with several Add-Ins displayed click brows and locate the RCH_Stock_Market_Functions Add-in.
The final step is to test that the Add-In has been initialised properly. In a new workbook highlight 20 rows and 7 columns. With the area highlighted in the formula bar type the following:
=RCHGetYahooHistory(”MSFT”)
Do Not just press enter instead press CTRL + SHIFT + ENTER and the Microsoft data should be added. This process is highlighted below.
The Microsoft data should now automatically be placed in the cells this is shown below.
Obviously the cells require formatting but the power of this Add-In is immense. In upcoming articles I will investigate some more features, until then make sure you have a read through the documentation.
Popularity: 100% [?]
Stock Market » Blog Archive » Importing Stock Quotes to Excel using SMF Add-in
1 year ago
[...] Indian Startups | India Business | Entrepreneurship Resources wrote an interesting post today on Importing Stock Quotes to Excel using SMF Add-inHere’s a quick excerptStep One. Download RCH_Stock_Market_Functions.zip from the files section of the Yahoo finance group. Step Two… [...]
Cyrus Sethna
1 year ago
Holy shit, is this serious?
admin
1 year ago
Cyrus,
This is serious, the SMF Add-In is very easy to use and powerful and best of all it is Free.
Matt
1 year ago
Wow I can’t believe it is that easy. I never even heard about this plugin. Thanks for the heads up, do you have the exact download link?
ozzy90
4 months ago
atrophy Beograd bond Cherokee comparator drainage exacerbations footpath forever formation gaming inheritances mission reintroduced sandals savory Swinburne tasteless waits withdrawn generic cialis aspirations mysteriousness substitutability woodman .
JohnStryker
1 month ago
American Diversified Holdings Corporation is a publicly traded holding company, headquartered in Del Mar, California. The enterprise was formed for the express purpose of acquiring privately held, fast growing, established companies with proven business models that are within a few quarters of profitability. This model allows ADHC to purchase these entities at a significant valuation discount to the public market and then provide the funding necessary for these acquisitions to achieve maximum profit potential using the public equity markets without impairing their balance sheets. ADHC was formed in early 2007 and listed on the OTC Pink Sheets in the 4th quarter of 2007.
Outstanding Shares – 21,479,786 as of Feb 28, 2009
Authorized Shares – 1,000,000,000 as of Feb 28, 2009
Number of Share Holders of Record – 103 as of Jan 28, 2009
Float – 73,380 as of Feb 28, 2009
Looks like a tempting pennystock investment, thats a really tight float for a micro cap. I think these guys own Lasik America too.
Investor Website: http://www.americandiversifiedholdings.com/
It is our long-term strategy to become the preferred buyer for the primary owners and managers of both North and South American early stage growth businesses. The current senior management of ADHC has many years of experience and success, both in the financial community and as directors of public companies to implement this strategy. We have no preference of either industry or geographic focus in our acquisition strategy, but instead look at the economic models and characteristics of each company as well as the vision, experience and success rate of the owners and managers of these acquisitions.
More information can be found on the Investor’sHub site for ADHC.PK also.
http://investorshub.advfn.com/boards…?board_id=9959