Is there a template or some other method for obtaining ALL listed Companies in Yahoo, name and ticker. I searched messages but could not find anything. I see...
16008
Randy Harmelink
rharmelink
Oct 2, 2011 2:19 am
No easy way to do it that I know of. I can't see the value -- it would probably change daily anyway....
16009
RobbR
aslanspirit
Oct 2, 2011 2:50 am
OK, Thanks. Just Something I wanted to try. Robb...
16010
Ralph
ralphbag
Oct 2, 2011 3:18 pm
This might work. Go here: http://www.americanbulls.com/StockList.asp?MarketTicker=AMEX&Tick=A . You can get all if you select each letter tab . If you have...
16011
Scott Jackson
scottandrewj...
Oct 2, 2011 4:25 pm
If you run a yahoo stock screen with no criteria, that might work. Scott Sent from my iPhone...
16012
jcarlosd
Oct 3, 2011 11:44 am
It works, not exactly with an empty search. You need to enter a double asterisk. You can get all stocks (more than 146k!!!) with: ...
16013
shadowemailclone
shadowemailc...
Oct 3, 2011 2:58 pm
Hi all, I am having an issue with the Morningstar Key ratios excel file. I sometimes use it to get the various profitability ratios and how they have changed...
16014
cy.dufort
Oct 3, 2011 5:35 pm
I'm trying to better understand the following ratios.. where can I find documentation to explains how these ratios are calculated? Thanks YCD Financial Ratios...
16015
Randy Harmelink
rharmelink
Oct 3, 2011 5:40 pm
Sorry, but MorningStar has been changing their pages to be dynamic delivery of the data. The add-in extracts data from the source code of the web page, so when...
16016
Randy Harmelink
rharmelink
Oct 3, 2011 5:43 pm
You'd have to go to the source of the data. For most elements, you can use "Source" and "P-URL" in place of the ticker symbol in the RCHGetElementNumber()...
16017
scottandrewjackson
scottandrewj...
Oct 3, 2011 9:29 pm
Randy is there any way to pull the CUSIP number using the RCHgettable function? I tried and am coming up with no results. Best Scott...
16018
Randy Harmelink
rharmelink
Oct 3, 2011 10:00 pm
Only if you have a data source that has the data in a table that the add-in can extract the data from... I had to use the smfGetTagContent() function on the...
16019
RobbR
aslanspirit
Oct 3, 2011 10:35 pm
Really good stuff. I see the starting or landing page. So, just trying to get my head around the process, can you give some direction on how to utilize SMF...
16020
RobbR
aslanspirit
Oct 3, 2011 10:36 pm
Very helpful. Good manual list. Robb...
16021
Randy Harmelink
rharmelink
Oct 3, 2011 10:39 pm
That's why I said no easy way -- you'd have to grab them page by page, 20 at a time. Why do you even need them?...
16022
RobbR
aslanspirit
Oct 3, 2011 10:53 pm
I know it sounds strange, but I am constructing a demonstration of the power of Excel as one way to demo some excel modeling to potential employer. It's...
16023
Randy Harmelink
rharmelink
Oct 3, 2011 11:21 pm
I see no reason to know about all of the available companies for any of those purposes. You should use a simple screening product to determine which companies...
16024
RobbR
aslanspirit
Oct 4, 2011 1:43 am
Thank you, you are coorect it woulde very slow and I see the add hoc nature of SMF. I am going to reasess. Thanks, Robb...
16025
Farhan Ansari
farsdocs
Oct 4, 2011 10:01 am
Hi all, I had a query not related to the SMF Add-in (all praise to Randy and I apologize to the group to ask an off topic question). But does any body know how...
16026
Randy Harmelink
rharmelink
Oct 4, 2011 3:10 pm
You'd need to write your own VBA timing routine to do the process. But, seriously, if you need that kind of data, get a proper data service provider....
16027
Farhan Ansari
farsdocs
Oct 4, 2011 3:27 pm
Thanks Randy, so yes I am having the data service provider but the problem is that I am only able to get the real-time data updated in a particular cell....
16028
antonvanas1989
Oct 4, 2011 6:17 pm
Dear , I got my spreadsheet and use the information from advfn, now i would like to link dates automaticly to the date that advfn is giving. at the first row...
16029
Randy Harmelink
rharmelink
Oct 4, 2011 6:52 pm
How about some variation of: =DATE(LEFT(C2,4),RIGHT(C2,2)+1,1)-1 =DATE(LEFT(C2,4),RIGHT(C2,2)-11,1) ...where C2 contains the date string like "2010/12"....
16030
bushpilote@...
bushpilote
Oct 5, 2011 11:59 am
Hi Randy, I have been unable to pull P/E ratios from ""http://online.wsj.com/mdc/public/page/2_3021-peyield.html?mod=mdc_h_usshl"; with the function recommended...
16031
romainrouphael
Oct 5, 2011 3:07 pm
Hi, I have exactly the same issue. Do you know why? Best Regards, Romain...
16032
Randy Harmelink
rharmelink
Oct 5, 2011 3:13 pm
Simple as pie: =RCHGetHTMLTable("http://online.wsj.com/mdc/public/page/2_3021-peyield.html",">Dow Industrial",-1,"",1)...
16033
Randy Harmelink
rharmelink
Oct 5, 2011 3:14 pm
Exact parameters, please....
16034
romainrouphael
Oct 5, 2011 3:37 pm
Yeah, sorry, i'm new on the forum. I use Windows XP, French version of Excel 2007, The other functions work properly but when i open files with examples of...
16035
Randy Harmelink
rharmelink
Oct 5, 2011 3:49 pm
French could be an issue. VBA functions don't translate properly unless regional settings are U.S. It's probably erroring out on the first conversion of string...
16036
romainrouphael
Oct 5, 2011 6:03 pm
Thanks for your help ! Indeed i had to change my local and language settings from France to US and it works! Best regards, Romain...
