Stock Market Functions (SMF) Add-in - Get Financial Data in Excel

Over the past couple of days I've been looking for various tools that could help us extract stock markets data in excel. I've earlier talked about the MarketXLS excel add-in which is also a very powerful add-in.

Today I wanted to highlight the SMF Add-in which I came across just a few days back. I just don't know why I didn't know about it earlier. Again, a very powerful excel add-in. The SMF (Stock Market Functions) add-in adds a number of functions to EXCEL that can allow data to be extracted and/or retrieved from the web and placed directly into EXCEL cells or ranges. You can download and learn more about the add-in from their website SMF Add-in. Many thanks to the add-in writer Randy Harmelink who maintains the plugin.

Just to give you a brief, the add-in can be used to extract a variety of data from stock market websites. For example, the following function would return the Market Capitalization value from Yahoo's Market Statistics web page for ticker symbol "MMM"

\=RCHGetElementNumber("MMM", 941)

Similarly, the following would return the opening and last traded prices on ticker symbols "MMM" and "IBM":

\=RCHGetYahooQuotes("MMM,IBM","ol1")

There are also functions to return a range of options data items to worksheet cells, based on a list of special option ticker symbols and data codes. For example, this would return the bid and ask prices on the specified options contract:

\=smfGetOptionQuotes("SPY 12/19 2015 $190 Call","ba")

Go ahead and download the add-in to see how diverse it is and how it can quickly help you automate your financial models.

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book includes PDFs, explanations, instructions, data files, and R code for all examples.

Get the Bundle for $39 (Regular $57)
JOIN 30,000 DATA PROFESSIONALS

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book comes with PDFs, detailed explanations, step-by-step instructions, data files, and complete downloadable R code for all examples.