Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the smf_addin group. File : /Uploads by...
smf_addin@yahoogroups...
Sep 1, 2008 7:30 pm
5022
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the smf_addin group. File : /Uploads by...
smf_addin@yahoogroups...
Sep 1, 2008 7:31 pm
5023
Dear Group, I just uploaded the ADVFN Financial Data Templates for Excel 2003 and Excel 2007. FileName: Excel_2003_ADVFN_Financial_Data.xlt ADVFN Financial...
You may not need one. I use the add-in to gather information from sites that require a login. For them, the key is to login to the site via IE or EXCEL's Web...
This message thread may help: http://www.wiredbox.net/Forum/Thread233009_Filling_out_usernames_in_IE.aspx It has code to open the IE object, fill in form...
Feshipley, With the following routine, browser open or closed makes no difference, but IE would have to be the browser you logged in with. Because this...
Hey Randy, Is there a way of getting weekly prices (open, high, low, and close) using the add-in? I am trying to find a way of getting weekly price histroy and...
Sure. Just use the RCHGetYahooHistory() function. For example, this formula will get adjusted weekly prices for IBM: =RCHGetYahooHistory("IBM",,,,,,,"w",,,1)...
Hi -- I've installed the add-on but not able to retrieve any prices --- just looking for basic historical data .... please let me know how to check and see...
What do you get when you use the formula below? Or, what do you get when you use this formula: =RCHGetElementNumber("Version") Which version of EXCEL?...
#NAME? usually means the add-in hasn't been installed properly -- EXCEL can't find the function name. I'll assume you unzipped the downloaded file? But did...
sorry to be so dense but yes it is selected when I look at my add-ins ...... ... From: Randy Harmelink <rharmelink@...> To: smf_addin@yahoogroups.com ...
Can you try the two functions in the thread so far in a new workbook, upload the workbook, and let me take a quick look? =RCHGetElementNumber("Version") ...
I think I got it!! Thanks so much!!! ... From: Randy Harmelink <rharmelink@...> To: smf_addin@yahoogroups.com Sent: Wednesday, September 3, 2008 2:31:55...
Randy- When I open SMF-Template-Morningstar-Total Return.xls and fill in any ticker symbol in cell B2, all calculated cells are filled with "Undefined". I had...
Element #25 comes from MSN's "Full Report" stock page from MSN, so it won't work for an ETF (or a mutual fund, for that matter). To get current quotes, you...
I suspect you didn't unzip all of the files into the same folder as the add-in? The element definitions are stored in external files: smf-elements-0.txt =...
you may have to eliminate this portion of each cell reference 'C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'! use Find and replace with "" (a...
Randy, Thanks for the reply. Remember now - you're dealing with a newbie. Let me restate my problem: Here is the file listing from my C:\Program Files\SMF...
Martin, Thanks for the reply. Unfortunately, I'm too much of a newbie to understand your suggestion. I don't know how to edit the source code. Thanks for your...
The typical reason for "undefined" is that the add-in was not able to read in the element definitions from one of the smf-elements-n.txt files. But if you...
I do some of that with the SMF add-in, but it does require me to first login manually to each of the online accounts using either IE or the EXCEL Web Query...
Randy, I get #NAME? in all cells the formulas you suggested I try. I'm using Excel 2000 vers 9.0.2720 and XP SP2 Morningstar.com is opened What now? Thanks for...