Hi Randy, element number 13862 (company name) still does not appear to be working in the updated smf-elements-1 file...
18289
Randy Harmelink
rharmelink
Apr 27, 2012 1:51 pm
Looks like an MSN problem -- that's what I saw on the web page the data was retrieved from. It looks fine now, so it could have been an issue with them...
18290
smf_addin@yahoogroups...
Apr 27, 2012 2:01 pm
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the smf_addin group. File :...
18291
Randy Harmelink
rharmelink
Apr 27, 2012 2:02 pm
Just uploaded a new copy with a fix for that element......
18292
Lawrence
lawleesh
Apr 27, 2012 3:06 pm
Hi Randy Where can I find this fix? regards LL...
18293
Randy Harmelink
rharmelink
Apr 27, 2012 3:30 pm
In the "Works in Progress" folder of the files area. There should have been two announcements this morning that the file was uploaded......
18294
Douglas
jurisdoctor74
Apr 28, 2012 5:47 am
I can understand why changing the MSN URL would immediate invalidate the MSN elements and the fix is clearly straightforward. However, I noticed that the...
18295
peter_sagg
Apr 28, 2012 5:49 am
Randy, thank you very much for these wonderful add-ins of yours. I would like to find a quick way of downloading Open/High/Low/Close from Yahoo!Finance after...
18296
Mark
mballard34a
Apr 28, 2012 6:00 am
Hi Randy, Element 1 also seems to still be not working. Thanks for all the time you put into this! Mark...
18297
Matt
mattschofiel...
Apr 28, 2012 7:02 am
I can get the company name definition to work with the new file, but the description (i.e. element 1), returns: Financial data in <span>...
18298
chris.landqvist
Apr 28, 2012 7:09 am
Hi Randy (and all others), when I try to get the company information in: RCHGetElementNumber(IBM,1) It returns something really weird in the box when I usually...
18299
invesco88
Apr 28, 2012 7:09 am
Can anyone get the Cash Flow Model 17S working? I get errors throughout the entire workbook. It wont even pull up the latest price. Any ideas on how to fix...
18300
Patrick Van Beesen
patrickvb
Apr 28, 2012 7:22 am
Try this. uk in place of WWW, it works with fr sAdvFNPrefix = "uk"...
18301
Randy Harmelink
rharmelink
Apr 28, 2012 7:25 am
I can't think of a reason why they would stop working... And, the fix was not all that straightforward. Although many element definitions were fixed with the...
18302
Randy Harmelink
rharmelink
Apr 28, 2012 7:28 am
Are you sure that RCHGetYahooQuotes() returns after-market activity? I've never seen that. But I don't specifically grab any EOD quotes either. I don't think...
18304
nk1165
Apr 28, 2012 10:53 am
The trouble with the RCHGetYahooHistory Dividend default sorting is that it is newest to oldest (descending). In order to use Excel VLookup the data must be...
18305
Randy Harmelink
rharmelink
Apr 28, 2012 11:22 am
Thanks for the heads up! The fix for element #1 will be in the next upload of the element definitions file. (...not real fond of MSN at the moment...)...
18306
Randy Harmelink
rharmelink
Apr 28, 2012 1:31 pm
You could just use a MATCH() and INDEX() function to replicate the VLOOKUP. MATCH() will allow the search to be done as ascending or descending. Or the MATCH()...
18307
chrispycrunch
Apr 28, 2012 1:40 pm
Unrelated question for this add-on. How do you make the VBA compatible for excel 64? The system keeps prompting me to add PTRSafe around the code to make it...
18308
Randy Harmelink
rharmelink
Apr 28, 2012 1:41 pm
Not a clue here. Anyone else?...
18309
Laurance Hill
laurancehill
Apr 28, 2012 2:56 pm
Randy, Today I started having errors with RCHgetElementNumber for 25 and 46 which are part of a spreadsheet I have used for quite a while. I looked through my...
18310
Randy Harmelink
rharmelink
Apr 28, 2012 3:31 pm
It's an MSN problem. If I go to the AAPL print report right now, that page reports "Last Price" as $607.70. But it is actually the previous close....
18311
grabthecashanddash
grabthecasha...
Apr 28, 2012 4:08 pm
I've downloaded & ru Files > Templates and Examples > RCHGetYahooHistory. Works fine; thanx! I'd like to run this for multiple symbols, each with the same...
18312
Randy Harmelink
rharmelink
Apr 28, 2012 4:16 pm
Check the function documentation (in the "Documentation" folder of the files area)....
18313
Kermit W. Prather
kermitpra
Apr 28, 2012 4:50 pm
I’m running the SMF addin on vista 64 bit and win7 64 bit with no problems. I did nothing to enable the addin or VBA. I know this isn’t an answer but at...
18314
MikeM
mikemcq802
Apr 29, 2012 1:52 am
Randy, element 1285 doesn't seem to work anymore. I think Yahoo relocated that item. It now appears on their Summary page rather than the one you reference...
18315
investor952
Apr 29, 2012 2:47 am
I just tried to execute a spreadsheet that has this equation which identifies the 5 year dividend growth, and for each ticker, I get a blank. Is anyone else...
18316
investor952
Apr 29, 2012 3:07 am
I just tried one of my spreadsheets with this function and item 64 (5 year dividend growth) is returning a blank. How do I fix this? Thanks....
18317
investor952
Apr 29, 2012 3:56 am
... Looks like I just fixed this problem by downloading your updated file in your works in progress folder..didn't think to look there at first....
18318
Randy Harmelink
rharmelink
Apr 29, 2012 6:08 am
You must have missed all the messages on the group about MSN web site changes... After exiting EXCEL, replace the new smf-elements-1.txt file in your SMF ...
