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 ... ...
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...
smf_addin@yahoogroups...
Sep 3, 2007 8:54 am
2604
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...
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...
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 ...
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...
=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...
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...
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...
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...
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...
smf_addin@yahoogroups...
Sep 6, 2007 1:03 am
2615
Overview of changes for version 2.0f: -- Added parm to RCHGetYahooQuotes() function to allow refreshing of quotes when spreadsheet recalculates -- Fixed...
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...
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...
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...
Thank you everyone for your help, and above all your patience. ... interface, ... limit ... function ... I ... RCHGetElementNumber() ... retrieve ... speeds ...
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...
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 ...
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...
... 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...
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...
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...
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...
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...
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.
