In my experience, quality dividend stocks usually have very low premiums, high spreads, and bad liquidty on their options. On Tue, May 29, 2012 at 6:23 AM,...
18783
schlange.meister
schlange.mei...
May 30, 2012 6:27 am
Thanks all, It appears to be the case that the long term dividend stocks are not best for calls. I was looking to make a small incremental return in addition...
18784
smithjhhic
May 30, 2012 8:09 am
Randy, Thank you for your help....
18786
oryxius
May 30, 2012 5:33 pm
I am trying to download a table of the bottom signal stocks from Barchart.com. I am using the formula: ...
18787
Randy Harmelink
rharmelink
May 30, 2012 5:42 pm
That formula works fine for me. What results are you getting?...
18788
oryxius
May 30, 2012 6:20 pm
When I press CTRL+SHFT+ENTER for the array, excel just displays the formula in the highlighted cells. No results....
18789
Randy Harmelink
rharmelink
May 30, 2012 7:31 pm
Try it in a brand new workbook and see if you get the same results. There are reasons a formula will show up instead of the calculated results of a formula. ...
18790
lyle
ljb7011
May 30, 2012 9:14 pm
I am running excel 2007 and have confirmed my installation with the =RCHGetYahooHistory("MSFT";) test. My problem now is I cannot get any of the templates to...
18791
Randy Harmelink
rharmelink
May 30, 2012 9:17 pm
You may need to fix unresolved links (see the "Location errors" item in the LINKS area of the group). Otherwise, "it doesn't work" isn't enough of a...
18792
lyle burditt
ljb7011
May 30, 2012 9:48 pm
Basically when I type a ticker symbol into a template nothing happens. Usually just #NAME comes up in every box. ________________________________ From: Randy...
18793
Randy Harmelink
rharmelink
May 30, 2012 10:53 pm
Those are the unresolved links I mentioned. They have to be manually fixed....
18794
oryxius
May 31, 2012 3:49 am
Thank you Randy. One of the discussion threads you pointed me to mentioned that it is a formatting issue. So I copied the formula into a text pad and noticed...
18795
oryxius
May 31, 2012 4:31 am
Am I missing some update? All the MSN elements I tried are not working. I've just replaced my addin files with the addin file package in Works in Progress...
18796
Randy Harmelink
rharmelink
May 31, 2012 5:10 am
Did you replace the file after exiting EXCEL? The add-in loads the element definitions once, so if you replace the definitions file after that loading ...
18797
investor952
May 31, 2012 5:10 am
mine seem to be working fine now...
18798
oryxius
May 31, 2012 7:37 am
I did. I also ran the smfForceRecalculation macro. I also changed IE's Temp. Internet files setting to open new sites on every visit. Purged the temp. files...
18799
oryxius
May 31, 2012 7:54 am
OK, it's now working. I have found out that, for some quirky reason, if you choose to replace the old file when downloading, it somehow either windows does not...
18800
NicholasDavid
dnicholas4967
May 31, 2012 3:51 pm
Where do I go to download the current "Elements Definitions" .....thanks! ... From: "Gordon" <gordonj5@...> To: "smf addin" <smf_addin@yahoogroups.com> ...
Hi Randy,  I’m trying to input Revenue and Net Income from YahooFinance for a list of 100 companies for 2009, 2010, and 2011 into Excel...
18803
Ron Spruell
hashky
May 31, 2012 7:37 pm
Try =RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"annual",2,"Annual Data",,">Revenue") For Revenue Change the Cell# to move to the other years,...
18804
Christina Guo
cguo563
May 31, 2012 8:01 pm
Thanks for the help, Ron. But it's still giving me Error for some reason. I've attached my Excel sheet here. Thank you so much for you help! Â Christina ...
18805
Randy Harmelink
rharmelink
May 31, 2012 8:18 pm
You're getting errors because your URL is wrong. You're telling it to concatenate "annual" directly to the ticker symbol, so instead of a ticker symbol of MMM,...
18806
Christina Guo
cguo563
May 31, 2012 8:33 pm
Thank you so much, Randy! It works and I really appreciate it. Â Just one last quick thing: How would I change the formula for Net Income? I tried replacing...
18807
Ron Spruell
hashky
May 31, 2012 8:59 pm
You have to position the reference further down the page with something like "Other Items". There are several "Net Incomes" on the page. ...
18808
Christina Guo
cguo563
May 31, 2012 11:04 pm
Great, thanks so much! Everything works. ________________________________ From: Ron Spruell <hashky@...> To: "smf_addin@yahoogroups.com"...
18809
Christina Guo
cguo563
May 31, 2012 11:22 pm
Darn, I thought everything was running smoothly. But here's my spreadsheet once more. Do you know why the formula stopped working for the chunk of data from...
18810
Randy Harmelink
rharmelink
May 31, 2012 11:36 pm
Lines 49-86 worked fine here, except for those with bad ticker symbols....
18811
Kermit W. Prather
kermitpra
Jun 1, 2012 1:43 pm
It also worked for me. After changing the link to the SMF addin location. Kermit From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf...
18812
Christina Guo
cguo563
Jun 1, 2012 4:58 pm
I restarted my computer and loaded it again. Perfect. Thanks so much. ________________________________ From: Kermit W. Prather <kermitp@...> To:...
