They're already included for mutual funds from MorningStar. However, you will need the updated element definitions in file smf-elements-4.txt from the "Works...
12651
Paint Lead
drleadbasedp...
Dec 30, 2010 7:19 pm
Ah! That did it! Thanks for the quick response!!...
12652
niky9
Dec 30, 2010 7:51 pm
Does the add-in work for Excel 2010? Followed all the install instructions but when I try tickers like PFE,JNJ, etc I do not get any updates? Any advice will...
12653
Randy Harmelink
rharmelink
Dec 30, 2010 9:06 pm
I have had reports of the add-in working with EXCEL 2010. The message you cite typically indicates that during the installation of MS Office, "Visual Basic for...
12654
Armando
aainmn
Dec 30, 2010 9:33 pm
Hi Randy, Is there a command to get the # of stars rating from Morningstar? i tired =RCHGetElementNumber($E6,5064) but it does not seem to work. Thanks, as...
12655
colobuyer123
Dec 30, 2010 11:17 pm
Hi there, Great stuff on the site! Can you tell me how to add more rows to the array that makes up the smfgetyahoohistory template?...
12656
Randy Harmelink
rharmelink
Dec 30, 2010 11:30 pm
That worked fine for me, using ticker VFINX....
12657
Randy Harmelink
rharmelink
Dec 30, 2010 11:32 pm
You just need to array-enter the formula over a larger range....
12658
Armando
aainmn
Dec 31, 2010 12:17 am
Is there another command that would work for non-mutual fund symbols like: EOD, ETB, ETJ, ETV, ETW that also have free Morningstar ratings? Thanks again. To:...
12659
Randy Harmelink
rharmelink
Dec 31, 2010 12:27 am
See: http://finance.groups.yahoo.com/group/smf_addin/message/9080 ...but you'll need to change the formula to use the correct URL for the type of ticker...
12660
mail_to_subu
Dec 31, 2010 6:55 am
Randy As I often say, I can't thank you enough for you help...in getting the data The data helps a lot But...but .... but .... I am sure you will agree that ,...
12661
Randy Harmelink
rharmelink
Dec 31, 2010 6:59 am
Believe me, I'm the last one you should ask. My method is paralysis by analysis....
12662
qec002
Dec 31, 2010 2:47 pm
I am new to this group. Where can I find this macro? QC...
12663
Randy Harmelink
rharmelink
Dec 31, 2010 3:15 pm
It's in the add-in. Check out the "Links" area of the group for info on the macro. Also, there is a template in the "Files" area......
Thanks Randy.  Unfortunately I'm an excel novice.  Can you tell me how to do that?Thanks in advance! ... From: Randy Harmelink <rharmelink@...> ...
12666
Randy Harmelink
rharmelink
Dec 31, 2010 3:53 pm
Try: 1. Select the new range you want the results to be in (should fully include the original range). 2. Press F2 to edit the formula. 3. Press...
12667
Jim Jones
colobuyer123
Dec 31, 2010 4:00 pm
Perfect it worked! One last question, can I get the frequency to be monthly in this sheet or do I need to use a different template? ... From: Randy Harmelink...
12668
Randy Harmelink
rharmelink
Dec 31, 2010 4:18 pm
That's what "Period" is for. Check the function documentation for the available choices....
12669
Gennady Kupershteyn
gennady17
Dec 31, 2010 4:39 pm
These elements are picking up the wrong EPS estimate date fields. It's grabbing from 2009, not 2010....
12670
colobuyer123
Dec 31, 2010 4:45 pm
Randy, can we access the Mstar data on funds related to expense ratio and tax cost ratio (1,3,5 yr etc?)...
12671
Randy Harmelink
rharmelink
Dec 31, 2010 4:51 pm
You can pull the expense ratio from the full print report of a fund, but I don't see a way to get the tax cost info......
12672
Jim Jones
colobuyer123
Dec 31, 2010 4:55 pm
I think I can get expense from yahoo through the add in. Â The tax cost is on mstar...
12673
Randy Harmelink
rharmelink
Dec 31, 2010 5:19 pm
Not with the add-in, because the data is placed dynamically on the page AFTER the original source code is sent. The add-in is designed to extract data from the...
12674
Jim Jones
colobuyer123
Dec 31, 2010 5:44 pm
okay, thanks Randy!!happy new year! ... From: Randy Harmelink <rharmelink@...> Subject: Re: [smf_addin] MStar data elements To: smf_addin@yahoogroups.com...
12675
Anant A. Wagh
anantwagh1986
Dec 31, 2010 6:29 pm
Dear Randy, First of all Thank You for the great add-in; very comprehensive and useful. Secondly, with all due respect, is it possible to be excluded from...
12676
Ken Strauss
kstrauss7
Dec 31, 2010 6:53 pm
The whole idea of this mailing list is to share knowledge. If that bothers you just set your Yahoo group preferences to "no email" or leave the SMF_ADDIN...
12677
Randy Harmelink
rharmelink
Dec 31, 2010 7:43 pm
Yahoo Groups doesn't have a way to deliver messages based on who the sender is. You can change your email settings for the group here: ...
12678
muji_mu
Dec 31, 2010 9:14 pm
I was an old user of MSN Stock Quote plugin to Excel, but after upgrading to Excel 2010 was severely out of luck. Just installed this into Excel 2010, and am...
12679
Randy Harmelink
rharmelink
Jan 1, 2011 2:50 am
Those elements are surprise HISTORY, not future estimates. I'm getting the correct dates for ticker MMM. What ticker are you looking at? Did you compare to the...
