I still do not know how to use the above three add-in functions. I try to array enter the formula, but nothing shows up (blank table). Please help Randy....
A partial explanation: I have been trying to use these formulas too and made a breakthrough discovery yesterday!! first of all the add in must be selected. i...
I am not sure whether this is to be done from Excel it self. Is there a way to add an autoupdate function. May be add a button to the excel sheet to update the...
I have the same issue, I want to bring in Options information into Excel from a a yahoo or BW webpage but I cant use the RCHGetHTMLTable () function. Any...
... You could always change the formula for those that have percentages in them. For example: =VALUE(LEFT(RCHGetElementNumber("YahooMS",13822), FIND("...
... Only to the extent that they are carried on some of the financial statement data pages. For example, historical values of the price to cash flow ratio can...
Yeah, that's kind of what I thought, although I had to ask. Thanks. ... From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy...
This formula finds the position number of the space, asks Excel to only return the characters to the left of that space using the position number as a guide,...
Randy (and anyone else who's interested), I misspoke in a prior post when I said I was considering Portfolio123-I am considering it, but that wasn't what I...
My vote would be to drop the percentages as they are easily recreated with formulas, but either way is ok with me. ... From: smf_addin@yahoogroups.com...
... If you're still having problems, here's another technique I use to array-enter these formulas: 1. In A1, enter: =RCHGetYahooQuotes("MMM,IBM","sl1") ...and...
... I did a step-by-step example in an earlier message that might help: http://finance.groups.yahoo.com/group/smf_addin/message/124 Also, if you check out the...
... Hmmm. Different version of EXCEL? Does it have all of the necessary reference libraries? Did: =RCHGetElementNumber("Version") ...also return "Error"?...
... I think that would need to be done from EXCEL itself. None of the functions are identified as volatile, which means they should only recalculate when one...
I've not made any contact with them as of yet, but you've given me some good ammo. ... From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On ...
When I went back in and saved the file by right clicking on the link and using "Save Target As" instead of opening the file from the web and then using the...
I generally use the on-time routine for a timer function. Interval in seconds is set in public variables (line 2), The name of the sub to run is entered in...
Randy, The links to most of your documentation are not working for me. Are they not yet available? My question is: I want to know if your add-in has the...
Anyone have any suggestions on what to use for 10-year financial data until the MSN elements work again? I tried the AdvFN-A elements but I'm getting a return...
... I'm not sure which links you are referring to? The library links I tried worked for me. ... Yes. Depending on what you're looking for, you should be able...
... "EOL" is a value I threw in to indicate "End Of List", which means you are asking for an element number that is outside of the available range. If you are...
Randy, you're a genius and a gentleman! I was using an older add-in but once I switched to 1.3c I was good to go. ... wrote: I suspect you are using an old...
I noticed "=RCHGetElementNumber(A3,25)" delivers a different price depending on whether the symbol is entered in small letters or all CAPS. For instance...
... All the add-in is doing is returing what the web page is reporting, so the two services (Business Week Online vs MSN) can definitely return different...
I am sorry but I am not getting it. Can someone please elaborate on how to set up this sub thing up or Randy's dummy-variable macro as I do not know much...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
