Your problem is the "Low" is not a sufficient placement string to find the table you are trying to get. Try this, array-entering it over 5 columns and ... ...
2602
Randy Harmelink
rharmelink
Sep 3, 2007 8:46 am
Another attempt at non-wrapping formulas for grabbing 52-week lows: =RCHGetHTMLTable("http://quote.morningstar.com/highlow.html",">Today's 52-week...
2603
smf_addin@yahoogroups...
Sep 3, 2007 8:54 am
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 : /Uploads by...
2604
wabmester
Sep 4, 2007 7:55 am
I'm getting odd dividend yield values for some tickers. For example: =RCHGetYahooQuotes("FDC","y") returns 58.04, and MO has a yield of 36.28. Most other...
2605
Randy Harmelink
rharmelink
Sep 4, 2007 8:31 am
Those numbers appear to be correct, more or less. The reason the numbers appear so unusual is that they are the TRAILING dividend amount and yield, inflated...
2606
sergeh3
Sep 5, 2007 3:48 pm
does anyone know if yahoo, etc allows us to use these functions for "bulk downloads". i am not talking about abusing the system with bulk stock updates ...
2607
Martin Topper
mtopper
Sep 5, 2007 5:31 pm
probably not - for example, they limit individual quote retrieves to 200 I think. what do you mean by BULK Downloads? Marty ... From: sergeh3...
2608
troypahrrk
Sep 5, 2007 6:06 pm
Just curious, I couldnt get the non-wrapping formulas to work either.... did they happen to work for you?...
2609
Randy Harmelink
rharmelink
Sep 5, 2007 6:23 pm
I just went to the Yahoo group, brought up the second message with the non-wrapping formulas (in a table), then cut and pasted them one by one. All of them...
2610
Martin Topper
mtopper
Sep 5, 2007 6:23 pm
=RCHGetHTMLTable("http://quote.morningstar.com/highlow.html",">Today's 52-week Lows",1,"",2) The above formula worked for me. (Don't forget, it must be array...
2611
troypahrrk
Sep 5, 2007 9:12 pm
Thanks for that followup, I was able to get it to work after I reopened excel and visited the Morningstar site.... I think the cookie, etc. must have been what...
2612
Randy Harmelink
rharmelink
Sep 5, 2007 11:04 pm
Given the number of tools that use the Yahoo current quotes interface, I doubt they have a problem with it. But, as mentioned, they do limit it to 200 tickers...
2613
Randy Harmelink
rharmelink
Sep 5, 2007 11:11 pm
There have been short discussions of parsing SEC filings in the past. In general, my view is that it would be a waste of effort because of the changes that may...
2614
smf_addin@yahoogroups...
Sep 6, 2007 1:03 am
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 : /Add-In...
2615
Randy Harmelink
rharmelink
Sep 6, 2007 1:32 am
Overview of changes for version 2.0f: -- Added parm to RCHGetYahooQuotes() function to allow refreshing of quotes when spreadsheet recalculates -- Fixed...
2616
Jan-Erik Fougli
jefougli
Sep 6, 2007 4:39 am
What is the password used to extract the zip file? Thanks, Jan-Erik ... supplementary files. You would extract all of the files into the "C:\Program Files\SMF...
2617
Randy Harmelink
rharmelink
Sep 6, 2007 4:45 am
??? It's not password protected. I just tried it and it never asked for a password....
2618
Jan-Erik Fougli
jefougli
Sep 6, 2007 5:34 am
I got it now, not sure what was going on the last time. Thanks, Jan-Erik ... a password....
2619
Don Guillett
donaldb36
Sep 6, 2007 6:52 am
You can write a macro to loop 200 at a time. I recently did this for a client for currency trading history at 200 0 at a time. I did say 2000 days of currency...
2620
Randy Harmelink
rharmelink
Sep 6, 2007 7:23 am
The limit of 200 is on the number of ticker symbols for a current quotes request using the RCHGetYahooQuotes() function. The only limit on the amount of...
2621
sergeh3
Sep 6, 2007 11:58 am
Thank you everyone for your help, and above all your patience. ... interface, ... limit ... function ... I ... RCHGetElementNumber() ... retrieve ... speeds ...
2622
Tim
timbabear
Sep 6, 2007 1:38 pm
Hi Randy! I've been distracted this last week and have not been able to attempt to get my spreadsheet running again until now. To refresh your memory my system...
2623
Tim
timbabear
Sep 6, 2007 3:18 pm
A further update.... When I opened Excel, on the blank notebook it automatically opens, I went to TOOLS==>ADD-INS==>BROWSE then went to the Program Files\SMF ...
2624
Randy Harmelink
rharmelink
Sep 6, 2007 3:24 pm
The problem is that when you save an EXCEL workbook that uses an add-in function, it saves a hard-coded path to the location of the add-in. It appears you...
2625
edgarmusgrove
Sep 6, 2007 3:39 pm
... Thank you! I did find a workaround: =(RCHGetYahooQuotes(K5,pTwo))*100/100 Excel treats the text return correctly as a number in the above formula. Of...
2626
Tim
timbabear
Sep 6, 2007 5:10 pm
WHOOOOOOOOO HOOOOOOOOOOOOOOOOOOOO!!!!!!!!!!!!!!!!!!!!!!!!!! THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU As you might by now suspect, it is...
2627
troygaunt
Sep 6, 2007 5:39 pm
Is anyone having trouble getting yahoo quotes the past couple of days? I've been using this add-in for about 6 months and it stopped working yesterday. The...
2628
madaan.nitin
Sep 6, 2007 7:18 pm
Hi I have been working of RCH function from last one month. I found it very usful in facilitating my work But i am not able to retrive data for the following...
2629
Martin Topper
mtopper
Sep 6, 2007 7:44 pm
Secondly from this i want to know whether we can change source of information or not Like Yahoo Finance apart from Google finance I think there are element...
2630
Randy Harmelink
rharmelink
Sep 6, 2007 8:13 pm
It's erroring out because Google keeps changing the page layout. It still works most of the time for me, but I had to switch the process over to use the IE...
