> SMF add-in Top-Level Directory > Documentation

         
In General: Alphabetical List
By Data Type: Options Utility Macros

Alphabetical List

     Filename Last Modified Description
Array Enter Formulas
2023-06-14
Documentation on how to array enter formulas in Excel
including example file.
Change-Log.html
2024-04-29
Change log for add-in
RCHCreateComment-Function.html
2006-09-13
Documentation for RCHCreateComment function
RCHGetElementNumber-Function.html
2024-02-05
Function to return a value to a worksheet cell, based on pre-defined data elements that have been assigned to numbers. For example, this would return the Market Capitalization value from Yahoo's Market Statistics web page for ticker symbol "MMM"

=RCHGetElementNumber("MMM", 941)
RCHGetHTMLTable-Function.html
2023-06-08
Documentation for RCHGetHTMLTable function
RCHGetTableCell-Function.html
2014-03-08
Documentation for RCHGetTableCell function
RCHGetWebData-Function.html
2006-09-07
Documentation for RCHGetWebData function
RCHGetYahooHistory-Function.html
2007-04-03
Documentation for RCHGetYahooHistory function
RCHGetYahooQuotes-Function.html 1900-01-00 OBSOLETE: Function to return a range of daily quotes values to worksheet cells, using Yahoo's CSV file interface, based on a list of ticker symbols and Yahoo codes. For example, this would return the opening and last traded prices on ticker symbols "MMM" and "IBM":

=RCHGetYahooQuotes("MMM,IBM","ol1")
smf-Context-Menu.html
2017-11-08
Documentation for SMF context menu (Placeholder)
smfFixLinks-Macro.html
2017-11-08
Documentation for smfFixLinks macro (Placeholder)
smfForceRecalculation-Macro.html
2017-11-08
Documentation for smfForceRecalculation macro (Placeholder)
smfGetCSVFile-Function.html
2009-03-01
Documentation for smfGetCSVFile function
smfGetOptionExpirations-Function.html
2024-02-05
Documentation for smfGetOptionExpirations function
smfGetOptionQuotes-Function.html
2016-12-03
Function 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")
smfGetOptionStrikes-Function.html
2024-02-05
Documentation for smfGetOptionStrikes function
smfGetTagContent-Function.htmlDocumentation for smfGetTagContent function
smfGetYahooHistory-Function.html
2023-02-24
Documentation for smfGetYahooHistory function
smfGetYahooJSONData-Function.html
2023-09-20
Documentation for smfGetYahooJSONData function
smfGetYahooOptionQuote-Function.html Documentation for smfGetYahooOptionQuote function
smfGetYahooPortfolioView-Function.html
2024-03-09
Documentation for smfGetYahooPortfolioView function
smfJoin-Function.htmlDocumentation for smfJoin function
smfPricesBetween-Function.htmlDocumentation for smfPricesBetween function
smfPricesByDates-Function.htmlDocumentation for smfPricesByDates function
smfStrExtr-Function.htmlDocumentation for smfStrExtr function
smfWord-Function.html
2011-11-29
Documentation for smfWord function

Options Related Functions


Back to top
     Filename Last Modified Description
smfGetOptionExpirations-Function.html
2024-04-29
Documentation for smfGetOptionExpirations function
smfGetOptionQuotes-Function.html
2016-12-03
Function 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")
smfGetOptionStrikes-Function.html
2024-04-29
Documentation for smfGetOptionStrikes function
smfGetYahooOptionQuote-Function.html
2010-09-11
Documentation for smfGetYahooOptionQuote function

Utility Functions


Back to top
     Filename Last Modified Description
smfJoin-Function.html
2011-11-29
Documentation for smfJoin function
smfStrExtr-Function.html
2012-07-12
Documentation for smfStrExtr function
smfWord-Function.html
2011-11-29
Documentation for smfWord function

Macros


Back to top
     Filename Last Modified Description
smfFixLinks-Macro.html
2017-11-08
Documentation for smfFixLinks macro (Placeholder)
smfForceRecalculation-Macro.html
2017-11-08
Documentation for smfForceRecalculation macro (Placeholder)