Randy ... downloading the file solved the problem ... thanks Richard From: Randy Harmelink Sent: Sunday, May 29, 2011 7:42 AM To: smf_addin@yahoogroups.com ...
14609
JCHyjun
Jun 1, 2011 12:53 pm
14610
adar4ik
Jun 1, 2011 8:12 pm
Hello! I have downloaded the add-in and extrancted it into program Files\SMF add-in\ folder. I treid to use some templates to see how is it working but I get...
14611
Bob
bbockjr
Jun 1, 2011 8:13 pm
I just began using this SMF Add-In yesterday and it seems to be just what I need. However, when I first load my workbook, which includes about 350 cells spread...
14612
Randy Harmelink
rharmelink
Jun 1, 2011 8:19 pm
Documentation is in the "Documentation" folder of the files area. Tips and FAQ are in the "Links" area of the group. One item from the "links" area of the...
14613
Randy Harmelink
rharmelink
Jun 1, 2011 8:25 pm
See this item from the "Links" area of the group, which has usage tips and FAQ: http://finance.groups.yahoo.com/group/smf_addin/message/11346 Also, you should...
14614
Anant Upadhyayula
uanant...
Jun 2, 2011 12:43 am
Hi, based on the ticker, is there a way to find out which exchange it was listed on. i.e. F is on NYSE TSLA is on NASDAQ thanks Aku Hi, based on the...
14615
Randy Harmelink
rharmelink
Jun 2, 2011 1:42 am
Use a Yahoo code of "x" with the RCHGetYahooQuotes() function....
14616
Richard H. Wolf
RHWOLF
Jun 2, 2011 12:43 pm
Randy: I am trying to download to excel for mac the following stock data from the web: price, 52 wk high, 52 wk low, P?E, PEG, div yield from any free source....
14617
Randy Harmelink
rharmelink
Jun 2, 2011 12:44 pm
Sorry, but I know practically nil about Macs....
14618
Frederic Herrmann
luluka123456
Jun 2, 2011 6:16 pm
Hi, thanks for the extreme fast response. I have attached a screen shot what happend after I have replaced the hard coded formula. Do you have an ideas? ...
14619
Randy Harmelink
rharmelink
Jun 2, 2011 6:24 pm
I still see hard-coded locations in front of the function invocations -- they are what need to be replaced. What did you replace? PS: If replying to a digest,...
14620
darklordrises
Jun 3, 2011 8:10 am
Guys, does anyone know how to import/write similar finance functions in Access? What I need is very simple, just the last price and some sort of intra day high...
14621
Anant Upadhyayula
uanant...
Jun 3, 2011 3:22 pm
Hello, I am getting this error, "Too Many Webpage retrievals" Is it common, i mean I have not used this much but just want to know how to  overcome this...
14622
Randy Harmelink
rharmelink
Jun 3, 2011 3:59 pm
Because of the way the add-in extracts data from web pages, you get that whenever you have tried to pull data from more than 1000 web pages in a single...
14623
Anant Upadhyayula
uanant...
Jun 3, 2011 7:08 pm
I mean there are 2810 definitions in AdvFn. This gives all financials data required for stock analysis, I am using RCHgetElementNumber() to retrieve the...
14624
Randy Harmelink
rharmelink
Jun 3, 2011 7:20 pm
There are 2810 ANNUAL data elements for AdvFN. That's 2 web pages per ticker symbol....
14625
Anant Upadhyayula
uanant...
Jun 3, 2011 10:09 pm
Hi, I can get the exchange information like this RCHGetElementNumber(Ticker,3). This works great in excel and pulls the relevant exchange information. What...
14626
Randy Harmelink
rharmelink
Jun 3, 2011 10:55 pm
Check the "Links" area of the group.......
14627
Bob
bbockjr
Jun 4, 2011 4:35 pm
Thanks for the array suggestion - it speeds up the opening of the workbook tremendously. I still get the link error message, though. I tried to do the "replace...
14628
Randy Harmelink
rharmelink
Jun 4, 2011 4:42 pm
You need to replace the path that YOU have in the cells, not the one in the previously mentioned link. And once you've removed the links and saved the ...
14629
Market Monk
marketmonk777
Jun 4, 2011 5:00 pm
Hi, That is true. Yahoo is using the older Morningstar Industry Classification system. It's a 3 level system. I discuss this in a new Yahoo group I created in...
14630
alexander
life2539
Jun 5, 2011 4:35 am
Hi, I've noticed that there are "lite" versions of specific addins. I am interested in a consolidated one if that were possible. I was thinking that if an...
14631
iradave
Jun 5, 2011 5:50 am
Hi All, New user of SMF here using version 2.1.2010.08.02. Most of what I've tried to do has worked great. (Thanks Randy!) I didn't see this in the messages -...
14632
Randy Harmelink
rharmelink
Jun 5, 2011 6:02 am
I would quibble with there being "proper yearly data" -- go back and look at the URL you give for ACE. You'll see that because it's a financial institution, it...
14633
kharatm2001
Jun 5, 2011 6:03 am
Hi All, I am trying to generate a table for 400 companies, which its rows are dates (for a period of 3 months) and its columns are the companies. The elements...
14634
Randy Harmelink
rharmelink
Jun 5, 2011 6:10 am
1. Actually, 40562 is a date. A worksheet cell has a value AND a format. Just format that value as a date and you should be fine. EXCEL serial dates are just...
14635
Randy H
rharmelink
Jun 5, 2011 12:13 pm
You could certainly create your own "lite" version by copying over the VBA code and then setting the proper reference libraries. The .txt files would need to...
14636
iradave
Jun 5, 2011 3:52 pm
Randy, DUH - I missed the fact that most of the ones missing data were either classified as Financials or Healthcare. Thanks again, Ira...
14637
Steven
stevenletzer
Jun 6, 2011 2:34 pm
Has anyone worked on the Fox Business website? For example: http://quote.foxbusiness.com/symbol/ge/financials. For a simple GetTableCell on the financials...
