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 ...
18319
codyklein
Apr 29, 2012 1:27 pm
If you are using third party addons you should use excel32. Read this from microsoft: ...
18320
ccrunning22
Apr 29, 2012 4:50 pm
Thanks for the update!...
18321
MikeM
mikemcq802
Apr 30, 2012 2:38 am
I tried to follow the instructions in the LINKS section about user-defined functions but I can't get my first attempt to work. I created a text file named...
18322
Randy Harmelink
rharmelink
Apr 30, 2012 4:44 am
Unfortunately, one drawback of that way of defining an element is that it uses the EVAL() VBA function. That has problems with long strings -- it errors out if...
18323
bizmark_ee
Apr 30, 2012 7:55 am
How do I get notified when a new file has been uploaded? Thanks....
18324
Randy Harmelink
rharmelink
Apr 30, 2012 8:59 am
The person that uploads it can toggle a switch that tells the Yahoo group to issue an email announcing that it has been uploaded. Otherwise, the only way is to...
18325
MikeM
mikemcq802
Apr 30, 2012 12:46 pm
But, the string for the function I am trying is only 86 characters. In fact, my string is shorter than the ones you use in elements-9.txt for numbers 807 and...
18326
newengwongpeggy
Apr 30, 2012 1:57 pm
hi, anyone have issue with ADVFN? it has not been working for few days for me....
18327
MikeM
mikemcq802
Apr 30, 2012 2:18 pm
Working fine for me today and previous days. Have you reviewed the Links section: http://finance.groups.yahoo.com/group/smf_addin/links And, we'll need more...
18328
Lal Echterhoff
bigzippy...
Apr 30, 2012 2:28 pm
On my laptop this is disabled and the add in still works fine but on my work cpu I(cant accses IE security on this) still get error both use same poer sys...
18329
newengwongpeggy
Apr 30, 2012 3:14 pm
my version:Stock Market Functions add-in, Version 2.1.2010.08.02 i just found out i use the =RCHGetElementNumber(Sym,3) to get the exchange that the stock is...
18330
Randy Harmelink
rharmelink
Apr 30, 2012 3:57 pm
It's not the length of the function itself that is the problem. It's the length of what is being returned from the function invocation. For ticker MMM, it's...
18331
Randy Harmelink
rharmelink
Apr 30, 2012 4:06 pm
If IE security is the problem, I have no way to help. In your browser, were do you end up if you tell it to go to "advfn.com"? Do you end up at...
18332
Randy Harmelink
rharmelink
Apr 30, 2012 4:08 pm
You probably need the new smf-elements-1.txt from the "Works in Progress" folder. MSN recently revamped their web page structure and content, so most of their...
18333
obanduzzy
Apr 30, 2012 4:50 pm
Hey Randy, I've noticed glitches with elements 213-222 223-232 163-172 ROE, ROA, and P/E datapoints. Though I'm not completely convinced when I 'updated" the...
18334
Randy Harmelink
rharmelink
Apr 30, 2012 4:53 pm
Thanks, I'll take a look at them. The ones I did fix were ones that were in templates, so I had some way to specifically check and see if "Error" was coming...
18335
obanduzzy
Apr 30, 2012 4:58 pm
... well clearly msn just likes to give people grief. well you mostly and us secondarily. I have to say I'm in awe of this add in. You have done an amazing...
18336
B B
kokdari82
Apr 30, 2012 10:31 pm
It also seems like element 25 is broken because they removed the "last price" text. Element 25 now brings up yesterdays closing price. On another note, yahoo...
18337
Randy Harmelink
rharmelink
Apr 30, 2012 10:45 pm
Element 25 is an MSN problem. It's what they are reporting for "Last Price". You should use RCHGetYahooQuotes() for current quotes. The...
18338
B B
kokdari82
May 1, 2012 6:10 am
Thanks for that suggestion but one reason I like to stay away from yahoo to get prices is because pink sheet stock symbols require .pk at the end otherwise...
18339
Randy H
rharmelink
May 1, 2012 9:03 am
I wouldn't use the smfGetTagContent() that way, because you have no idea if the last data will always be the 12th item in the list. Also, I found I was doing...
