Search the web
Sign In
New User? Sign Up
smf_addin · EXCEL Stock Market Functions Add-in
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
  Newest  |  < Newer  |  Older >  |  Oldest
Topics   (List as Individual Messages) Messages Latest Post

Randy, Let me first compliment you on creating a revolutionary piece of software that, for the first time, single-handedly equalizes the playing field between...
4 9:22 am
Douglas
jurisdoctor74
Offline Send Email

Please use this thread to document ticker syntax that changes going from Yahoo to other data providers. For example, the latest syntax translation I added was...
1 3:29 am
Randy H
rharmelink
Offline Send Email

Hi Randy, I have not been able to get smfPricesByDates(Symbol, Date) to work for several symbols .... CSGH, NEWN, and CHWY. Other symbols work fine. Any...
2 3:23 am
Randy Harmelink
rharmelink
Offline Send Email

Randy, finviz.com is a new web source from which stock it may be possible to download stock data using your routines. -- RJ Emery...
4 2:59 am
Randy Harmelink
rharmelink
Offline Send Email

Randy, This is, and has been, an excellent add-in, and I've gotten quite dependent on it. It runs fine with Excel 2k7 and WinXP Pro, but I'm having a...
2 2:49 am
Randy Harmelink
rharmelink
Offline Send Email

Where is a good place to pull dividend dates? I find Yahoo a bit inconsistent. I have a dividend strategy that works well, it is a lot of work to screen for....
2 Dec 24, 2009
4:07 pm

Randy Harmelink
rharmelink
Offline Send Email

All - Does anyone have a source for getting open interest for an individual option? For example on the GE 17.50 call, I want to be able to view the day-to...
8 Dec 24, 2009
10:40 am

WildKutie72
presentsigi
Offline Send Email

I am looking to pull ADJ CLOSE from Yahoo finance for multiple tickers in a table format: ADJ CLOSE MSFT IBM .. .. .. GOOG 1/20/2009 1/21/2009 1/23/2009 .. .. ...
7 Dec 23, 2009
8:14 pm

Gaurav Rastogi
LuvIsAllAround
Offline Send Email

On Morningstar page, http://quicktake.morningstar.com/FundNet/Snapshot.aspx?Country=USA&pgid=hetopquote&Symbol=vtsmx or http://tinyurl.com/277ckc I have been...
14 Dec 23, 2009
7:05 pm

Randy Harmelink
rharmelink
Offline Send Email

Just uploaded a stock screener workbook that pulls data from finviz.com, then allows you to filter (screen) on it from within Excel. It also allows you to...
6 Dec 23, 2009
2:11 pm

bobsledproductions
bobsledprodu...
Offline Send Email

Hi folks, 1. I'm trying to setup the Expense Ratio column for various ETFs. If I'm not mistaken, the proper function is "=RCHGetElementNumber("XLF",5079)....
2 Dec 23, 2009
3:01 am

Randy Harmelink
rharmelink
Offline Send Email

Hello, I was pointed to this group from someone on the TC2000 yahoo group. I've been trying to retrieve price and percentage change data for stocks using the...
23 Dec 22, 2009
10:20 pm

polomorabe
Offline Send Email

Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the smf_addin group. File : /Add-In...
207 Dec 22, 2009
7:56 pm

smf_addin@yahoogroups...
Send Email

I know there's an element number that returns a ticker's industry; but is there an element number that returns the Company's name? John...
5 Dec 22, 2009
6:56 pm

Martin Topper
mtopper
Offline Send Email

Hi Randy, In an earlier message, you recommended another company's ADD-IN for tech functions. I was unable to load the TA-LIB add-in, so I am learning how to...
3 Dec 22, 2009
4:20 pm

john_smithman
Offline Send Email

Hi I need a little help. I modifing a Spreadsheet that uses the =RCHGetElementNumber(Symbol,X). The probelm I'm having is that the spreadsheet uses two...
9 Dec 22, 2009
7:10 am

john_smithman
Offline Send Email

Could someone help me with the code for getting IBD scores. Thanks, David...
2 Dec 22, 2009
3:40 am

Randy Harmelink
rharmelink
Offline Send Email

Source Yahoo Finance. Once you type in any symbol, it gives you a menu on the left side with links - quotes, charts, news and info, company... etc each with...
4 Dec 21, 2009
3:53 pm

Randy Harmelink
rharmelink
Offline Send Email

Hi Randy (or anyone else who is able to help), I'm trying to retrieve the exit price of a fund from ninemsn (MSN in Australia), for example at the following...
2 Dec 20, 2009
11:07 pm

Randy Harmelink
rharmelink
Offline Send Email

Can anyone give me some guidelines as to how I could use the smf add-in or one of the templates to extract data from the following site. finviz.com On the main...
13 Dec 20, 2009
7:45 pm

Randy Harmelink
rharmelink
Offline Send Email

Hello, On a separate note, I was reading the documentation for the functions RCHGetTableCell() and RCHGetWebData(), and was wondering if it possible to use one...
4 Dec 20, 2009
6:39 pm

Randy Harmelink
rharmelink
Offline Send Email

Randy, I had started this on a previous thread, but now have made it separate, since I want to present the query with an example. I open a new work book, it...
3 Dec 20, 2009
4:12 pm

davey_11372
Offline Send Email

Just added an Industry Overview workbook (leveraging SMF Lite). This allows you to monitor daily performance of the Yahoo specified industries, as well as the...
2 Dec 20, 2009
8:23 am

PLA
option2z
Offline Send Email

For those who query Options Clearing Corporation for Volume, Put/Call ration, statistics be advise their website is changing to this: ...
1 Dec 20, 2009
3:09 am

donald
donalddon5
Offline Send Email

Hey Randy, I would like to follow-up on a reference made to page views at IBD a while back. Each time one of us uses the add-in to acquire data from a...
2 Dec 19, 2009
8:45 pm

Randy Harmelink
rharmelink
Offline Send Email

Randy, two things: 1. Any thoughts about migrating the smf elements files to sit on a server some where? Users could then more easily decide whether they...
3 Dec 19, 2009
1:57 pm

bobsledproductions
bobsledprodu...
Offline Send Email

I just tried to create a sheet using AFN as my source because I liked the 10 years of data. I am using the newest SMF files and looked at the Element...
2 Dec 18, 2009
12:05 pm

Randy Harmelink
rharmelink
Offline Send Email

Any means of retrieving the S&P and/or Morningstar STAR rating for any given equity?...
2 Dec 18, 2009
12:13 am

Randy Harmelink
rharmelink
Offline Send Email

element # codes for Google annual revs not working. Seem to be grabbing the wrong row (used to work). How can i fix? =RCHGetElementNumber("MMM",3308) same for...
2 Dec 17, 2009
8:03 pm

Randy Harmelink
rharmelink
Offline Send Email

Randy - I use this to calculate equity growth in a Rule #1 type valuation template. Any idea on why this changed and where I could get a substitute value? ...
4 Dec 17, 2009
7:07 pm

Randy Harmelink
rharmelink
Offline Send Email
  Newest  |  < Newer  |  Older >  |  Oldest
Advanced
Add to My Yahoo!      XML What's This?

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