I think so -- try something like this: =RCHGetTableCell("http://www.bloomberg.com/markets/commodities/energyprices.html?dummy="&NOW(),1,"Nymex Crude Future") ...
Hi, RCHGetTableCell("http://www.investors.com/member/checkUp/checkUp.asp?t=csco,1,">Industry Group") returns with "Error". I do have an Internet Explorer login...
I just tried your formula myself and get "Computer-Networking". However, I have noticed distinct differences in some cases between how my new EXCEL 2007 and IE...
Upon upgrading my PC to Vista and EXCEL 2007, I found out I can no longer keep my add-in location under the "C:\Program Files" folder, as Vista locks me out of...
thanks Randy. I tried the web query route but that too fails to get data from investors.com. I get an error: "The web query returned no data". I have Excel...
... Question: Will this fix the problem that I had with Excel 2000 when transferring from one computer to another? If not, could a macro be written that...
In general, I would say that if the Web Query route gives you the "returned no data" message, the add-in probably will not work. I say that because I believe...
You should be able to repeat that same VBA statement multiple times, one for each hard-coded location you typically run into. If any given "find and replace"...
Randy - I thought (but I may be wrong) that if you are a local admin on vista you can then load files into the c:\program files directory. I'm on XP but I...
Randy - go here to read more about Vista and elevated priveleges. I think that this site may have the info to help solve your problem and to work with UAC ...
 Oops! Here's the url  http://www.computerperformance.co.uk/vista/vista_administrative_privileges.htm  Sorry for being to fleet of finger when typing.......
That might be the issue. I was the admin on XP, but am not on Vista... But I am able to ADD files to the directory. But it won't let me SAVE it from EXCEL,...
Hi, I am wondering if there is a problem with the RCH function as I have been unable to update my spreadsheets that used to work fine until last week. Most of...
Hi Randy, In Vista, try changing the user rights to smf_addin. To allow users to access the Program Files folder 'smf_addin' with CHANGE or FULL rights...
has anyone developed a spreadsheet they are willing to share which does backtesting? has anyone developed a spreadsheet they are willing to share base on ...
Thanks Randy and apologies for my sloppiness in not checking the threads first. I appreciate your help and hope that it gets back soon.. ... threaded=1&m=e ......
Randy, Will the cache get filled quicker from downloading information from 5 unique webpages vs. getting the exact data consolidate on 1 webpage like your...
The "saved web pages" array in VBA will fill up faster with 5 unique web pages, since each unique URL takes up one slot in the array. Actually, the main point...
"The problem is that there is no "hard-coded" way to determine what page the additional 5 periods of data are on. Unless you're ONLY interested in the first...
My problem was how to get the 6th and 7th years data items with FIXED parameters. If you have a solution for that, I'd be happy to see it. Otherwise, the...
I am not exactly what you mean by "FIXED parameters", but I will tell you the steps that I go through to generate the ADVFN pages. It is not very elegant but...
I was hoping you had a way to do it using a FIXED start_date value. That was the reason I had to go to the PHP routine -- so that I could make sure I had...
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 : /Requested...
smf_addin@yahoogroups...
Aug 28, 2008 12:36 am
5011
I just post a sample SS for AdvFN. No need to know how many fiscal year are available. First request doesn't specify a start_date ie AdvFn will respond the 5...
I fix a copy&paste mistake for YHOO. I also add sample for quarters. As it is a simple copy&paste with appropriate change in formula, I forgot to change...
It looks to me like the AdvFN elements are working again. Yahoo (my web host) told me the failure of the PHP functions I was using had to do with a "technical...
Randy, I just finished writing a versatile module to retrieve information from the ADVFN – for Canadian and US Companies. Please take a look and please feel...
