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....
Use RCHGetYahooHistory to retrieve end-of-month stock market prices. Noticed yesterday, June 30 (after market close), that while Yahoo posted the closing...
Just curious, Has anybody looked up data from cia.gov factbook? I would like to pull some economic information about countries particularly their ranking...
"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...
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....
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...
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...
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...
It's just normal EXCEL string concatenation: ="...string1..."&A1&"...string2..." They aren't alternative web addresses. In general, URL parameters can be given...
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...
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...
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"...
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...
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...
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...
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...
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...
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...