> SMF add-in Top-Level Directory > Documentation |
> SMF add-in Top-Level Directory > Documentation |
In General: | Alphabetical List | |||
By Data Type: | Options | Utility | Macros |
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-07-30
|
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.html | Documentation 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.html | Documentation for smfJoin function | ||
smfPricesBetween-Function.html | Documentation for smfPricesBetween function | ||
smfPricesByDates-Function.html | Documentation for smfPricesByDates function | ||
smfStrExtr-Function.html | Documentation 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) |