> SMF add-in Top-Level Directory  > Documentation

In General:   Alphabetical List                                                   
By Data Type:   Options   Quotes   Utility                                       
By Data Source:   Yahoo                                                   



Alphabetical List


Back to top
     FilenameSizeLast ModifiedDescription
Change-Log.html--
2017-08-13 08:00 PM
Change log for add-in
RCHCreateComment-Function.html--
2006-09-13 08:08 PM
Documentation for RCHCreateComment function
RCHGetElementNumber-Function.html--
2011-09-14 01:21 PM
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)
RCHGetElementNumber-Function-Example-001.html--
2006-08-31 01:45 AM
Documentation for RCHGetElementNumber function
RCHGetHTMLTable-Function.html--
2008-08-25 10:55 AM
Documentation for RCHGetHTMLTable function
RCHGetTableCell-Function.html--
2014-03-08 05:07 PM
Documentation for RCHGetTableCell function
RCHGetWebData-Function.html--
2006-09-07 04:43 PM
Documentation for RCHGetWebData function
RCHGetYahooHistory-Function.html--
2007-04-03 05:05 PM
Documentation for RCHGetYahooHistory function
RCHGetYahooQuotes-Function.html--
2007-09-28 09:00 PM
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")
smfGet888OptionQuote.html--
2012-02-14 11:36 PM
Documentation for function
smfGetAdvFNElement-Function.html--
2010-01-14 08:21 PM
Documentation for smfGetAdvFNElement function
smfGetBarChartOptionQuote-Function.html--
2016-12-03 10:00 PM
Documentation for smfGetBarChartOptionQuote function
smfGetCSVFile-Function.html--
2009-03-01 05:41 PM
Documentation for smfGetCSVFile function
smfGetEconData-Function.html--
2010-03-21 12:09 PM
Documentation for smfGetEconData function
smfGetGoogleOptionQuote-Function.html--
2011-04-01 04:24 PM
Documentation for smfGetGoogleOptionQuote function
smfGetMSNOptionQuote-Function.html--
2010-06-21 12:00 PM
Documentation for smfGetMSNOptionQuote function
smfGetOptionExpirations-Function.html--
2012-02-14 11:33 PM
Documentation for smfGetOptionExpirations function
smfGetOptionExpiry-Function.html--
2010-06-21 03:05 PM
Documentation for smfGetOptionExpiry function
smfGetOptionQuotes-Function.html--
2016-12-03 10:00 PM
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--
2012-02-14 11:33 PM
Documentation for smfGetOptionStrikes function
smfGetOXOptionQuote-Function.html--
2010-06-21 12:40 PM
Documentation for smfGetOXOptionQuote function
smfGetTagContent-Function.html--
2010-07-21 08:13 AM
Documentation for smfGetTagContent function
smfGetYahooJSONData-Function.html--
2017-04-24 05:00 PM
Documentation for smfGetYahooJSONData function
smfGetYahooJSONField-Function.html--
2017-05-01 11:00 AM
Documentation for smfGetYahooJSONField function
smfGetYahooOptionQuote-Function.html--
2010-09-11 12:48 AM
Documentation for smfGetYahooOptionQuote function
smfJoin-Function.html--
2011-11-29 04:42 PM
Documentation for smfJoin function
smfPricesBetween-Function.html--
2007-10-15 11:35 PM
Documentation for smfPricesBetween function
smfPricesByDates-Function.html--
2009-01-02 02:59 AM
Documentation for smfPricesByDates function
smfStrExtr-Function.html--
2012-07-12 08:39 AM
Documentation for smfStrExtr function
smfTech-Function.html--
2007-09-28 09:08 PM
Documentation for smfTech function
smfWord-Function.html--
2011-11-29 04:54 PM
Documentation for smfWord function

Options Related Functions


Back to top
     FilenameSizeLast ModifiedDescription
smfGetBarChartOptionQuote-Function.html--
2016-12-03 10:00 PM
Documentation for smfGetBarChartOptionQuote function
smfGetGoogleOptionQuote-Function.html--
2011-04-01 04:24 PM
Documentation for smfGetGoogleOptionQuote function
smfGetMSNOptionQuote-Function.html--
2010-06-21 12:00 PM
Documentation for smfGetMSNOptionQuote function
smfGetOptionExpirations-Function.html--
2012-02-14 11:33 PM
Documentation for smfGetOptionExpirations function
smfGetOptionExpiry-Function.html--
2010-06-21 03:05 PM
Documentation for smfGetOptionExpiry function
smfGetOptionQuotes-Function.html--
2016-12-03 10:00 PM
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--
2012-02-14 11:33 PM
Documentation for smfGetOptionStrikes function
smfGetOXOptionQuote-Function.html--
2010-06-21 12:40 PM
Documentation for smfGetOXOptionQuote function
smfGetYahooOptionQuote-Function.html--
2010-09-11 12:48 AM
Documentation for smfGetYahooOptionQuote function

Quotes Related Functions


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetYahooHistory-Function.html--
2007-04-03 05:05 PM
Documentation for RCHGetYahooHistory function
RCHGetYahooQuotes-Function.html--
2007-09-28 09:00 PM
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")

Utility Functions


Back to top
     FilenameSizeLast ModifiedDescription
smfJoin-Function.html--
2011-11-29 04:42 PM
Documentation for smfJoin function
smfStrExtr-Function.html--
2012-07-12 08:39 AM
Documentation for smfStrExtr function
smfWord-Function.html--
2011-11-29 04:54 PM
Documentation for smfWord function

Yahoo Related Functions


Back to top
     FilenameSizeLast ModifiedDescription
RCHGetYahooHistory-Function.html--
2007-04-03 05:05 PM
Documentation for RCHGetYahooHistory function
RCHGetYahooQuotes-Function.html--
2007-09-28 09:00 PM
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")
smfGetYahooJSONData-Function.html--
2017-04-24 05:00 PM
Documentation for smfGetYahooJSONData function
smfGetYahooJSONField-Function.html--
2017-05-01 11:00 AM
Documentation for smfGetYahooJSONField function
smfGetYahooOptionQuote-Function.html--
2010-09-11 12:48 AM
Documentation for smfGetYahooOptionQuote function
smfPricesBetween-Function.html--
2007-10-15 11:35 PM
Documentation for smfPricesBetween function
smfPricesByDates-Function.html--
2009-01-02 02:59 AM
Documentation for smfPricesByDates function