Hi Randy, I have to begin by thanking you most sincerely for generously sharing your wonderful VBA code with the world. I have written some Excel VBA download...
I was able to get to a smaller URL for the frame address. However, although ... Const kURL = "http://apps.cnbc.com/view.asp?uid=stocks/earnings&symbol=IBM" ...
Good Morning Randy, Wow, I banged my head against a wall for a day and a half on this and you came up with something in a couple of hours. While you may not ...
... It was the "link" that was attached to the "onMouseOver" attribute for each bar on the graph, so I just decided to try it as-is. To tell the truth, I...
I have tried using =RCHGetTableCell ("http://finapps.forbes.com/finapps/jsp/finance/compinfo/Earnings.jsp? tkr="&$A2,2,"Estimated Fiscal Earnings",,,2,) By...
Hats off to you Randy from another retired fellow. I just came across your group for stock market jobs as I am learning it after retirement. Though I didn't...
... That particular formula worked fine for me on the 14 tickers I tried it on: MMM4.97 ERES0.29 IBM6.97 MRO6.03 ASPV4.24 ENH6.81 CFI0.54 HWCC1.59 TX4.38 ...
I THINK I'M GETTING CLOSER. AS A REMINDER I AM USING EXCELL 2007 WITH XP AND AM NOT SURE IF THE DOWN LOAD IS IN THE RIGHT PALCE I HAVE NOT YET BEEN ABLE TO USE...
Thanks a lot ! I was not using ">" in front of Table Name. As a consequence, results were unpredictable to say the least ! It is obviously an "User Error" due...
I tried using following function =RCHGetTableCell("http://finapps.forbes.com/finapps/AccountingRisk.do? tkr="&$A$33,C$2,">AGR",,,,$B33) Where $A$33 = "DRYS" ...
No need to skip rows, or even columns for that matter, to get the data. They have both the "AGR" description and the value in the same table cell. This works...
Although not recommended, you can put the add-in anywhere you want. However, if you don't use the recommended directory, you will have problems using workbooks...
I PRINTED THE ATTACHED EMAIL AND TRIED TO FOLLOW IT EXACTLY, BUT I GOT 'FILE RCH_STOCK_MARKET_FUNTIONS' IS PASSWORD PROTECTED'. PLESE ENTER PASSWORD. PLEASE...
IN ADDITION TO THE BELOW I HAVE REDOWN LOADED THE FILES AND IT STILL GIVES ME THE MESSAGE UNABLE TO OPEN HTTP://F1.GRD.YAHOOFS.COM/PROGRAM FILES\SMF...
That sounds like you are trying to open one of the XLS template files. You would get a message similar to that until you have the add-in activated. It can't...
These element numbers should help, although the expense ratio item only works for mutual funds: *# **Source**Element* 5099YahooRKFund Risk -- Beta -- 3-Year --...
Thanks Randy. FYI - I want to capture beta, expenses etc, for each fund then calculate my portfolio's beta & expenses. Last question, is it possible to...
Sure. Easiest way is probably to use the smfPricesBetween() function. For example, if the ticker symbol is in cell A1 and the date is in cell B1, then this...
Hi Randy, I just started using the add-In functions to get the financial data from advfn website using your template. if a company has data for >5 yrs but...
Possible, but not trivial. AdvFN presents their data in the reverse mode of most other services so it's not easy to go backward other than in multiples of 5....
Sector and Industry Encoding Looking through the selection of sector and industry codes I see there are a few alternatives. Here would be my list of "nice to...
Thanks for the link to the Forbes site. I visited the page you linked and it looks like yet another great source for data. I feel like a kid in a candy store...
Randy, I only use 2 of the functions in your add-in (incredible job, by the way). Is there an easy way to import those functions into my workbook so I don't...
It would depend on the functions. I have been looking at slicing and dicing everything into "atomic" modules so that it would be easier to separate them out....
Hi Randy can u pl make custom function or give me guidance that how to extract this URL Data in your functions. This site i found is for getting live data of...
Why wouldn't you just grab it directly from the source page using RCHGetTableCell()? As far as I can tell, the URL you gave is just a preprocessor that gets...
Thank you very much Best Regards, Anand M. Bohra ... From: Randy Harmelink <rharmelink@...> To: smf_addin@yahoogroups.com Sent: Tuesday, 6 November, 2007...
