Hi Randy & all, I have downloaded the add-in just in order to view a spreadsheet based on Graham's formula. I find the add-in very useful and interesting, so I...
6301
anthonylm22
Apr 3, 2009 1:06 am
Hi guys, Is there any way to modify this template: RCHGetTableCell-Template-Reuters-Annual-Financials.xls which retrieves annual financial information,...
6302
Randy Harmelink
rharmelink
Apr 3, 2009 1:43 am
Yes and no. A similar template can be set up -- to retrieve all the lines of the financial statement regardless of their content. However, since MSN nests...
6303
schumie_1
Apr 3, 2009 5:06 am
I have been playing with the valuepro excel template and it is fantastic. Quick (and probably dumb) question. What does PIGR stand for (plug in growth rate to...
6304
aaryika.mehta
Apr 3, 2009 6:42 am
Hi, Can i use this add in on Mac? How do I install it?...
6305
Randy Harmelink
rharmelink
Apr 3, 2009 6:43 am
Some tell me yes. Some tell me no. I have no direct experience....
6306
anthonylm22
Apr 3, 2009 12:20 pm
Thanks very much that's fantastic... appreciate you for taking the time for that...
6307
John French
john_french_...
Apr 3, 2009 4:49 pm
Randy, this is (polite cough) somewhat off topic but I was wondering if you knew how to (or even if it's possible) to post a message to a Yahoo Group...
6308
Randy Harmelink
rharmelink
Apr 3, 2009 6:57 pm
I don't see why not -- as long as the group allows email posting (some don't). It would just be a matter of sending the email to that group email posting...
6309
jackoblacko1
Apr 3, 2009 7:44 pm
Hi, I'm thinking about translating your code to VB.NET and post it on CodeGallery (http://code.msdn.microsoft.com/). Obviously I'll give you all the credit for...
6310
Randy Harmelink
rharmelink
Apr 3, 2009 7:48 pm
Sounds OK to me......
6311
jackoblacko1
Apr 3, 2009 8:35 pm
Hi, I'm thinking about porting your code to VB.NET and post it on CodeGallery. I will give you all the credit for it and point people to this group. I assume...
6312
John French
john_french_...
Apr 3, 2009 8:53 pm
Randy, thanks very much. I will endeavor to get this working over the w/e. John...
6313
fdasar78
Apr 4, 2009 1:36 am
I used parameters 7789-7795 and 6589-6605 to extract ROCI and free cash flow respectively (from ADVFN website). When I checked them with data from website,...
6314
Randy Harmelink
rharmelink
Apr 4, 2009 3:24 am
More details needed. Is your problem that you have the element numbers incorrect? I see ROCI as elements 7786-7795 and free cash flow as elements 6596-6605. ...
6315
John French
john_french_...
Apr 4, 2009 1:20 pm
Randy, sorry to bother you on this again. I used your code and get the message "The transport failed to connect to the server". Areas of contention are 1. I...
6316
Randy Harmelink
rharmelink
Apr 4, 2009 3:26 pm
On Sat, Apr 4, 2009 at 6:16 AM, John French ... It's just a convenience thing for me. When I change it between the various values, it automatically changes...
6317
John French
john_french_...
Apr 4, 2009 3:58 pm
Randy, it was the port #. I have it working now. Thank you. John...
6318
Tom Cal
tcal64
Apr 4, 2009 7:10 pm
Other than actual SEC filings, does anyone know of sources on the web for "as reported" (i.e. non-standardized) financial statements, that precisely match the...
6319
jck_g
Apr 5, 2009 3:32 am
does smfGetCSVFile always return a 200x100 array? for example, data = smfGetCSVFile("http://www.google.com/finance/historical?q=NYSE:GKK&output=csv") this...
6320
Randy Harmelink
rharmelink
Apr 5, 2009 3:53 am
Sorry, but smfGetCSVFile() wasn't set up to be used in a VBA process that way. However, all the smfGetCSVFile() function does is call the RCHGetYahooQuotes()...
6321
saturn_005
Apr 5, 2009 4:38 pm
Randy, I've been using RCHGetYahooHistory for about a year to backtest ideas for various markets and it's worked great. I run a macro to send a list of...
6322
Randy Harmelink
rharmelink
Apr 5, 2009 5:57 pm
Sorry, but when you get to that level of activity, any number of things could be happening. I think you'd be better off with a different tool, say something...
6323
jck_g
Apr 5, 2009 7:17 pm
yep, that worked! now im gonna write a simple csv function that takes a url, row dim, col dim and have it call RCHGetYahooQuotes w/ that info. once again,...
6324
Larry Hill
laurancehill
Apr 6, 2009 7:56 pm
Randy, Do any of your macros access data from Investors Business Daily? In particular data from Stock Checkup. Stock Checkup can be accessed only if you are...
6325
Randy Harmelink
rharmelink
Apr 6, 2009 8:20 pm
I used the EXCEL Web Query process to login, then used the URL you gave below to extract data. I was able to. For example: Composite Rating 50 61 EPS Rating...
6326
michailparaskevopoulos
michailparas...
Apr 7, 2009 3:22 pm
Is there a way to access financial data related to companies based in Europe (Germany, Norway, UK etc)? I am especially interested in balance sheet, income...
6327
Randy Harmelink
rharmelink
Apr 7, 2009 3:30 pm
If AdvFN has the data for the companies you're interested in, you should be able to grab it. It would just be a matter of changing the URL's and/or symbols....
6328
michailparaskevopoulos
michailparas...
Apr 7, 2009 4:03 pm
I test the getelementnumber function via advfn for some blue chips tickers (e.g. XE:SIE) but this does not seem to work. Will try the other services as well...
6329
Randy Harmelink
rharmelink
Apr 7, 2009 4:26 pm
RCHGetElementNumber() may not work. There may be other parameters that need to be changed for foregign companies, which RCHGetElementNumber() is not set up to...