It's returning 12.94 here. Which version of the add-in are you using? =RCHGetElementNumber("Version")...
22644
sri yanto
sri.yanto
Jun 17, 2013 9:39 am
i'am using addin version 2.1.2012.02.02 randy, there's any update of addin ? thanks...
22645
Randy Harmelink
rharmelink
Jun 17, 2013 10:33 am
The current official release is 2.1.2012.12.29. The formula isn't working for you because of a change made to smfStrExtr() in July of 2012, to allow the tilda...
22646
ridgebacksexcel
Jun 17, 2013 1:24 pm
I have caught this problem on a number of line items. The best way to fix it as Randy shows is to go to the source code, copy the line from the code and paste...
22647
ridgebacksexcel
Jun 17, 2013 1:43 pm
Randy, I saw somewhere on this site a code for extracting a Real Time Quote from the Yahoo Finance Summary page for a company. In this case AAPL. I am using...
22648
ultimatestockfinder
ultimatestoc...
Jun 17, 2013 2:18 pm
Randy, Thanks that sounds good to me. I will follow your instructions and see how often I need to manually make updates to the add-in. Thanks, John D....
22649
mahluwa
Jun 17, 2013 2:34 pm
Hi, Is there a problem with earnings.com, elements: 1286 onwards? I'm using latest version (released dec 12) but all fore-mentioned elements using...
22650
Randy Harmelink
rharmelink
Jun 17, 2013 2:59 pm
I'm not sure what to tell you. Your formula worked just fine for me. I just put AAPL into cell C2 and then copied and pasted it. And if I change the ticker...
22651
Randy Harmelink
rharmelink
Jun 17, 2013 3:06 pm
It looks like the website no longer exists. If I type the URL into my browser, I get redirected to: http://www.reuters.com/finance/markets/earnings ...so...
22652
weekeewawa
Jun 17, 2013 3:20 pm
hello randy, may i ask how do i extract files from ft from the respective pages 1) http://markets.ft.com/research/Markets/Tearsheets/Summary?s=GOOG:NSQ Past 90...
22653
ridgebacksexcel
Jun 17, 2013 4:09 pm
I was able to fix the problem. I actually had another formula buried in the same spot but hidden by a lot of spaces two rows down. Once I expanded the formula...
22654
the_drake_03
Jun 17, 2013 5:59 pm
Hello, I've been using Element for several years. I've searched all around the forum but can't find an answer. It seems like #25 last price has changed and we...
22655
Pete
petekoch
Jun 17, 2013 6:34 pm
The following comment works just fine: =RCHCreateComment("http://stockcharts.com/c-sc/sc?p=W&yr=0&mn=36&dy=0&i=t39628903145&r=9933&s="&Ticker,99,800,515) But...
22656
Kermit W. Prather
kermitpra
Jun 17, 2013 9:08 pm
For what it is worth, I have also run into problems where the retrieval using lower case did not work. I change the symbol to uppercase and it works just fine....
22657
Randy Harmelink
rharmelink
Jun 17, 2013 9:23 pm
The MSN data elements had to be redefined last year because MSN changed their site structure, so if you don't have the latest definitions you would get an...
22658
Randy Harmelink
rharmelink
Jun 17, 2013 9:28 pm
The positioning values only work if you have the comment box visible. They don't work if you have the comment box hidden. That's an EXCEL limitation....
22659
Pete
petekoch
Jun 17, 2013 10:06 pm
Thanks, Randy. I did look at the code, but I guess I missed it....
22660
the_drake_03
Jun 17, 2013 10:15 pm
Terrific!! GetElement(mmm, 25) does not work for me but GetYahooQuotes does. Thank you soo much!...
22661
Kermit W. Prather
kermitpra
Jun 18, 2013 12:36 am
Randy, I just uploaded this file -- Fails-on-upper-and-lower-case-symbols.xlsx -- to the Files <http://finance.groups.yahoo.com/group/smf_addin/files/> >...
22662
Randy Harmelink
rharmelink
Jun 18, 2013 2:11 am
I just tried getting all of the web pages in my browser at the same time. Many had a web page that simply said "Try later". So all of those will get "Error"...
22663
sri yanto
sri.yanto
Jun 18, 2013 2:16 am
thanks alot randy i'll update my addin thank bro...
22664
sjagers
Jun 18, 2013 12:15 pm
I had the Earnings.com website bookmarked and just tried it (below): Here's the URL for Adobe's earnings history, as an example: ...
22665
schlange.meister
schlange.mei...
Jun 18, 2013 12:34 pm
Hello Randy and Others, I have used a SMF sheet that I really like to find the best Call to write for ITM and OTM covered calls based on Return if exercised or...
22666
Kermit W. Prather
kermitpra
Jun 18, 2013 12:48 pm
Thanks, Randy That is very possible as I tend to have more activity during testing. I’ll try reducing the number of request. Do you have any suggestions on...
22667
Randy Harmelink
rharmelink
Jun 18, 2013 1:00 pm
I think they just don't have redirection turned on for your bookmarked " earnings.com" address. If you change your URL to "www.earnings.com", it doesn't work...
22668
Randy Harmelink
rharmelink
Jun 18, 2013 1:03 pm
Well, the various utility option functions can tell you what expirations and strikes are available, as well as which strikes are ITM or OTM. I don't do...
22669
Randy Harmelink
rharmelink
Jun 18, 2013 1:16 pm
The best way I know to limit retrieval is using the smfUpdateDownloadTable process, since it will only update rows of data until it finds an empty ticker...
22670
Paul Dyson
pdyson10
Jun 18, 2013 6:01 pm
Randy I realise that the website may get redirected soon but I thought I would try and create the data using the RCHGetTableCell function but I am getting...
22671
Randy Harmelink
rharmelink
Jun 18, 2013 6:41 pm
Your "row" parameter is in the wrong place. There are four search string parameters., Try something like: =RCHGetTableCell(" ...
22672
Randy Harmelink
rharmelink
Jun 18, 2013 8:06 pm
1. Your formula didn't work because zero makes no sense for where to find the table tags. =RCHGetHTMLTable(" ...
