Hi, sorry if this is a beginner's usual problem but I couldn't find out how to sort it. When I use RCHGetYahooHistory (7 columns, several row), I only retrieve...
I just tried it for ticker symbol "^DJI" and it worked fine for me. It could be the ticker symbol you're using, or a temporary glitch with Yahoo (they've been...
Randy: I have been using your SMFUpdateDownload table for a few months and it is awesome for picking up basic data from the various sources - thanks! I track...
It's not possible "as is". That's because the macro runs based on the location of the cell named "Ticker". So when you run the macro, it would only run on...
I believe I will combine them into one and then sub-worksheet the various categories, as I am only slightly familiar with VBA routines. Thanks for the...
Randy, I am having a problem with RCHGetTableCell() used for Reuters estimates downloading. I use the method in a way similar to yours as in your template, but...
The add-in is designed for ad hoc reporting, not for bulk downloading. It can only handle grabbing of data from 1000 web pages per session. That's because the...
Randy: I use your spreadsheets everyday, it has made a tremendous difference in how much data I can sift through each day quickly on 10 or so companies. I just...
The first problem is that the first place "date" is found on the page is in the metatag that tells when the web page was updated, NOT the header of the table...
Excel 2003 I have tried getting premarket quotes into Excel for a while now. I noticed today that Yahoo has real-time premarket quotes however when I try to...
Dear Randy, Created file to get historical data vertically. Tried to create file that can display historical data horizontally but failed. Attached file for...
You'd need to transpose the data returned by the function. For an example, see: http://finance.groups.yahoo.com/group/smf_addin/message/2684 By the way, if...
Dear Randy, Tried recreate with the "TRANSPOSE" added. However, some setbacks. Attached file. Kindly advise what goes wrong. Thanks. Rgds, Hao Chai Shen Randy...
I am trying to run an if() statement with a gettableCell when a certin condition is met, in this case its a vertical table (2) columns, and I want.... if() rt...
I am unclear on how the add-in refers to tickers or symbols. It appears that ADVFN data refers the to ticker Symbol I manually enter in a cell, and then uses...
The element numbers available from the RCHGetElementNumber() function are simply those that have been pre-programmed, and those element numbers represent...
It's just a cell reference. You can refer it to any cell you choose. Or you could hard-code the ticker symbol into the URL string and drop the reference....
Randy--Amazing product!! I am having trouble pulling foreign pinksheet data. For example: Heineken is listed on Yahoo as HINKF.PK. The pinksheet symbol is...
I am working with the rchgetTableCell the table i want has the first word "merged" with its bottom cell.. so its hard for me to postion the function...
... Randy: I've been going to ask - What would that extraction look like? Would you use SUBSTITUTE "xxx","" where the x's are any combination of numbers or...
The formula returns something like "Bearish (-0.37)", so I think the easiest thing to do would be to take the entire string to the left of the first...
The Zacks screener would probably be a good way to go. You can screen by the percentage of surprise for each of the last two quarters of reported earnings. ...
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.
