> SMF add-in Top-Level Directory  > Templates

In General:   All Files   Debug   Recent Updates    Dividends   Options       
By Function:   RCHGetElementNumber()   RCHGetHTMLTable()   RCHGetTableCell()   RCHGetYahooHistory()   RCHGetYahooQuotes()   smfGetTagContent()       
    smfGetAdvFNElement()   smfGetCSVFile()   smfGetOptionQuotes()   smfGetYahooPortfolioView()   smfPricesByDates()        
By Data Source:   AdvFN   BarChart   DiviData   Google   IBD   Morningstar   MSN   Reuters   Yahoo   Zacks   



Recent Updates


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetTableCell-Template-BarChart-Technical-Signals.xls--
2016-11-11 04:00 PM
A template that shows the data elements from the Barchart Technical Indicators page. Basically, this is just element numbers 1215 through 1284 in a format similar to that found on the Barchart web page.
SMF-Template-Barchart-Market-Momentum.xls--
2016-11-11 04:00 PM
A template that shows the data elements from the Barchart Market Momentum page. Basically, this is just element numbers 1146 through 1214 in a format similar to that found on the Barchart web page.

All Files


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetElementNumber-Template-Yahoo-Key-Statistics.xls--
2014-03-07 04:52 PM
A template that shows the data elements available from the Yahoo! Key Statistics web page. Basically, this is just element numbers 938 through 993 shown in context.
RCHGetHTMLTable-Template-MSN-Annual-Financials.xls--
2012-07-25 06:28 AM
OBSOLETE -- A template that shows an example of using the RCHGetHTMLTable() function to retrieve the annual financial statements data from MSN, regardless of the type of company (manufacturing, financial, etc.).
RCHGetHTMLTable-Template-Yahoo-Options.xls--
2014-02-27 10:16 PM
An example of using the RCHGetHTMLTable() function to retrieve Put and Call options from Yahoo Finance.
RCHGetTableCell-Template-BarChart-Technical-Signals.xls--
2016-11-11 04:00 PM
A template that shows the data elements from the Barchart Technical Indicators page. Basically, this is just element numbers 1215 through 1284 in a format similar to that found on the Barchart web page.
RCHGetTableCell-Template-DiviData-Upcoming-Ex-Dividend.xls--
2012-07-10 09:55 AM
An undocumented template showing how to extract the upcoming ex-dividend stocks with a top DiviData rating from http://dividata.com. Uploaded by request.
RCHGetTableCell-Template-IBD-Stock-Checkup.xls--
2015-11-15 06:00 PM
A template of RCHGetTableCell() functions to retrieve data items from IBD's Stock Checkup web page. You will need to log in, creating an IE security cookie, before using the template formulas.
smfGetTagContent-Reuters-Key-Developments.xls--
2016-08-21 03:17 AM
A template to show how the smfGetTagContent() function can be used to extract the "Key Development" items from Reuters.
RCHGetYahooHistory-Example-By-Parameters.xls--
2014-03-08 02:27 AM
A template showing a small example of retrieving historical quotes from Yahoo. All of the parameters for the function can be played with, to see how their changing values can change what the function returns.
RCHGetYahooQuotes-Example-Timed-Update.xls--
2012-12-14 09:21 AM
An example of using the VBA onTime command to do an automatic timed update of stock quotes using the RCHGetYahooQuotes() function.
smfGetAdvFNElement-Template-All-Line-Items.xls--
2015-10-28 04:00 AM
A template showing how to dump all annual and/or quarterly financial statements data from AdvFN, using the smfGetAdvFNElement function.
smfGetAdvFNElement-Template-Specific-Line-Items.xls--
2009-11-04 10:29 PM
A template showing how to dump annual and/or quarterly financial statements data from AdvFN for specific line item labels, using the smfGetAdvFNElement function.
smfGetCSVFile-Template-MorningStar-Financials.xls--
2013-09-27 09:16 AM
An example of using the smfGetCSVFile() to grab a CSV with financial statement data from MorningStar.
smfGetOptionQuotes-Example-ITM-OTM-Multiple-Expirations.xls--
2014-03-10 04:18 AM
An example that retrieves four ITM and four OTM option contracts for a multiple expiration dates.
smfGetOptionQuotes-Example-ITM-OTM.xls--
2014-03-10 04:15 AM
An example that retrieves four ITM and four OTM option contracts for a given expiration date.
smfGetOptionQuotes-Example-Table-Building-Exercise.xls--
2012-01-31 02:42 AM
A step-by-step example of using several of the different option functions.
smfGetOptionQuotes-Template-CC-List-Returns.xls--
2014-03-10 04:01 AM
A workbook to check the nearest ITM and OTM options at a specified expiration date for a number of equities, to find those with the highest RIU. It requires the SMF add-in to collect necessary data from Yahoo or Google or OptionsXPress web pages.
smfGetYahooPortfolioView-Example.xls--
2016-08-07 02:00 PM
Simple example of using the smfGetYahooPortfolioView() function.
smfGetYahooPortfolioView-Multiple-Expirations-By-Strike-Prices.xls--
2016-08-07 07:00 PM
An options tool that retrieves multiple expirations and strikes for a ticker symbol, using the smfYahooPortfolioView() function.
smfPricesByDates-Example-Performance-By-Period.xls--
2014-03-08 02:09 AM
An smfPricesByDates example showing performance by period for several stocks, for a row of ticker symbols and a column of dates/periods.
smfPricesByDates-Example-Stocks-By-Dates.xls--
2014-03-08 02:07 AM
An smfPricesByDates example showing retrieval of prices by dates for a number of stocks, for a column of ticker symbols and a row of dates.
SMF-Quick-Webpage-Examination.xls--
2014-01-07 02:43 PM
Several examples of quick processes I sometimes use to explore what might be on the web page and within the source code of the web page, using the smfGetTagContent(), RCHGetTableCell(), or RCHGetWebData() functions.
SMF-Template-Barchart-Market-Momentum.xls--
2016-11-11 04:00 PM
A template that shows the data elements from the Barchart Market Momentum page. Basically, this is just element numbers 1146 through 1214 in a format similar to that found on the Barchart web page.
SMF-Template-Google-Balance-Sheet-Tables.xls--
2014-03-01 10:38 AM
A template that shows the the Annual and Quarterly Balance Sheet data elements from Google Finance. Basically, this is just element numbers 2992 through 3201 and 3602 through 3853 in a format similar to that found on the Google Finance web page.
SMF-Template-Google-Cash-Flow-Tables.xls--
2014-03-01 10:38 AM
A template that shows the the Annual and Quarterly Cash Flow Statement data elements from Google Finance. Basically, this is just element numbers 3202 through 3301 and 3854 through 3973 in a format similar to that found on the Google Finance web page.
SMF-Template-Google-Income-Statement-Tables.xls--
2014-03-01 10:37 AM
A template that shows the the Annual and Quarterly Income Statement data elements from Google Finance. Basically, this is just element numbers 2742 through 2991 and 3302 through 3601 in a format similar to that found on the Google Finance web page.
SMF-Template-Morningstar-Key-Ratios.xls--
2014-03-02 01:28 AM
A template that shows the Key Ratios data elements from various web pages of Morningstar. Basically, this is just element numbers 14058 through 14398 shown in their web page context.
SMF-Template-Morningstar-Portfolio-Attributes.xls--
2014-03-02 01:26 AM
A template that shows the Morningstar Portfolio Attributes web page data elements for mutual funds. Basically, this is just element numbers 4681 through 4790 shown in their web page context.
SMF-Template-Morningstar-Stock-Data.xls--
2013-10-03 01:50 PM
A template that shows the Morningstar Analyst Estimates and Forward Comparisons web page data elements. Basically, this is just element numbers 14401 through 14442 shown in their web page context.
SMF-Template-Morningstar-Total-Return.xls--
2010-02-08 12:02 AM
A template that shows the Morningstar Total Returns web page data elements for mutual funds. Basically, this is just element numbers 4811 through 4923 shown in their web page context.
SMF-Template-Morningstar-Valuation-Ratios.xls--
2014-03-02 01:17 AM
A template that shows the Comparison Valuation Ratios data elements from various web pages of Morningstar. Basically, this is just element numbers 13931 through 14057 shown in their web page context.
SMF-Template-MSN-10-Year-Summaries.xls--
2014-03-02 01:16 AM
OBSOLETE -- A template that shows the MSN 10-Year summaries of Key Ratio, Income Statement, and Balance Sheet items. Basically, this is just element numbers 153 through 352 shown in their web page context.
SMF-Template-MSN-Analyst-Opinions.xls--
2014-03-02 01:10 AM
OBSOLETE -- A template that shows the MSN Analyst Estimates and Recommendations. Basically, this is just element numbers 353 through 478 shown in their web page context.
SMF-Template-MSN-Key-Ratio-Comparisons.xls--
2014-03-02 01:09 AM
OBSOLETE -- A template that shows the MSN comparison of Key Ratios between a company, their associated industry, and the S&P 500. Basically, this is just element numbers 48 through 152 shown in their web page context.
SMF-Template-RCHGetYahooQuotes.xls--
2014-03-03 05:10 PM
A template with an example of using the RCHGetYahooQuotes() function that has been enabled for recalculation via the F9 keyboard shortcut.
SMF-Template-RCHGetYahooQuotes-Currency-Table.xls--
2014-03-03 05:14 PM
A template that uses the RCHGetYahooQuotes() function to create a table of Cross Currency Rates using the exchange rates quotes available from the Yahoo current quotes interface.
SMF-Template-Reuters-Ratios-Comparison.xls--
2014-02-16 06:45 PM
A template that shows the Reuters Comparison Ratios between a company, their associated industry, their associated sector, and the S&P 500. Basically, this is just element numbers 13626 through 13821 in a format similar to that found on the Reuters web page.
SMF-Template-Yahoo-Analyst-Estimates.xls--
2014-03-03 02:39 AM
A template that shows the data elements from the Yahoo Analyst Estimates page. Basically, this is just element numbers 553 through 700 in a format similar to that found on the Yahoo web page.
SMF-Template-Yahoo-Mutual-Fund-Data.xls--
2014-03-03 02:38 AM
A template that shows the mutual fund data elements available from several Yahoo! Mutual Fund data pages. Basically, this is a subset of element numbers 4930 through 5195 shown in context via tables.
SMF-Template-Zacks-Data.xls--
2016-06-08 04:00 PM
A template that shows the data elements from the Zacks web pages. Basically, this is just element numbers 854 through 876 and 13869 through 13896 shown in context.
SMF-Template-Zacks-Earnings-Annoucements.xls--
2014-03-03 02:34 AM
Shows the new Zacks element definitions for the old earnings.com elements #1286 thru #1400.

Debug Workbooks


Back to top
     FilenameSizeLast ModifiedDescription
SMF-Quick-Webpage-Examination.xls--
2014-01-07 02:43 PM
Several examples of quick processes I sometimes use to explore what might be on the web page and within the source code of the web page, using the smfGetTagContent(), RCHGetTableCell(), or RCHGetWebData() functions.

Dividends Related Tools


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetTableCell-Template-DiviData-Upcoming-Ex-Dividend.xls--
2012-07-10 09:55 AM
An undocumented template showing how to extract the upcoming ex-dividend stocks with a top DiviData rating from http://dividata.com. Uploaded by request.

Options Related Tools


Back to top
     FilenameSizeLast ModifiedDescription
smfGetOptionQuotes-Template-CC-List-Returns.xls--
2014-03-10 04:01 AM
A workbook to check the nearest ITM and OTM options at a specified expiration date for a number of equities, to find those with the highest RIU. It requires the SMF add-in to collect necessary data from Yahoo or Google or OptionsXPress web pages.
smfGetYahooPortfolioView-Multiple-Expirations-By-Strike-Prices.xls--
2016-08-07 07:00 PM
An options tool that retrieves multiple expirations and strikes for a ticker symbol, using the smfYahooPortfolioView() function.

RCHGetElementNumber() Templates


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetElementNumber-Template-Yahoo-Key-Statistics.xls--
2014-03-07 04:52 PM
A template that shows the data elements available from the Yahoo! Key Statistics web page. Basically, this is just element numbers 938 through 993 shown in context.
SMF-Template-Barchart-Market-Momentum.xls--
2016-11-11 04:00 PM
A template that shows the data elements from the Barchart Market Momentum page. Basically, this is just element numbers 1146 through 1214 in a format similar to that found on the Barchart web page.
RCHGetTableCell-Template-BarChart-Technical-Signals.xls--
2016-11-11 04:00 PM
A template that shows the data elements from the Barchart Technical Indicators page. Basically, this is just element numbers 1215 through 1284 in a format similar to that found on the Barchart web page.
SMF-Template-Google-Balance-Sheet-Tables.xls--
2014-03-01 10:38 AM
A template that shows the the Annual and Quarterly Balance Sheet data elements from Google Finance. Basically, this is just element numbers 2992 through 3201 and 3602 through 3853 in a format similar to that found on the Google Finance web page.
SMF-Template-Google-Cash-Flow-Tables.xls--
2014-03-01 10:38 AM
A template that shows the the Annual and Quarterly Cash Flow Statement data elements from Google Finance. Basically, this is just element numbers 3202 through 3301 and 3854 through 3973 in a format similar to that found on the Google Finance web page.
SMF-Template-Google-Income-Statement-Tables.xls--
2014-03-01 10:37 AM
A template that shows the the Annual and Quarterly Income Statement data elements from Google Finance. Basically, this is just element numbers 2742 through 2991 and 3302 through 3601 in a format similar to that found on the Google Finance web page.
SMF-Template-Morningstar-Key-Ratios.xls--
2014-03-02 01:28 AM
A template that shows the Key Ratios data elements from various web pages of Morningstar. Basically, this is just element numbers 14058 through 14398 shown in their web page context.
SMF-Template-Morningstar-Portfolio-Attributes.xls--
2014-03-02 01:26 AM
A template that shows the Morningstar Portfolio Attributes web page data elements for mutual funds. Basically, this is just element numbers 4681 through 4790 shown in their web page context.
SMF-Template-Morningstar-Stock-Data.xls--
2013-10-03 01:50 PM
A template that shows the Morningstar Analyst Estimates and Forward Comparisons web page data elements. Basically, this is just element numbers 14401 through 14442 shown in their web page context.
SMF-Template-Morningstar-Total-Return.xls--
2010-02-08 12:02 AM
A template that shows the Morningstar Total Returns web page data elements for mutual funds. Basically, this is just element numbers 4811 through 4923 shown in their web page context.
SMF-Template-Morningstar-Valuation-Ratios.xls--
2014-03-02 01:17 AM
A template that shows the Comparison Valuation Ratios data elements from various web pages of Morningstar. Basically, this is just element numbers 13931 through 14057 shown in their web page context.
SMF-Template-MSN-10-Year-Summaries.xls--
2014-03-02 01:16 AM
OBSOLETE -- A template that shows the MSN 10-Year summaries of Key Ratio, Income Statement, and Balance Sheet items. Basically, this is just element numbers 153 through 352 shown in their web page context.
SMF-Template-MSN-Analyst-Opinions.xls--
2014-03-02 01:10 AM
OBSOLETE -- A template that shows the MSN Analyst Estimates and Recommendations. Basically, this is just element numbers 353 through 478 shown in their web page context.
SMF-Template-MSN-Key-Ratio-Comparisons.xls--
2014-03-02 01:09 AM
OBSOLETE -- A template that shows the MSN comparison of Key Ratios between a company, their associated industry, and the S&P 500. Basically, this is just element numbers 48 through 152 shown in their web page context.
SMF-Template-Reuters-Ratios-Comparison.xls--
2014-02-16 06:45 PM
A template that shows the Reuters Comparison Ratios between a company, their associated industry, their associated sector, and the S&P 500. Basically, this is just element numbers 13626 through 13821 in a format similar to that found on the Reuters web page.
SMF-Template-Yahoo-Analyst-Estimates.xls--
2014-03-03 02:39 AM
A template that shows the data elements from the Yahoo Analyst Estimates page. Basically, this is just element numbers 553 through 700 in a format similar to that found on the Yahoo web page.
SMF-Template-Yahoo-Mutual-Fund-Data.xls--
2014-03-03 02:38 AM
A template that shows the mutual fund data elements available from several Yahoo! Mutual Fund data pages. Basically, this is a subset of element numbers 4930 through 5195 shown in context via tables.
SMF-Template-Zacks-Data.xls--
2016-06-08 04:00 PM
A template that shows the data elements from the Zacks web pages. Basically, this is just element numbers 854 through 876 and 13869 through 13896 shown in context.
SMF-Template-Zacks-Earnings-Annoucements.xls--
2014-03-03 02:34 AM
Shows the new Zacks element definitions for the old earnings.com elements #1286 thru #1400.

RCHGetHTMLTable() Templates


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetHTMLTable-Template-MSN-Annual-Financials.xls--
2012-07-25 06:28 AM
OBSOLETE -- A template that shows an example of using the RCHGetHTMLTable() function to retrieve the annual financial statements data from MSN, regardless of the type of company (manufacturing, financial, etc.).
RCHGetHTMLTable-Template-Yahoo-Options.xls--
2014-02-27 10:16 PM
An example of using the RCHGetHTMLTable() function to retrieve Put and Call options from Yahoo Finance.

RCHGetTableCell() Templates


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetTableCell-Template-DiviData-Upcoming-Ex-Dividend.xls--
2012-07-10 09:55 AM
An undocumented template showing how to extract the upcoming ex-dividend stocks with a top DiviData rating from http://dividata.com. Uploaded by request.

RCHGetYahooHistory() Templates


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetYahooHistory-Example-By-Parameters.xls--
2014-03-08 02:27 AM
A template showing a small example of retrieving historical quotes from Yahoo. All of the parameters for the function can be played with, to see how their changing values can change what the function returns.

RCHGetYahooQuotes() Templates


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetYahooQuotes-Example-Timed-Update.xls--
2012-12-14 09:21 AM
An example of using the VBA onTime command to do an automatic timed update of stock quotes using the RCHGetYahooQuotes() function.
SMF-Template-RCHGetYahooQuotes-Currency-Table.xls--
2014-03-03 05:14 PM
A template that uses the RCHGetYahooQuotes() function to create a table of Cross Currency Rates using the exchange rates quotes available from the Yahoo current quotes interface.
SMF-Template-RCHGetYahooQuotes.xls--
2014-03-03 05:10 PM
A template with an example of using the RCHGetYahooQuotes() function that has been enabled for recalculation via the F9 keyboard shortcut.

smfGetAdvFNElement() Templates


Back to top
     FilenameSizeLast ModifiedDescription
smfGetAdvFNElement-Template-All-Line-Items.xls--
2015-10-28 04:00 AM
A template showing how to dump all annual and/or quarterly financial statements data from AdvFN, using the smfGetAdvFNElement function.
smfGetAdvFNElement-Template-Specific-Line-Items.xls--
2009-11-04 10:29 PM
A template showing how to dump annual and/or quarterly financial statements data from AdvFN for specific line item labels, using the smfGetAdvFNElement function.

smfGetCSVFile() Templates


Back to top
     FilenameSizeLast ModifiedDescription
smfGetCSVFile-Template-MorningStar-Financials.xls--
2013-09-27 09:16 AM
An example of using the smfGetCSVFile() to grab a CSV with financial statement data from MorningStar.

smfGetOptionQuotes() Templates


Back to top
     FilenameSizeLast ModifiedDescription
smfGetOptionQuotes-Example-ITM-OTM-Multiple-Expirations.xls--
2014-03-10 04:18 AM
An example that retrieves four ITM and four OTM option contracts for a multiple expiration dates.
smfGetOptionQuotes-Example-ITM-OTM.xls--
2014-03-10 04:15 AM
An example that retrieves four ITM and four OTM option contracts for a given expiration date.
smfGetOptionQuotes-Example-Table-Building-Exercise.xls--
2012-01-31 02:42 AM
A step-by-step example of using several of the different option functions.
smfGetOptionQuotes-Template-CC-List-Returns.xls--
2014-03-10 04:01 AM
A workbook to check the nearest ITM and OTM options at a specified expiration date for a number of equities, to find those with the highest RIU. It requires the SMF add-in to collect necessary data from Yahoo or Google or OptionsXPress web pages.

smfGetTagContent() Templates


Back to top
     FilenameSizeLast ModifiedDescription
smfGetTagContent-Reuters-Key-Developments.xls--
2016-08-21 03:17 AM
A template to show how the smfGetTagContent() function can be used to extract the "Key Development" items from Reuters.

smfGetYahooPortfolioView() Templates


Back to top
     FilenameSizeLast ModifiedDescription
smfGetYahooPortfolioView-Example.xls--
2016-08-07 02:00 PM
Simple example of using the smfGetYahooPortfolioView() function.
smfGetYahooPortfolioView-Multiple-Expirations-By-Strike-Prices.xls--
2016-08-07 07:00 PM
An options tool that retrieves multiple expirations and strikes for a ticker symbol, using the smfYahooPortfolioView() function.

smfPricesByDates() Templates


Back to top
     FilenameSizeLast ModifiedDescription
smfPricesByDates-Example-Performance-By-Period.xls--
2014-03-08 02:09 AM
An smfPricesByDates example showing performance by period for several stocks, for a row of ticker symbols and a column of dates/periods.
smfPricesByDates-Example-Stocks-By-Dates.xls--
2014-03-08 02:07 AM
An smfPricesByDates example showing retrieval of prices by dates for a number of stocks, for a column of ticker symbols and a row of dates.

AdvFN Templates


Back to top
     FilenameSizeLast ModifiedDescription
smfGetAdvFNElement-Template-All-Line-Items.xls--
2015-10-28 04:00 AM
A template showing how to dump all annual and/or quarterly financial statements data from AdvFN, using the smfGetAdvFNElement function.
smfGetAdvFNElement-Template-Specific-Line-Items.xls--
2009-11-04 10:29 PM
A template showing how to dump annual and/or quarterly financial statements data from AdvFN for specific line item labels, using the smfGetAdvFNElement function.

BarChart Templates


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetTableCell-Template-BarChart-Technical-Signals.xls--
2016-11-11 04:00 PM
A template that shows the data elements from the Barchart Technical Indicators page. Basically, this is just element numbers 1215 through 1284 in a format similar to that found on the Barchart web page.
SMF-Template-Barchart-Market-Momentum.xls--
2016-11-11 04:00 PM
A template that shows the data elements from the Barchart Market Momentum page. Basically, this is just element numbers 1146 through 1214 in a format similar to that found on the Barchart web page.

DiviData Templates


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetTableCell-Template-DiviData-Upcoming-Ex-Dividend.xls--
2012-07-10 09:55 AM
An undocumented template showing how to extract the upcoming ex-dividend stocks with a top DiviData rating from http://dividata.com. Uploaded by request.

Google Templates


Back to top
     FilenameSizeLast ModifiedDescription
SMF-Template-Google-Balance-Sheet-Tables.xls--
2014-03-01 10:38 AM
A template that shows the the Annual and Quarterly Balance Sheet data elements from Google Finance. Basically, this is just element numbers 2992 through 3201 and 3602 through 3853 in a format similar to that found on the Google Finance web page.
SMF-Template-Google-Cash-Flow-Tables.xls--
2014-03-01 10:38 AM
A template that shows the the Annual and Quarterly Cash Flow Statement data elements from Google Finance. Basically, this is just element numbers 3202 through 3301 and 3854 through 3973 in a format similar to that found on the Google Finance web page.
SMF-Template-Google-Income-Statement-Tables.xls--
2014-03-01 10:37 AM
A template that shows the the Annual and Quarterly Income Statement data elements from Google Finance. Basically, this is just element numbers 2742 through 2991 and 3302 through 3601 in a format similar to that found on the Google Finance web page.

IBD Templates


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetTableCell-Template-IBD-Stock-Checkup.xls--
2015-11-15 06:00 PM
A template of RCHGetTableCell() functions to retrieve data items from IBD's Stock Checkup web page. You will need to log in, creating an IE security cookie, before using the template formulas.

Morningstar Templates


Back to top
     FilenameSizeLast ModifiedDescription
smfGetCSVFile-Template-MorningStar-Financials.xls--
2013-09-27 09:16 AM
An example of using the smfGetCSVFile() to grab a CSV with financial statement data from MorningStar.
SMF-Template-Morningstar-Key-Ratios.xls--
2014-03-02 01:28 AM
A template that shows the Key Ratios data elements from various web pages of Morningstar. Basically, this is just element numbers 14058 through 14398 shown in their web page context.
SMF-Template-Morningstar-Portfolio-Attributes.xls--
2014-03-02 01:26 AM
A template that shows the Morningstar Portfolio Attributes web page data elements for mutual funds. Basically, this is just element numbers 4681 through 4790 shown in their web page context.
SMF-Template-Morningstar-Stock-Data.xls--
2013-10-03 01:50 PM
A template that shows the Morningstar Analyst Estimates and Forward Comparisons web page data elements. Basically, this is just element numbers 14401 through 14442 shown in their web page context.
SMF-Template-Morningstar-Total-Return.xls--
2010-02-08 12:02 AM
A template that shows the Morningstar Total Returns web page data elements for mutual funds. Basically, this is just element numbers 4811 through 4923 shown in their web page context.
SMF-Template-Morningstar-Valuation-Ratios.xls--
2014-03-02 01:17 AM
A template that shows the Comparison Valuation Ratios data elements from various web pages of Morningstar. Basically, this is just element numbers 13931 through 14057 shown in their web page context.

MSN Templates (Obsolete)


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetHTMLTable-Template-MSN-Annual-Financials.xls--
2012-07-25 06:28 AM
OBSOLETE -- A template that shows an example of using the RCHGetHTMLTable() function to retrieve the annual financial statements data from MSN, regardless of the type of company (manufacturing, financial, etc.).
SMF-Template-MSN-10-Year-Summaries.xls--
2014-03-02 01:16 AM
OBSOLETE -- A template that shows the MSN 10-Year summaries of Key Ratio, Income Statement, and Balance Sheet items. Basically, this is just element numbers 153 through 352 shown in their web page context.
SMF-Template-MSN-Analyst-Opinions.xls--
2014-03-02 01:10 AM
OBSOLETE -- A template that shows the MSN Analyst Estimates and Recommendations. Basically, this is just element numbers 353 through 478 shown in their web page context.
SMF-Template-MSN-Key-Ratio-Comparisons.xls--
2014-03-02 01:09 AM
OBSOLETE -- A template that shows the MSN comparison of Key Ratios between a company, their associated industry, and the S&P 500. Basically, this is just element numbers 48 through 152 shown in their web page context.

Reuters Templates


Back to top
     FilenameSizeLast ModifiedDescription
smfGetTagContent-Reuters-Key-Developments.xls--
2016-08-21 03:17 AM
A template to show how the smfGetTagContent() function can be used to extract the "Key Development" items from Reuters.
SMF-Template-Reuters-Ratios-Comparison.xls--
2014-02-16 06:45 PM
A template that shows the Reuters Comparison Ratios between a company, their associated industry, their associated sector, and the S&P 500. Basically, this is just element numbers 13626 through 13821 in a format similar to that found on the Reuters web page.

Yahoo Templates


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetElementNumber-Template-Yahoo-Key-Statistics.xls--
2014-03-07 04:52 PM
A template that shows the data elements available from the Yahoo! Key Statistics web page. Basically, this is just element numbers 938 through 993 shown in context.
RCHGetHTMLTable-Template-Yahoo-Options.xls--
2014-02-27 10:16 PM
An example of using the RCHGetHTMLTable() function to retrieve Put and Call options from Yahoo Finance.
RCHGetYahooHistory-Example-By-Parameters.xls--
2014-03-08 02:27 AM
A template showing a small example of retrieving historical quotes from Yahoo. All of the parameters for the function can be played with, to see how their changing values can change what the function returns.
RCHGetYahooQuotes-Example-Timed-Update.xls--
2012-12-14 09:21 AM
An example of using the VBA onTime command to do an automatic timed update of stock quotes using the RCHGetYahooQuotes() function.
smfGetYahooPortfolioView-Example.xls--
2016-08-07 02:00 PM
Simple example of using the smfGetYahooPortfolioView() function.
smfGetYahooPortfolioView-Multiple-Expirations-By-Strike-Prices.xls--
2016-08-07 07:00 PM
An options tool that retrieves multiple expirations and strikes for a ticker symbol, using the smfYahooPortfolioView() function.
smfPricesByDates-Example-Performance-By-Period.xls--
2014-03-08 02:09 AM
An smfPricesByDates example showing performance by period for several stocks, for a row of ticker symbols and a column of dates/periods.
smfPricesByDates-Example-Stocks-By-Dates.xls--
2014-03-08 02:07 AM
An smfPricesByDates example showing retrieval of prices by dates for a number of stocks, for a column of ticker symbols and a row of dates.
SMF-Template-RCHGetYahooQuotes.xls--
2014-03-03 05:10 PM
A template with an example of using the RCHGetYahooQuotes() function that has been enabled for recalculation via the F9 keyboard shortcut.
SMF-Template-RCHGetYahooQuotes-Currency-Table.xls--
2014-03-03 05:14 PM
A template that uses the RCHGetYahooQuotes() function to create a table of Cross Currency Rates using the exchange rates quotes available from the Yahoo current quotes interface.
SMF-Template-Yahoo-Analyst-Estimates.xls--
2014-03-03 02:39 AM
A template that shows the data elements from the Yahoo Analyst Estimates page. Basically, this is just element numbers 553 through 700 in a format similar to that found on the Yahoo web page.
SMF-Template-Yahoo-Mutual-Fund-Data.xls--
2014-03-03 02:38 AM
A template that shows the mutual fund data elements available from several Yahoo! Mutual Fund data pages. Basically, this is a subset of element numbers 4930 through 5195 shown in context via tables.

Zacks Templates


Back to top
     FilenameSizeLast ModifiedDescription
SMF-Template-Zacks-Data.xls--
2016-06-08 04:00 PM
A template that shows the data elements from the Zacks web pages. Basically, this is just element numbers 854 through 876 and 13869 through 13896 shown in context.
SMF-Template-Zacks-Earnings-Annoucements.xls--
2014-03-03 02:34 AM
Shows the new Zacks element definitions for the old earnings.com elements #1286 thru #1400.