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....
145
Martin Topper
mtopper
Aug 3, 2006 5:47 pm
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...
146
lak_fin
Aug 3, 2006 10:35 pm
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...
147
Sia
sia_nyc
Aug 4, 2006 12:11 am
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...
148
Randy Harmelink
rharmelink
Aug 5, 2006 3:20 pm
... You could always change the formula for those that have percentages in them. For example: =VALUE(LEFT(RCHGetElementNumber("YahooMS",13822), FIND("...
149
Randy Harmelink
rharmelink
Aug 5, 2006 3:29 pm
... 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...
150
Randy Harmelink
rharmelink
Aug 5, 2006 4:14 pm
... You mentioned in another thread you had problems using the RCHGetHTMLTable() function to do this? I was able to get them. For calls: ...
151
Mark Bray
mj_bray
Aug 5, 2006 6:11 pm
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...
152
Mark Bray
mj_bray
Aug 5, 2006 6:20 pm
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,...
153
Randy Harmelink
rharmelink
Aug 5, 2006 6:38 pm
... If you get to this point, you can fix things by changing all occurrences of: "'http://www.ruleoneforum.com/Program Files\SMF ...
154
Mark Bray
mj_bray
Aug 5, 2006 6:45 pm
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...
155
Mark Bray
mj_bray
Aug 5, 2006 6:47 pm
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...
156
Randy Harmelink
rharmelink
Aug 5, 2006 6:49 pm
... 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...
157
Randy Harmelink
rharmelink
Aug 5, 2006 7:01 pm
... Have you asked whether those fundamental data values are "as of" or hindsight values? For example, if a company were to spin off part of their...
158
Randy Harmelink
rharmelink
Aug 5, 2006 7:09 pm
... 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...
159
Randy Harmelink
rharmelink
Aug 5, 2006 7:16 pm
... Hmmm. Different version of EXCEL? Does it have all of the necessary reference libraries? Did: =RCHGetElementNumber("Version") ...also return "Error"?...
160
Randy Harmelink
rharmelink
Aug 5, 2006 8:00 pm
... 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...
161
Mark Bray
mj_bray
Aug 6, 2006 1:15 am
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 ...
162
Edd Rhoades
eddr73003
Aug 6, 2006 3:08 am
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...
163
Ron Gaillard
rgaillard
Aug 6, 2006 6:58 pm
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...
164
Lakmal Jinadasa
lak_fin
Aug 7, 2006 2:43 am
Thank You very much for the help. I am going to try this in my worksheet. This is a great group. Thank you Guys. Ron Gaillard <ron.gaillard@...>...
165
laurancehill
Aug 7, 2006 6:45 pm
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...
166
coloradomonkey
Aug 7, 2006 7:21 pm
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...
167
Randy Harmelink
rharmelink
Aug 7, 2006 8:13 pm
... 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...
168
Randy Harmelink
rharmelink
Aug 7, 2006 8:18 pm
... "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...
169
coloradomonkey
Aug 7, 2006 11:14 pm
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...
170
ttwilt
Aug 8, 2006 1:23 am
I noticed "=RCHGetElementNumber(A3,25)" delivers a different price depending on whether the symbol is entered in small letters or all CAPS. For instance...
171
Randy Harmelink
rharmelink
Aug 8, 2006 1:46 am
... 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...
173
cykwan80
Aug 8, 2006 4:29 am
I see, It works fine using the method that you describe above. However, as I have all of my 200 stocks on the A column, in step 1 I type in...
174
cykwan80
Aug 8, 2006 4:37 am
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...
