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...
4387
Randy Harmelink
rharmelink
Jun 2, 2008 9:47 pm
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...
4388
halandkeri
Jun 3, 2008 3:06 am
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...
4389
Randy Harmelink
rharmelink
Jun 3, 2008 3:23 am
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...
4390
halandkeri
Jun 3, 2008 4:35 am
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...
4391
ejnext
Jun 3, 2008 5:21 am
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...
4392
Randy Harmelink
rharmelink
Jun 3, 2008 5:27 am
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...
4393
dab_mango
Jun 4, 2008 12:21 am
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...
4394
Randy Harmelink
rharmelink
Jun 4, 2008 4:37 am
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...
4402
Christy Wagner
ericandchristy
Jun 4, 2008 7:07 pm
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...
4403
hao chai shen
haochaishen
Jun 4, 2008 10:14 pm
Dear Randy, Created file to get historical data vertically. Tried to create file that can display historical data horizontally but failed. Attached file for...
4404
Randy Harmelink
rharmelink
Jun 4, 2008 11:26 pm
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...
4405
hao chai shen
haochaishen
Jun 5, 2008 11:32 am
Dear Randy, Tried recreate with the "TRANSPOSE" added. However, some setbacks. Attached file. Kindly advise what goes wrong. Thanks. Rgds, Hao Chai Shen Randy...
4406
Randy Harmelink
rharmelink
Jun 5, 2008 2:58 pm
Go back and reread the message link I gave you. When you use the TRANSPOSE() function, you also need to pass two additional parameters to tell the...
4407
haochaishen
Jun 5, 2008 4:21 pm
Dear Randy, Thanks, solved the problems....
4408
asa32sd23
Jun 5, 2008 10:12 pm
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...
4409
aslanspirit
Jun 5, 2008 10:15 pm
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...
4410
Randy Harmelink
rharmelink
Jun 5, 2008 10:35 pm
Should be fairly straight-forward if I understand what you're asking. I'm thinking something like: ...
4411
Randy Harmelink
rharmelink
Jun 5, 2008 10:43 pm
The element numbers available from the RCHGetElementNumber() function are simply those that have been pre-programmed, and those element numbers represent...
4412
aslanspirit
Jun 6, 2008 7:50 pm
I see now what you are saying, makes sense on both using tablecell and element numbers. Thanks, Robb ... function ... web ... using ... ...
4413
aslanspirit
Jun 6, 2008 7:58 pm
Randy: How would I know to go to F11, 1 for the AdvFn Ford Ticker symbol? Thanks, Robb ... and/or ... in ... to...
4414
Randy Harmelink
rharmelink
Jun 6, 2008 8:06 pm
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....
4415
zanzi000
Jun 8, 2008 6:34 am
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...
4416
Randy Harmelink
rharmelink
Jun 8, 2008 8:49 am
Sorry, I have no idea...you already know more about the pink sheet items than I do......
4417
asa32sd23
Jun 8, 2008 7:17 pm
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...
4418
Randy Harmelink
rharmelink
Jun 8, 2008 8:01 pm
I think all you need is something like: =RCHGetTableCell("http://www.stockta.com/cgi-bin/analysis.pl?symb=MMM";,1,">Overall";,,,,1,"</table") ...
4419
halandkeri
Jun 8, 2008 11:26 pm
... 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...
4420
Randy Harmelink
rharmelink
Jun 9, 2008 12:22 am
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...
4421
dab_mango
Jun 9, 2008 1:06 am
Randy: Is there any good site that posts stocks that have beaten Analyst Earning Estimates by a big margin ? Thanks in advance...
4422
Randy Harmelink
rharmelink
Jun 9, 2008 1:21 am
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. ...
