Randy, Let me first compliment you on creating a revolutionary piece of software that, for the first time, single-handedly equalizes the playing field between...
Please use this thread to document ticker syntax that changes going from Yahoo to other data providers. For example, the latest syntax translation I added was...
Hi Randy, I have not been able to get smfPricesByDates(Symbol, Date) to work for several symbols .... CSGH, NEWN, and CHWY. Other symbols work fine. Any...
Randy, This is, and has been, an excellent add-in, and I've gotten quite dependent on it. It runs fine with Excel 2k7 and WinXP Pro, but I'm having a...
Where is a good place to pull dividend dates? I find Yahoo a bit inconsistent. I have a dividend strategy that works well, it is a lot of work to screen for....
All - Does anyone have a source for getting open interest for an individual option? For example on the GE 17.50 call, I want to be able to view the day-to...
I am looking to pull ADJ CLOSE from Yahoo finance for multiple tickers in a table format: ADJ CLOSE MSFT IBM .. .. .. GOOG 1/20/2009 1/21/2009 1/23/2009 .. .. ...
On Morningstar page, http://quicktake.morningstar.com/FundNet/Snapshot.aspx?Country=USA&pgid=hetopquote&Symbol=vtsmx or http://tinyurl.com/277ckc I have been...
Just uploaded a stock screener workbook that pulls data from finviz.com, then allows you to filter (screen) on it from within Excel. It also allows you to...
Hi folks, 1. I'm trying to setup the Expense Ratio column for various ETFs. If I'm not mistaken, the proper function is "=RCHGetElementNumber("XLF",5079)....
Hello, I was pointed to this group from someone on the TC2000 yahoo group. I've been trying to retrieve price and percentage change data for stocks using the...
Hi Randy, In an earlier message, you recommended another company's ADD-IN for tech functions. I was unable to load the TA-LIB add-in, so I am learning how to...
Hi I need a little help. I modifing a Spreadsheet that uses the =RCHGetElementNumber(Symbol,X). The probelm I'm having is that the spreadsheet uses two...
Source Yahoo Finance. Once you type in any symbol, it gives you a menu on the left side with links - quotes, charts, news and info, company... etc each with...
Hi Randy (or anyone else who is able to help), I'm trying to retrieve the exit price of a fund from ninemsn (MSN in Australia), for example at the following...
Can anyone give me some guidelines as to how I could use the smf add-in or one of the templates to extract data from the following site. finviz.com On the main...
Hello, On a separate note, I was reading the documentation for the functions RCHGetTableCell() and RCHGetWebData(), and was wondering if it possible to use one...
Randy, I had started this on a previous thread, but now have made it separate, since I want to present the query with an example. I open a new work book, it...
Just added an Industry Overview workbook (leveraging SMF Lite). This allows you to monitor daily performance of the Yahoo specified industries, as well as the...
Hey Randy, I would like to follow-up on a reference made to page views at IBD a while back. Each time one of us uses the add-in to acquire data from a...
Randy, two things: 1. Any thoughts about migrating the smf elements files to sit on a server some where? Users could then more easily decide whether they...
I just tried to create a sheet using AFN as my source because I liked the 10 years of data. I am using the newest SMF files and looked at the Element...
element # codes for Google annual revs not working. Seem to be grabbing the wrong row (used to work). How can i fix? =RCHGetElementNumber("MMM",3308) same for...
Randy - I use this to calculate equity growth in a Rule #1 type valuation template. Any idea on why this changed and where I could get a substitute value? ...
Having problems with message search?
