I am having similar problems with Yahoo (this is not the first time they have done something to slow down the process and otherwise cause Excel to run...
19658
Randy Harmelink
rharmelink
Aug 16, 2012 9:26 pm
Well, the original message was on the RCHGetYahooQuotes() function, which has nothing to do with options. RCHGetYahooQuotes() gets a CSV file, with as much...
19659
blc6@...
blc6@ymail.com
Aug 17, 2012 1:31 am
Stockcharts agreement with their data provider is that they can not distribute the raw data. They do display a small portion of the data via the past data link...
19660
clemer2001
Aug 17, 2012 7:04 am
MSN' StockScouter seems to change from time to time. At least I'm not able to retrieve the StockScouter Rating any more. Any assistance appreciated! Also,...
19661
Randy Harmelink
rharmelink
Aug 17, 2012 7:10 am
I just tried element #543 with MSFT and it worked fine for me -- do you have the updated element definitions from the "Works in Progress" folder? MSN changed...
19662
nuno.nogueira
Aug 17, 2012 7:37 am
I'm using SMF lite for US and European stocks and they all take a lot of time (10-15 seconds) to refresh....
19663
mkorgie
Aug 17, 2012 1:01 pm
I experience the slowness when retrieving about 50 tickers with 10 calls each to RCHGetYahooQuotes. I use the SMFUpdateDownloadTable macro to advance through...
19664
Randy Harmelink
rharmelink
Aug 17, 2012 4:59 pm
Why not change those 500 calls into a single call by using an array-entered RCHGetYahooQuotes()? If you want values, you could even write a short macro to fill...
19665
rr76012
Aug 17, 2012 6:07 pm
re: Yahoo Analyst Opinion Hello Randy, I have looked, but I may have overlooked rchgetelementnumber numbers for the Yahoo Analyst Opinions on Price Target...
19666
Randy Harmelink
rharmelink
Aug 17, 2012 6:22 pm
That table and those items are probably new since I did the element numbers. Actually, it looks like there are no elements from that page. I wonder if the...
19667
mkorgie
Aug 17, 2012 7:40 pm
Very nice Randy! ... you make me smarter everyday! I generalized your suggestion and it's lightning fast. This way I can insert ticker rows and add/change...
19668
Vinod
vinod_24
Aug 18, 2012 12:41 am
Randy/Mike, I new to this group. Tried to use the array formula like RCHGetYahooQuotes(A4:A500,l1,,NOW()) But is doesnt work. If I put A4:A100 then it works ...
19669
Randy Harmelink
rharmelink
Aug 18, 2012 1:21 am
Yahoo limits the returned CSV file to 200 ticker symbols. Also, I'm assuming you wanted the second parameter to be an "l1" string -- you're giving it a cell...
19670
Bob
rkdmon
Aug 18, 2012 8:07 am
Over the past few days I tried variations of: number of ticker updates, markets USD/EUR/CHF etc and thru Friday evening it was still problematic as reported -...
19671
rr76012
Aug 18, 2012 1:21 pm
Hi Randy, Here is a link, http://finance.yahoo.com/q/ao?s=EXC+Analyst+Opinion It is located Yahoo left side , Analyst Coverage, then under Analyst Opinions. ...
19672
jr105_
Aug 19, 2012 9:56 am
I am getting an error when trying to get % change for option prices. The only service to provide such is MSN, but in all instances the parameter "%" causes an...
19673
Randy Harmelink
rharmelink
Aug 19, 2012 10:46 am
I just tried these and they worked fine for me: =smfGetOptionQuotes("SPY 8/24 2012 $143 Call","%",,"MSN") =smfGetOptionQuotes("MMM Sep 2012 $95...
19674
rlee16
Aug 19, 2012 6:35 pm
Randy, Is there a way to get data from kr.finance.yahoo.com? (KOSPI and KOSDAQ)? Any simple change to the VBA that could do it (Korean stocks have .KS appended...
19675
Randy Harmelink
rharmelink
Aug 19, 2012 7:50 pm
Why can't you use the .KS suffix with the normal Yahoo website with the as-is Yahoo functions?...
19676
Ralph
ralphbag
Aug 20, 2012 1:13 am
Randy, would you be so kind as to ( again ) give me the formula to grab the price of the Mexican Centenario . I have spent over an hour with no success. The...
19677
Randy Harmelink
rharmelink
Aug 20, 2012 2:06 am
Your problem was probably that the date is presented within an HTML frame on the page. That means the data is actually at a different URL. This appears to...
19678
barbiegirl
pgh2377
Aug 20, 2012 1:08 pm
I'm really trying to work with the GetWebData function, unfortunately I feel like a pre-school kid in a high school chemistry class... I'm trying to obtain the...
19679
bob_cutillo
Aug 20, 2012 2:30 pm
Hi, First, Thanks for a great service. I want to capture website information from a password protected site. without password I am fine; Un-password protected...
19680
dguillett1
donaldb36
Aug 20, 2012 2:44 pm
I think Randy will tell you that you need to “log on” first. Don Guillett Microsoft Excel Developer SalesAid Software dguillett1@... From:...
19681
bob_cutillo
Aug 20, 2012 3:12 pm
Thank you for your help. I should have included that I had my browser, Foxfire, logged in already and even tried it from Excel ; Data / from Web. Although I...
19682
Randy Harmelink
rharmelink
Aug 20, 2012 4:03 pm
I only use RCHGetWebData() as a last resort. It's much easier to use RCHGetTableCell() for tabular data, or smfGetTagContent() for non-tabular data. For...
19683
Randy Harmelink
rharmelink
Aug 20, 2012 4:49 pm
Logging in with FireFox won't help. The add-in is using the XMLHTTP method to get data from the Internet. That's the same method both IE and EXCEL use. That...
19684
curls07
Aug 20, 2012 10:40 pm
Hi Guys, When I run a macro in a worksheet that contains rch get element functions, the functions recalculate every time the macro copies or pastes or...
19685
Randy Harmelink
rharmelink
Aug 20, 2012 11:53 pm
In general, the functions are non-volatile unless YOU make them volatile. For example, by making one of the parameters volatile. In any case, related to a...
19686
zarathustra_winced@...
zarathustra_...
Aug 21, 2012 12:04 am
I couldn't imagine calculating some of my worksheets with an rchgetelementnumber in each cell. It would be agonizingly slow. If you're using a macro to...
