> SMF add-in Top-Level Directory > Templates

             
In General: All Files Debug Recent Updates Dividends Options
By Function: RCHGetElementNumber() RCHGetHTMLTable() RCHGetTableCell() RCHGetYahooHistory() smfGetTagContent()
  smfGetCSVFile() smfGetOptionQuotes() smfGetYahooPortfolioView() smfPricesByDates() smfUpdateDownloadTable

Recently Updated Files

     Filename Last Modified Description
Stock Review.xlsx
2024-02-27
A template that will get stock data from various sources
smfGetEconData.xlsx
2024-02-18
A template that will get economic data from FRED
smfGetOptionExpirations-Strikes-Quotes-Example.xlsx
2024-02-05
A template that will get Option expirations, strikes and quotes
RCHGetElementNumber-Template-Zacks.xlsx
2024-02-27
A template that shows the data elements available from Zacks web page. Using the RCHGetElementNumber function
RCHGetElementNumber-Element-Definitions.xlsx
2023-02-12
A template that shows the data elements available from various sources. This is a list of elements that should still be working. Please report those that are not.
RCHGetElementNumber-Template-Yahoo-Key-Statistics.xls
2023-02-12
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 - Example - analyst ratings.xlsx
2023-06-08
A sample that shows using the RCHGetHTMLTable function to get the Analysit Estimates from the Yahoo! Analysis web page.
RCHGetYahooHistory.xlsx
2023-02-13
A template showing a small example of retrieving historical quotes from Yahoo using RCHGetYahooHistory() Function. All of the parameters for the function can be played with, to see how their changing values can change what the function returns.
smfGetYahooHistory Function
2023-03-17
A template showing an example of retrieving historical quotes from Yahoo using smfGetYahooHistory() Function. All of the parameters for the function can be played with, to see how their changing values can change what the function returns.
smfGetYahooPortfolioView-Example all elements
2023-03-27
A template showing an example of retrieving data from Yahoo using smfGetYahooPortfolioView() Function. This example has all possible elements for the function. Some elements still need to be tested as I belive some may now be incorrect. Some formatting may also need to be done for dates or values to display nicely.
smfGetYahooPortfolioView-Example
2023-03-27
A template from 2008 showing an example of retrieving data from Yahoo using smfGetYahooPortfolioView() Function.
smfGetYahooPortfolioView-Peter
2023-03-27
A template provided by Peter, showing an example of retrieving data from Yahoo using smfGetYahooPortfolioView() Function. This example also has a second sheet with all the elements listed.
smfPricesByDates-Example-Stocks-By-Dates.xls
2023-03-17
A template for smfPricesByDates showing retrieval of prices by dates for a number of stocks, for a column of ticker symbols and a row of dates.