This action might not be possible to undo. Are you sure you want to continue? BROWSE BY CONTENT TYPE Books. Upload Sign in Join Options. Join Sign In Upload. SMF Addin Documentation Uploaded by Prabu Krishnamurthy. Share or Embed Document. Stock Market Functions - Excel Addin Documentation. Flag for inappropriate content. Recommended Documents Documents Similar To SMF Addin Documentation.

Old School Value Stock Spreadsheet Manual. Sahm Adrangi Kerrisdale Capitals Top Equity Investment. Damn Right Behind the Scenes With Berkshire Hathaway Billionaire Charlie Munger Paperback. Documents About Greeks Finance. Recommended Documents Documents Similar To SMF Addin Documentation Skip carousel.

Kovitz Newsletter Fall. Ben Graham Interview 2. Coho Capital Year End Letter PDF. Taylor-Wieland Paper on Equilibrium Interest Rate April Coho Capital Year End Letter. Pershing Square December Investor Letter.

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

Valuation Spreadsheet How to Use Guide. Rolls Royce Mind the Gap.

SMF Add-In --Tips and FAQS -- Installation

The Collected Wisdom of Seth Klarman. Documents About Greeks Finance Skip carousel. RateLab Vol Heads South. Documents About Moneyness Skip carousel. Stock Market Functions Add-In Overview.

Documentation for RCHGetElementNumber function. Documentation for smfGetAdvFNElement function.

Sorry, the page you are looking for was not found | Seeking Alpha

Documentation for RCHGetYahooQu otes function. Documentation for smfGetOptionQuotes function. Documentation for smfGetYahooOp tionQuote function.

Documentation for smfGetMSNOpti onQuote function. Documentation for smfGetOXOpt ionQuote function. Documentation for smfGetOptionExpiry function. Documentation for RCHGetYahooH istory function. Documentation for smfPricesBetween function.

Documentation for smfPricesByDates function. Documentation for RCHGetHTMLTable function. Documentation for RCHGetTableCell function. Documentation for RCHGetWebData function. Documentation for smfGetCSVFile function. Documentation for smfGetEconData function. Documentation for smfGetTagContent function.

Documentation for RCHCreateComment function. Documentation for smfTech function. Documentation for smfStrExtr function. Stock Market Functions Add-In Change Log. The Stock Market Functions SMF add-in is a collection of user-defined functions UDF that can allow you to retrieve data from web pages and web queries via EXCEL formulas.

To use an add-in, you need to down load it to your computer and install it a simple process. For general information on add-ins, refer to: How do I install the add-in? First step would be to create this directory on your computer: Then, you'd need to tell EXCEL to use it. In EXCEL , that process is: Browse to the XLA file that was extracted from the ZIP archive and double -click on it That should be all you need to do.

Note -- the reason a non-standard add-in p ath was used above is to ease sharing of workbooks that use the add-in.

TMF: Stock Market Functions Excel Add-in / Spreadsheet Advice

Because of how EXCEL saves UDF User Defined Function formula usage, sharing works best if the add-in is located in the same location on both the computer that created the workbook and the computer that is opening the workbook.

If you don't use the recommended directory above, the add-in will still work, but you will have to manually update workbook links when you open any workbook created by someone who had their version of the add-in located elsewhere. Also, older versions of EXCEL treat add -in locations differently, so they may require you to manually locate the add-in when opening up a workbook created on another machine. In many cases, saving the workbook on your machine first may ease the resolution of this location problem.

Here are several illustrated descriptions of how to install an EXCEL add -in: What does the add-in do? There are five primary user-defined functions that the SMF add-in provides: Most RCHGetElementNumber functions are actually just an RCHGetTableCell function with the parameters saved and assigned to an element number. For example, this formula would return a range of data containing a table from.

About About Scribd Press Our blog Join our team! Contact Us Join today Invite Friends Gifts. Legal Terms Privacy Copyright.

Sign up to vote on this title. You're Reading a Free Preview Download. Close Dialog Are you sure? Also remove everything in this list from your library. Are you sure you want to delete this list? Remove them from Saved? Join the membership for readers Get monthly access to books, audiobooks, documents, and more Read Free for 30 Days.

Discover new books Read everywhere Build your digital reading lists. Close Dialog Get the full title to continue.