Today I wanted to highlight the SMF Add-in which I came across just a few days back. Again, a very powerful excel add-in.

Get Stock Quotes in Excel: New Excel Add-in - Finance Train

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.

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:. Go ahead and download the add-in to see how diverse it is and how it can quickly help you automate your financial models.

The page is not found

Your email address will not be published. The most comprehensive educational resources for finance. Skip to content Home Certification Exams CFA Exam CAIA Exam ERP Exam FRM Exam PRM Exam Subjects Anti-money Laundering Basel II Basel III Accounting Banking Corporate Finance Derivatives Economics Equity Analysis Excel Modelling Financial Accounting Financial Management Financial Markets Financial Maths Financial Modelling Financial Planning Finance for Non-finance Managers Fixed Income Securities Foreign Exchange Insurance Investment Management Mortgage Personal Finance Portfolio Management Quantitative Finance Regulations and Compliance Careers Financial Data Science Calculators Products.

Stock Market Functions SMF Add-in — Get Financial Data in Excel. Try our courses on Data Science for Finance.

Leave a Reply Cancel reply Your email address will not be published. Recent Posts The best calculators on the market — Get the best help for managing your finances How Banks Meet Customer Expectations Everything you need to know about Self Directed IRA services Data Science Vs Financial Engineering PTS Trainers.

Popular Posts How to Calculate FCFF and FCFE How to Calculate Annualized Returns How to Calculate Portfolio Risk and Return How to Calculate Forward Rates from Spot Rates? YTM and Debt-Rating Approach How to Calculate Annualized Standard Deviation Inventory Turnover and Days of Inventory on Hand DOH.