You have to select the whole array, delete it, delete the column, then array enter again. Alternatively, you can just "Hide" the column in question. Gary H....
14885
Michael Thomas
thomas91112
Jul 1, 2011 8:57 pm
Use RCHGetYahooHistory to retrieve end-of-month stock market prices. Noticed yesterday, June 30 (after market close), that while Yahoo posted the closing...
14886
alexander
life2539
Jul 2, 2011 6:36 am
Just curious, Has anybody looked up data from cia.gov factbook? I would like to pull some economic information about countries particularly their ranking...
14887
investor952
Jul 2, 2011 6:53 pm
"Make sure your Internet Options under IE are set to always get new content when a web page is visited. Otherwise, Microsoft's Internet engine could be...
14888
guilldan
Jul 3, 2011 10:36 pm
Hello, First, thank you Randy for making this add-in. I am doing some fund analysis on Morningstar and have noticed that some of the data links are incorrect....
14889
dustinkw@...
dustinkw...
Jul 3, 2011 10:37 pm
I've been attempting to learn how to use the SMF add-in. I was trying to import data from selected cells of the MSN Financials website. For an annual income...
14890
John Smith
raftingchina
Jul 3, 2011 10:39 pm
Hello, Can anyone help me with this? The Reuters data elements and template don't work for me. Specifically, I'm talking about retrieving elements 13626...
14891
dustinkw@...
dustinkw...
Jul 3, 2011 10:39 pm
On several occasions I've noticed incorrect data reported in financial statements from some of the commonly used finance websites. One example: on the annual...
14892
somerset46m
Jul 3, 2011 10:41 pm
Hi Randy, When I was on Excel 2007 and Vista, SMF Add-in worked great. But since moving to Win7, it's been a no go. Any ideas what to do?...
14893
Randy Harmelink
rharmelink
Jul 3, 2011 11:04 pm
I would suspect you could, but since I don't subscribe, I can't give details. Off hand, it would seem the easiest thing to do would be to use the ...
14894
Randy Harmelink
rharmelink
Jul 3, 2011 11:06 pm
Sorry. Not a clue. I'm still on Vista....
14895
Randy Harmelink
rharmelink
Jul 3, 2011 11:10 pm
It's just normal EXCEL string concatenation: ="...string1..."&A1&"...string2..." They aren't alternative web addresses. In general, URL parameters can be given...
14896
Won-Jae
jay_lee2037
Jul 3, 2011 11:23 pm
Dear Randy: I have a question regarding pulling yellowpages below. the "D4: =RCHGetWebData($D$3,C4) " does not work properly, specifically D4 does not grap...
14897
Won-Jae
jay_lee2037
Jul 3, 2011 11:23 pm
Dear Randy: I have a question regarding pulling yellowpages below. the "D4: =RCHGetWebData($D$3,C4) " does not work properly, specifically D4 does not grap...
14898
Randy Harmelink
rharmelink
Jul 3, 2011 11:40 pm
Hmmm. Not sure what they've changed. Makes me wonder if the content of the page is reliable from "session" to "session"? Try: ...
14899
Randy Harmelink
rharmelink
Jul 4, 2011 3:08 am
Try using the updated smf-elements-5.txt file in the "Works in Progress" folder......
Dear Sir, Is SMF Add-In work well in Excel 2003? Many Thanks! Will...
14902
Randy Harmelink
rharmelink
Jul 4, 2011 12:29 pm
It should......
14903
comaxinfo
Jul 4, 2011 12:29 pm
I tried on Excel 2007 It worked well cant say about Excel 2003...
14904
alexander
life2539
Jul 4, 2011 12:44 pm
Just some explanation to the AdvFn data. It seems that they are pulling their data off of Morningstar Reports if available BUT they are using "as of reporting"...
14905
Fred Wright
fredwwright
Jul 4, 2011 3:28 pm
I am successfully using it on a Win 7 machine and the add-in works fine MOST of the time. It seems to have problems with internet cookies (I have IE 9 and...
14906
Pete
option2z
Jul 4, 2011 4:17 pm
I've been on Windows 7 for well over a year, and heavily use the Add-In. What symptoms are you having? I doubt that it has anything to do with Win 7. What...
14907
Ron Spruell
hashky
Jul 4, 2011 5:04 pm
You have to login using IE, not Firefox. Excel uses IE. ________________________________ From: Fred Wright <fredwwright@...> To:...
14908
rcstrauss
Jul 4, 2011 5:04 pm
Randy First let me thank you for sharing your great work with us. I am a frequent user of the SMF Add-in and really appreciate all it can do. I am trying to...
14909
Ron Spruell
hashky
Jul 4, 2011 5:12 pm
No problem using Excel 2003. Ron Spruell ________________________________ From: cocoaacc <cocoaacc@...> To: smf_addin@yahoogroups.com Sent: Monday,...
14910
Randy Harmelink
rharmelink
Jul 4, 2011 5:12 pm
It seems to be fairly straight-forward usage of the RCHGetTableCell() function. For example: ...
14911
Randy Harmelink
rharmelink
Jul 4, 2011 5:14 pm
And I actually recommend using the EXCEL Web Query version of IE to log in. It appears with later updates that the browser version of IE and the Web Query...
14912
Randy Harmelink
rharmelink
Jul 4, 2011 5:29 pm
They don't have well-formed HTML tables, so the normal functions aren't going to be of much help. You could do manual parsing of the data, but it would...
14913
rcstrauss
Jul 4, 2011 7:55 pm
Randy Thanks for the quick response. When I do a copy of the formulas in your reply and paste them into Excel they work great. However, when I tried to get...
