Hi all - I've been using the add-in for years, mainly for GetYahooHistory purposes and it has been great. I have also used the GetElementNumber functions...
I have a list of municipal and corporate bonds for which I want to pull price quotes, etc. This information can generally be found on Fidelity, Schwab, you...
Anybody having trouble in Excel 2003 with retrieving yield data from Yahoo? I am using Yahoo Finance tag "y" for yield in my array formula. The data is there...
Is it possible to download a specific minute with the SMF Add-in? For example, I would like to get close for 9:35 AM; I currently am getting open, but have to...
I've been running the add-in on my desktop for a while, but recently had a major crash on that machine. In the meantime I'm using my laptop which has...
Randy, Last week you helped me with the sfWord UDF function (below) with the Q5 site. It works great. Is it possible to use that function with site below to...
Randy, First off I just wanted to say that your addin is amazing and thanks for helping all of us out! My question is regarding text files. My friend sent me a...
What are the usage rights for SMF Addin? i.e. If I wanted to build a program that used SMF to grab data to be used in the program, could I then sell the...
Dear Randy, I I have used rchgethtmltable to retrieve prices and update every 5 min with smfforcerecalculation macro. but force recalculation refreshes...
Hi- I'm trying to determine if its possible to get the lowest low price over any date range in one cell of Excel. I've tried the below, but it seems to only...
Hi folks, I was just wondering if anybody has a clue on how to retrieve more than 200 stock info into an excel sheet in one go? Many thanks in advance for any...
Hi, I've got a couple of screening approaches that I'd like to validate, but need access to some morningstar data in a time-series format to try them out. ...
So there has been a recent switch from OPRA ticker construction (DVN PL) which you could look up using rchgetyahooquotes("dvnpl.x","p"). Now with OSI ticker...
Is it possible to limit or manage the copies of intra-group communications I receive? I now apparently receive individual copies of each communication, most of...
Randy, I was trying to modify your RCHCreateComment() code so that "type 2" would give a P&F Chart from StockCharts that had little bit more information such...
Hi, can anyone tell me how to get option price quotes using the new option tickers? I updated to latest SMF (version j) and changed my tickers, but it does not...
Hello Group, I have recently installed AAII's SI Pro, and I know there have been a few references to the data on the group board. I am still a little unclear...
Hi, I would just like to let you know that this simple charting (neat feature by the way) has a conflict with the Data AutoFilter function (drop down and quick...
Hi Randy, I have a nice spreadsheet set up using Morningstar data. Thanks for the help in making it happen. I'm finding a few problems with the Morningstar...
Hello, first of all, many thanks of making such great add-in available! Awesome stuff, really? I'm a newbie and just started to explore and experiment with the...
Hello, Could somebody please tell me how to add the syntax to include F9 refresh function. Here is my formula =RCHGetYahooQuotes(A7:A100,B6:AA6) thanks! Eric...
I am new to this group, and have no problem working the RCHGetYahooQuotes function, but can't avoid getting an "Undefined" error when trying to use...
Good news: I bought a new computer for home use. For business reasons I got XP Pro and Excel 2003. (The business can not afford 7 new computers at this...
