Search the web
Sign In
New User? Sign Up
smf_addin · EXCEL Stock Market Functions Add-in

Group Information

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

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
Stay up to speed on the latest Groups news and updates, visit the Groups blog today!

Home

 

Activity within 7 days:

1 New Link - 38 New Messages

Description

This group is the home base for the Stock Market Functions add-in developed by Randy Harmelink. This add-in contains a number of user defined functions for EXCEL that can allow data to be extracted and/or retrieved from the web and placed directly into EXCEL cells or ranges.

The files area of this group contains the add-in, documentation on its functions, and a number of templates that have examples of how the various functions can be used. The add-in was developed using EXCEL 2002 under a WinXP operating system, so other platforms and/or versions may have issues.

If you're reporting a problem, remember that I'm not a mind reader -- "It doesn't work right" is not a helpful description of a problem. Please try to include relevant information, such as:

-- The specific function(s) or template(s) you are having problems with.
-- The parameter(s) you are using with the function(s).
-- The version of EXCEL you use.
-- The operating system you're running EXCEL under.
-- The steps you took to try to resolve the problem.
-- The ticker symbols or URLs that are being used.
-- The results you expect to get and what you actually get.

Most Recent Messages

  (View All)
(Group by Topic)
Advanced
   Start Topic
Re: IBD Stock Check Up Data
Here's the smfUpdateDownloadTable definition for Industry Group Rank that I did for an IBD group: RCHGetTableCell("
Posted - Mon Jul 6, 2009 1:40 am
Randy Harmelink
rharmelink
Offline Offline
Send Email Send Email
IBD Stock Check Up Data
Randy: Is there an example of capturing the newly reformated IBD Stock Checkup data in a Horizontal line format for a limited list of stocks, one per line? I
Posted - Mon Jul 6, 2009 1:11 am
rlschmidt3
Offline Offline
Send Email Send Email
Re: Daily volumes for the NYSE and the NASDAQ
Unfortunately, the RCHGetYahooHistory() function can only return the data that Yahoo is providing... You may be able to use something like this source:
Posted - Sun Jul 5, 2009 5:06 pm
Randy Harmelink
rharmelink
Offline Offline
Send Email Send Email
Daily volumes for the NYSE and the NASDAQ
I'm stuck. Using the RCHGetYahooHistory function, is there a way to get the daily volumes for the NYSE and the NASDAQ? I've used ticker ^NYA but it doesn't
Posted - Sun Jul 5, 2009 5:03 am
hjreed@...
hjreed...
Offline Offline
Send Email Send Email
Re: RIU RIE D/P
Those are acronyms related to the Covered Call workbooks: RIU = Return If Unchanged (that is, the price of the underlying security) RIE = Return If Exercised
Posted - Sat Jul 4, 2009 8:12 pm
Randy Harmelink
rharmelink
Offline Offline
Send Email Send Email
Add smf_addin to your personalized My Yahoo! page Add to My Yahoo! XML What's This?

Message History

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2009 234 122 220 224 157 263 28
2008 53 75 293 215 312 167 251 217 160 160 239 144
2007 230 145 172 188 181 243 255 241 239 273 165 161
2006 9 133 173 209 158 67 195

Group Email Addresses


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