Skip to search.

Breaking News Visit Yahoo! News for the latest.

×Close this window

smf_addin · EXCEL Stock Market Functions Add-in

The Yahoo! Groups Product Blog

Check it out!

Group Information

  • Members: 22966
  • Category: Software
  • Founded: Jun 18, 2006
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Messages

Advanced
Messages Help
Messages 22643 - 22672 of 22672   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand Author Sort by Date ^
22643 Randy Harmelink
rharmelink Send Email
Jun 17, 2013
9:26 am
It's returning 12.94 here. Which version of the add-in are you using? =RCHGetElementNumber("Version&quot;)...
22644 sri yanto
sri.yanto Send Email
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 Send Email
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 Send Email 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 Send Email 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... Send Email
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 Send Email 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 Send Email
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 Send Email
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 Send Email 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 Send Email 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 Send Email 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 Send Email
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 Send Email
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 Send Email
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 Send Email
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 Send Email
Jun 17, 2013
10:06 pm
Thanks, Randy. I did look at the code, but I guess I missed it....
22660 the_drake_03 Send Email 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 Send Email
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 Send Email
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 Send Email
Jun 18, 2013
2:16 am
thanks alot randy i'll update my addin thank bro...
22664 sjagers Send Email 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... Send Email
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 Send Email
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 Send Email
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 Send Email
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 Send Email
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 Send Email
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 Send Email
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 Send Email
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(" ...
Messages 22643 - 22672 of 22672   Oldest  |  < Older  |  Newer >  |  Newest
Add to My Yahoo!      XML What's This?

Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help