I suspect you need the updated MSN element definitions -- see: http://finance.groups.yahoo.com/group/smf_addin/message/18529 For current quotes, you should use...
18768
oryxius
May 28, 2012 5:35 pm
Hello everyone, I am new here and I am still finding my way around, but I am quite impressed at the great work you guys have done, especially Randy. I am...
18769
Randy Harmelink
rharmelink
May 28, 2012 5:37 pm
A cell reference would be just: S18 ...not: "&S18&" That last item is a 5-character string literal, not a cell reference....
18770
smithjhhic
May 28, 2012 6:17 pm
I am attempting to retrieve the "All Equity Summary Score:" from Fidelity, but have an error in my formula. I'd like to return "Bullish (8.2)" from the pages...
18771
Gordon
gordonjones123
May 28, 2012 6:50 pm
I looked at the elements definitions and I seen no change from previous. I'm looking for the last price of a stock. The element # should be 25 to bring this...
18772
Randy Harmelink
rharmelink
May 28, 2012 7:08 pm
The RCHGetTableCell() function will not work, because the data is not within a table. You'll need to use the smfGetTagContent() function. Try something like...
18773
Randy Harmelink
rharmelink
May 28, 2012 7:11 pm
The smf-elements-1.txt file in the add-in's folder contains the element definitions for MSN. Those all had to be changed at the end of April because MSN...
18774
smithjhhic
May 28, 2012 8:07 pm
Randy, Thank you. It returned "<span class='tableCallout'>Bullish";. It did not pickup the "(8.2)". Did I do something wrong? Understand difficult to advise...
18775
Randy Harmelink
rharmelink
May 29, 2012 12:03 am
Yup. It's a span within a span, but the smfGetTagContent() is a very simple extractor and just looks for the next end of span tag. You'll need to use the...
18776
schlange.meister
schlange.mei...
May 29, 2012 1:23 pm
Hello All, I currently invest in dividend stocks that I would be happy to own for the foreseeable future and I let the dividends automatically be reinvested....
18777
Sudhir Agarwal
sudhir_agarwal1
May 29, 2012 1:49 pm
Hi , Covered call can be beneficial but writing for 1-2 months may not work out for you since the transaction cost may eat most of the profit. Also, I hope you...
18778
Amir
amir.rehman
May 29, 2012 3:12 pm
hi all, I am trying to pull data from http://finance.yahoo.com/q/in?s=MSFT about the competitors in excel but can't do so. Please help Thanks....
Kermit, The spreadsheets have been configured such that companies that do not have at least five years of sales and earnings are not analyzed properly. I have...
18781
Kermit W. Prather
kermitpra
May 29, 2012 5:43 pm
Sudhir is right on Since you are investing in the stocks already writing the Covered call is not a bad idea. That is I am assuming you live thru the large draw...
18782
Randy Harmelink
rharmelink
May 29, 2012 7:09 pm
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 ...
