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...
5022
smf_addin@yahoogroups...
Sep 1, 2008 7:31 pm
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...
5023
rnfermincota
Sep 1, 2008 7:35 pm
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...
5024
ja000
Sep 1, 2008 8:47 pm
Do you have an add-in that will be bale to login to a broker's website? Tks, -- Jack Albert...
5025
Randy Harmelink
rharmelink
Sep 1, 2008 8:54 pm
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...
5026
feshipley
Sep 2, 2008 10:30 pm
... website? ... I wouldn't mind having a template for logging into Yahoo. I probably can modify it to do other web sites....
5027
Randy Harmelink
rharmelink
Sep 2, 2008 10:43 pm
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...
5028
Rafael Nicolas Fermin
rnfermincota
Sep 2, 2008 10:45 pm
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...
5029
bramraika
Sep 3, 2008 2:52 am
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...
5030
Randy Harmelink
rharmelink
Sep 3, 2008 2:58 am
Sure. Just use the RCHGetYahooHistory() function. For example, this formula will get adjusted weekly prices for IBM: =RCHGetYahooHistory("IBM",,,,,,,"w",,,1)...
5031
bramraika
Sep 3, 2008 3:33 am
Thanks a lot Randy, That worked wonderfully.. Thank you so much for your help.. Best. ... this ... close) ... price ... of me...
5032
Debbie Sheperd
sheperd0
Sep 3, 2008 5:58 pm
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...
5033
Randy Harmelink
rharmelink
Sep 3, 2008 6:01 pm
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?...
5034
Debbie Sheperd
sheperd0
Sep 3, 2008 6:05 pm
wow thanks for prompt reply --- error: #NAME? Excel 2003 .... Debbie ... From: Randy Harmelink <rharmelink@...> To: smf_addin@yahoogroups.com Sent:...
5035
Randy Harmelink
rharmelink
Sep 3, 2008 6:11 pm
#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...
5036
Debbie Sheperd
sheperd0
Sep 3, 2008 6:18 pm
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 ...
5037
Randy Harmelink
rharmelink
Sep 3, 2008 6:32 pm
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") ...
5038
Debbie Sheperd
sheperd0
Sep 3, 2008 7:40 pm
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...
5039
keithfg
Sep 4, 2008 8:23 pm
smfUpdateDownloadTable element 25 It pulls all other data in the table for other tickers but returns an error for EWT Any suggestions? Thank you...
5040
wlittlej
Sep 4, 2008 8:24 pm
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...
5041
Randy Harmelink
rharmelink
Sep 4, 2008 8:30 pm
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...
5042
Randy Harmelink
rharmelink
Sep 4, 2008 8:32 pm
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 =...
5043
Martin Topper
mtopper
Sep 4, 2008 8:35 pm
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...
5044
drbaud
Sep 4, 2008 8:44 pm
Does anyone know of add-in or VBA that can aggregate some number of online accounts - without the usual exporting/importing by hand method? Baud...
5045
wlittlej
Sep 5, 2008 12:28 am
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...
5046
wlittlej
Sep 5, 2008 12:31 am
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...
5047
Randy Harmelink
rharmelink
Sep 5, 2008 1:27 am
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...
5048
Randy Harmelink
rharmelink
Sep 5, 2008 1:30 am
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...
5049
Ralph Bagwell
ralphbag
Sep 5, 2008 12:08 pm
Randy, what version is current now? I use 2.0h. ... Maybe I missed something. Thanks a lot. Ralph...
5050
wlittlej
Sep 5, 2008 12:22 pm
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...